Which key is used for help in Ms Excel...? Mcqs

PPSC Past Papers

Latest MCQs

Which key is used for help in Ms Excel...?

(A) F1
(B) F2

(C) F3
(D) None of these

Comments
Latest MCQs

in MS Excel what is function inside another function is called...?

(A) nested
(B) round

(C) switch
(D) none of these

Comments
Latest MCQs

What is the default file format for Excel spreadsheets...?

(A) .xlsx
(B) .doc

(C) .ppt
(D) .pdf

Comments
Latest MCQs

What is the extension of a Microsoft Excel file...?

(A) .msxcl
(B) .xcl

(C) .xlsx
(D) .xlsm

Comments
Latest MCQs

To edit in an embedded excel worksheet object in a word document:...?

(A) Use the excel menu bar and toolbars inside the word application
(B) Edit the hyperlink

(C) Edit the data in a excel source application
(D) Use the word menu bar and toolbar

Comments
Latest MCQs

How many columns are in one Microsoft Excel sheet...?

(A) 65,536
(B) 16,384

(C) 1,048,576
(D) None of Above

Comments
Latest MCQs

To add two cells (A1 and A2) together in MS Excel,formula is used:...?

(A) =A1+A2
(B) =Add(A1+A2)

(C) =together(A1:A2)
(D) A1 plus A2

Comments
Latest MCQs

Tab scroll buttons are place on excel screen...?

(A) Towards the bottom left corner
(B) Towards the bottom right corner

(C) Towards the bottom top right corner
(D) None

Comments
Latest MCQs

What is the function of the SUM function in Excel:...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find maximum value in a range of cells

Comments
Latest MCQs

Which of the following EXCEL feature allows users to evaluate values and return a result...?

(A) Formula
(B) Formating

(C) Filters
(D) None of these

Comments
Latest MCQs

How do you display current date and time in MS Excel...?

(A) Date ()
(B) Today ()

(C) Year ()
(D) Now ()

Comments
Latest MCQs

What is the keyboard shortcut to insert a SUM formula in MS Excel...?

(A) CRTL+ =
(B) ALT + =

(C) ALT + S
(D) CTRL + ALT+ =

Comments
Latest MCQs

User developed instruction for excel are called__________...?

(A) Progrms
(B) Macros

(C) Procedured
(D) All of these

Comments
Latest MCQs

Which among following wildcard characters are recognized by excel ...?

(A) +and -
(B) ; and ^

(C) * and ?
(D) <and >

Comments
Latest MCQs

#Value! Error in Microsoft Excel represents:...?

(A) The width of the cell is less to display the answer
(B) Parameter provided to the function is of wrong data type

(C) Value of the answer needs to be round off
(D) When Excel does not recognize the format

Comments
Latest MCQs

What is used to split long text in excel within the cell...?

(A) Wrap text
(B) Click next

(C) All
(D) None

Comments
Latest MCQs

Constant value in excel also called ...?

(A) Number
(B) words

(C) mark
(D) None

Comments
Latest MCQs

Which one is not a function in MS Excel:...?

(A) SUM
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

Which key is used to edit the selected cell in excel...?

(A) F2
(B) F10

(C) F4
(D) F8

Comments
Latest MCQs

Which of following is Not one of Excel's "what- if function?...?

(A) Goal seekyears?
(B) Gabriel's wing

(C) n M rightly guided
(D) Auto Outline

Comments
Latest MCQs

Title bar in MS-Excel displays name of the __________ ...?

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

Comments
Latest MCQs

Shortcut key of hide entire column in excel...?

(A) Ctrl + Shift + 0
(B) Ctrl + alt+ 0

(C) Shift + 0
(D) Ctrl+0

Comments
Latest MCQs

Which of the following you can paste selectively using Paste Specail command in MS Excel...?

(A) Validation
(B) Formats

(C) Formulas
(D) All of these

Comments
Latest MCQs

Press the enter key in all of the following circumstances except...?

(A) to insert a blank line into a document
(B) when the insertion point reaches the right margin

(C) to begin a new paragraph
(D) in response to certain Word commands

Comments
Latest MCQs

While finding and replacing some data in Excel,which of following statement is valid...?

(A) You can Find and Replace within the sheet or workbook
(B) Excel does not have option to match case for find

(C) All
(D) None

Comments
Latest MCQs

Which indent marker controls all the lines except first line...?

(A) Left Indent Marker
(B) First Line Indent Marker

(C) Right Indent Marker
(D) Hanging Indent Marker

Comments
Latest MCQs

How columns are numbered in MS Excel...?

(A) Numeric
(B) Alphabetic

(C) Roman
(D) None

Comments
Latest MCQs

Which shortcut key switch to next worksheet tab in MS Excel...?

(A) Ctrl + Page up
(B) Ctrl + Home

(C) Ctrl + Page down
(D) Ctrl + End

Comments
Latest MCQs

___________is used to create a chart in MS Excel...?

(A) CTRL+Y
(B) F11

(C) ALT+F11
(D) All of these

Comments
Latest MCQs

Which of the following is the latest version of MS Excel...?

(A) Excel 2021
(B) Excel 2016

(C) Excel 2017
(D) Office 365

Comments
Latest MCQs

When you open a new workbook in MS Excel, which of the following appears on the topmost portion of the screen...?

(A) Title bar
(B) Status bar

(C) Horizontal scroll bar
(D) Vertical scroll bar

Comments
Latest MCQs

Ctrl+Shift+1 shortcut Keys in excel are used to __________...?

(A) Format number in comma format
(B) Format number in currency format

(C) Format number in date format
(D) Format number in time format

Comments
Latest MCQs

Which command is used to add data in excel...?

(A) add
(B) count

(C) sum
(D) None of these

Comments
Latest MCQs

Another name for a pre programmed formula in excel is ___________...?

(A) Cell
(B) Graph

(C) Function
(D) Range

Comments
Latest MCQs

Which one is not a Function in MS Excel...?

(A) SUMB
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

What is the function of the VLOOKUP function in Excel...?

(A) To perform a vertical lookup and return a value based on a specified criteria
(B) To perform a horizontal lookup and return a value based on a specified criteria

(C) To add up a range of cells
(D) To find the average of a range of cells

Comments
Latest MCQs

which of these keys are used in ms excel to copy formulas from the above cell...?

(A) ctrl +
(B) ctrl +;

(C) ctrl +:
(D) ctrl +'

Comments
Latest MCQs

Worksheet in excel by default ___...?

(A) 3
(B) 2

(C) 1
(D) 4

Comments
Latest MCQs

Shortcut key to insert a new worksheet in Excel is _______...?

(A) Shift + F8
(B) Shift + F9

(C) Shift + F10
(D) Shift + F11

Comments
Latest MCQs

Which Shortcut keys are used to strikethrough highlighted selection in Excel...?

(A) Ctrl+4
(B) Ctrl+5

(C) Ctrl+6
(D) None of the above.

Comments
Latest MCQs

Which of following is not true about find and replace in excel...?

(A) You can search in formula too
(B) You can search for bold and replace

(C) You can search in formula too
(D) None

Comments
Latest MCQs

In Excel data series is ...?

(A) A row or column of numbers that are plotted in a chart
(B) Spreed sheet

(C) Work sheet
(D) None

Comments
Latest MCQs

Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel...?

(A) switching
(B) transpose

(C) matrix
(D) none

Comments
Latest MCQs

In MS Excel formula and function start with ____...?

(A) +
(B) -

(C) =
(D) [

Comments
Latest MCQs

The delete key of keyboard is assigned to which command in excel ...?

(A) Edit > Clear > All
(B) Edit > Clear > Contents

(C) Edit > Delete
(D) none

Comments
Latest MCQs

Selected cell of excel...?

(A) Active Cell
(B) Cell No

(C) Formula cell
(D) None Of These

Comments
Latest MCQs

Which of the following is not a valid Zoom percentage in Excel...?

(A) 10
(B) 100

(C) 300
(D) 500

Comments
Latest MCQs

You can edit existing Excel data by pressing the:________ key...?

(A) F1 Key
(B) F2 Key

(C) F3 Key
(D) F4 Key

Comments
Latest MCQs

B2:B6 in MS Excel represents the ______...?

(A) Range of cell
(B) Cell column

(C) Cell Row
(D) None of these

Comments
Latest MCQs

Which key deletes the character to the right of the cursor in MS Word:...?

(A) Delete
(B) Backspace

(C) End
(D) None of thee

Comments
Latest MCQs

What will be the result of formula '=16/2^3' in a cell in MS Excel...?

(A) 512
(B) 124

(C) 2
(D) 124

Comments
Latest MCQs

How many characters can be typed in a single cell in Excel ...?

(A) 256
(B) 1024

(C) 32767
(D) 65535

Comments
Latest MCQs

What would you do to delete a record in MS Excel...?

(A) Select Data > Open data from dialog box to find the record and click the delete button
(B) Select Data > Delete record from the menu

(C) Delete Column from the work sheet
(D) None of these

Comments
Latest MCQs

In MS Excel which bar is used for formula and data writing...?

(A) Formula bar
(B) Menu bar

(C) Title bar
(D) None of these

Comments
Latest MCQs

Which value remain unchanged in Ms Excel...?

(A) constant
(B) variable

(C) function
(D) none

Comments
Latest MCQs

What is active cell in MS-Excel ______...?

(A) Rectangular box
(B) Pointer

(C) Nearing point of view
(D) None of the above

Comments
Latest MCQs

Which key is used for Excel to select the whole column highlight...?

(A) Shift + space
(B) CTRL + space

(C) Alt + space
(D) None of these

Comments
Latest MCQs

What does the term "filter" refer to in Excel...?

(A) To permanently delete rows or columns
(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria
(D) To create a chart

Comments
Latest MCQs

in Microsoft Excel template is the combination of different ______...?

(A) Colors
(B) Effects

(C) Fonts
(D) All of these

Comments
Latest MCQs

Which function calculates the largest value in a set of numbers in Excel...?

(A) Average
(B) Count

(C) Minimum
(D) Maximum

Comments
Latest MCQs

Which chart type in Excel is best suited for showing the proportion of parts to a whole...?

(A) Pie Chart
(B) Bar Chart

(C) Lines Chart
(D) None of these

Comments
Latest MCQs

Where can you change automatic or manual collection mode in Excel ...?

(A) Double CAL indicator on status bar
(B) Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button

(C) both
(D) none

Comments
Latest MCQs

In MS-Excel two common wildcard characters that MS Excel recognizes are:...?

(A) * and?
(B) < and >

(C) ^ and /
(D) None of these

Comments
Latest MCQs

Which formula is used to find the number of numerical cells in a range of cells in Excel...?

(A) COUNTIF
(B) COUNT

(C) COUNTA
(D) None of these

Comments
Latest MCQs

In MS Excel you can sort data in ...?

(A) Ascending order
(B) Descending order

(C) Both A & B
(D) None of these

Comments
Latest MCQs

When you insert a Excel file to a Word document The Data are:...?

(A) Embedded
(B) Linked

(C) Hyperlink placed in word table
(D) None of these

Comments
Latest MCQs

Which option is not available in charts in MS Excel...?

(A) Volume
(B) Line

(C) Pie
(D) Bar

Comments
Latest MCQs

The title bar in MS Excel displays the name of the ____...?

(A) Worksheet
(B) Workbook

(C) Formula
(D) Location

Comments
Latest MCQs

In MS-Excel, the ZOOM option appears in:...?

(A) Formula Bar
(B) Status Bar

(C) Title Bar
(D) Scroll Bar

Comments
Latest MCQs

______ users can open MS Excel 2016 file at the same time...?

(A) 100
(B) 50

(C) 256
(D) None of these

Comments
Latest MCQs

What does the VLOOKUP function do in Excel...?

(A) Count the number of cells
(B) Searches for a value in a column and returns a value in the same row

(C) Calculate the average of values
(D) Sorts data in ascending order

Comments
Latest MCQs

Which shortkey is suitable for reach at the last Row of MS Excel...?

(A) Ctrl + Space
(B) Shift + Ctrl +Enter

(C) Ctrl + Down Arrow
(D) Ctrl + =

Comments
Latest MCQs

Which shortcut key is used to calculate the range of cells in MS Excel...?

(A) Alt +
(B) Ctrl ++

(C) Shift ++
(D) None of these

Comments
Latest MCQs

What is the purpose of the VLOOUP function in Excel...?

(A) To create a chart
(B) To sort data

(C) To find a value in a table based on a matching value in the first column
(D) None

Comments
Latest MCQs

To fix values in an excel we use _____...?

(A) Thumbnails
(B) Thread

(C) Absolute reference
(D) None of these

Comments
Latest MCQs

To select multiple cells, rows, or columns in a table that are not adjacent to one another, select the first cell and then hold down the ________ key while selecting the next cell, row, or column....?

(A) alt
(B) shift

(C) enter
(D) ctrl

Comments
Latest MCQs

What is the default row height of MS Excel...?

(A) 20
(B) 13

(C) 14
(D) 15

Comments
Latest MCQs

How you can update the values of formula cell.If auto calculate the mode of excel cell is disabled...?

(A) f9
(B) f2

(C) f7
(D) none

Comments
Latest MCQs

MOD () function is used in MS excel to get...?

(A) Dividend
(B) Remainder

(C) Quotient
(D) None of these

Comments
Latest MCQs

The thin black cross-shaped pointer in MS Excel is used to _____...?

(A) Move a group of cells
(B) Highlight duplicate cells

(C) Complete lists and fill patterns
(D) None of these

Comments
Latest MCQs

MS Excel is based on :...?

(A) UNIX
(B) DOS

(C) WINDOWS
(D) OS/2

Comments
Latest MCQs

Which the following term does not pertain to Excel...?

(A) Browser
(B) Columns

(C) Work Book
(D) None of these

Comments
Latest MCQs

Which of following is not a nomenclature of MS Excel ...?

(A) Range
(B) Work book

(C) Document
(D) Cell

Comments
Latest MCQs

Which of the following is last column in MS Excel-2016...?

(A) XFD
(B) ZZZ

(C) ZXF
(D) ZAZ

Comments
Latest MCQs

What is a cell in Excel...?

(A) A row
(B) A column

(C) A unit of data
(D) A unit of formatting

Comments
Latest MCQs

The first cell in EXCEL worksheet is labeled as ____...?

(A) AA
(B) Aa

(C) A1
(D) None of these

Comments
Latest MCQs

Which shortcut key is used to insert current date and time in MS Excel...?

(A) Ctrl + Shift + ;
(B) Ctrl + Shift + :

(C) Ctrl + ;
(D) Ctrl + !

Comments
Latest MCQs

Which key deletes the character to the left of the cursor...?

(A) End
(B) Backspace

(C) Home
(D) Delete

Comments
Latest MCQs

In MS Excel, _____ function calculates the square root of a number....?

(A) SQR
(B) SQRT

(C) SQUARE
(D) None of these

Comments
Latest MCQs

In MS Excel, we can add chart from__ tab....?

(A) File
(B) Chart

(C) Insert
(D) None of these

Comments
Latest MCQs

Letters in Excel denote: ______________...?

(A) Columns
(B) rows

(C) numbers
(D) reference

Comments
Latest MCQs

The ______ function in Excel returns the highest value in a set of data that you specify....?

(A) LRG
(B) AVG

(C) MAX
(D) None of these

Comments
Latest MCQs

In MS Excel we added ______ before fraction for not to enter date...?

(A) space
(B) comma

(C) asterik
(D) None of these

Comments
Latest MCQs

Which of following is not a valid zoom percentage in Excel...?

(A) 10
(B) 100

(C) 300
(D) 500

Comments
Latest MCQs

Which of the following is not a nomenclature of MS Excel:...?

(A) Range
(B) Workbook

(C) Document
(D) Cell

Comments
Latest MCQs

When typing character search criteria, Excel matches fields based on:...?

(A) Alphabetical order
(B) Capitalization

(C) Spelling
(D) Primary records

Comments
Latest MCQs

We can set Page Border in Excel from:...?

(A) From Border tab in Format Cells dialog box
(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar
(D) we cannot set page border in Excel

Comments
Latest MCQs

What is the result of the Excel formula [7-3]×[4+3]/4...?

(A) 1
(B) 4

(C) 7
(D) 9

Comments
Latest MCQs

What is the symbol for the "not equal to" operator in Excel...?

(A) !=
(B) ~=

(C) <>
(D) None of these

Comments
Latest MCQs

MS Excel stands for_______...?

(A) Micromax Excel
(B) Microsoft Excel

(C) Micromax Excess
(D) Management Excel

Comments
Latest MCQs

MS Excel is based on: _____________...?

(A) UNIX
(B) DOS

(C) WINDOWS
(D) OS/2

Comments
Latest MCQs

Ctrl + D in MS Excel is used for...?

(A) Fill down in the selection
(B) Open the font dialog box

(C) Both A and B
(D) None of these

Comments
Latest MCQs

The first cell in excel worksheet is labeled as _________...?

(A) AA
(B) A1

(C) Aa
(D) None of these

Comments
Latest MCQs

When an Excel workbook is linked to a Word document:...?

(A) The Word document contains a copy ofthe actual data
(B) The word document cannot be edited

(C) The word document must contain ahyperlink
(D) Theword document contains a reference to the original source application

Comments
Latest MCQs

Which keyboard shortcut is used to add comments in MS Office Excel Worksheet...?

(A) Alt + F2
(B) Ctrl + F12

(C) Shift + F5
(D) Shift + F2

Comments
Latest MCQs

Which of following is not a valid data type in MS Excel...?

(A) Number
(B) Character

(C) Babel
(D) Date/Time

Comments
Latest MCQs

With which of the following all formulas in MS excel starts:...?

(A) /
(B) =

(C) +
(D) &

Comments
Latest MCQs

You can set page border in excel from: __________...?

(A) From Border tab in Format Cells dialog box
(B) From Border tool in Formatting toolbar

(C) From Line Style tool in Drawing toolbar
(D) You can not set page border in Excel

Comments
Latest MCQs

Which of following is an active cell in excel...?

(A) Cell address
(B) Range

(C) Formula
(D) Current cell

Comments
Latest MCQs

In Excel, Conditional formatting is in: ______________...?

(A) Insert Tab
(B) Page layout

(C) View Tab
(D) Home Tab

Comments
Latest MCQs

An excel workbook is a collection of __________...?

(A) Worksheets and Charts
(B) Charts

(C) Worksheets
(D) Workbooks

Comments
Latest MCQs

Cells in MS Excel can be uniquely identified by:...?

(A) Column letters and row numbers
(B) Column numbers and row letters

(C) Cell coordinates
(D) None of these

Comments
Latest MCQs

A formula in MS Excel starts with a________ symbol...?

(A) *
(B) +

(C) =
(D) $

Comments
Latest MCQs

In MS Excel, You can copy data or formulas _____...?

(A) With buttons on the standard toolbars
(B) With commands on the shortcut menu

(C) With the copy, paste and cut commands on the edit menu
(D) All of the above

Comments
Latest MCQs

Which Excel function is used to add the current system date...?

(A) DATE()
(B) NOW()

(C) TODAY()
(D) CURRENT_DATE()

Comments
Latest MCQs

In MS Word, “Justify” works to make text straight in both sides but How Justify works in MS Excel...?

(A) Text in Columns
(B) Text in Rows

(C) Text in selection
(D) None

Comments
Latest MCQs

MS Excel sheet consists of __________...?

(A) Text boxes
(B) Rows & Columns

(C) Pictures & Drawings
(D) Rows & Text

Comments
Latest MCQs

Move to the next cell in the row in MS Excel _____...?

(A) Tab
(B) Shift

(C) Space
(D) None of these

Comments
Latest MCQs

VLOOKUP is a built-in function in Excel used to:...?

(A) Increases the font of text
(B) Prints the content of an Excel sheet

(C) Searches for a value in the column
(D) Deletes a value in the column

Comments
Latest MCQs

MS Excel is commonly used to...?

(A) Database
(B) Organize Data

(C) Information
(D) None of these

Comments
Latest MCQs

Default file name in MS Excel is...?

(A) Document 1
(B) Workbook 1

(C) Book1
(D) Worksheet

Comments
Latest MCQs

The valid data type in MS Excel is _____...?

(A) Boolean
(B) Tupal

(C) Dictionary
(D) None of these

Comments
Latest MCQs

How to activate a cell in MS Excel...?

(A) Pressing an arrow key
(B) Clicking the cell

(C) Pressing the Tab key
(D) All of the above

Comments
Latest MCQs

Which Shortcut keys are used to strikethrough highlighted selections in MS Excel...?

(A) Ctrl+4
(B) Ctrl+5

(C) Ctrl+6
(D) None of these

Comments
Latest MCQs

In MS Excel, columns are labelled as ______...?

(A) A, B, C
(B) A1, A2, A3

(C) 1, 2, 3
(D) $A$1, $B$2

Comments
Latest MCQs

In MS Excel, the Chart wizard term data categories refers to ______...?

(A) A chart plot area
(B) The organization of individual values with a chart’s data series

(C) A horizontal axis
(D) The data range that supply chart data

Comments
Latest MCQs

Number of default worksheets in MS Excel...?

(A) 2
(B) 3

(C) 4
(D) 5

Comments
Latest MCQs

move to the next cell in the sheet in ms excel....?

(A) ctrl + page down
(B) shift + page down

(C) page down
(D) none of these

Comments
Latest MCQs

Which is true when you insert an excel worksheet into a word document...?

(A) word is the destination document
(B) excel is the destination document

(C) the worksheet is the destination document
(D) the document is the source document

Comments
Latest MCQs

What are the small squares arranged in rows and columns called in Excel...?

(A) Blocks
(B) Rows

(C) Cells
(D) Columns

Comments
Latest MCQs

Which one is not a function in MS Excel:...?

(A) SUM
(B) AVG

(C) MAX
(D) MIN

Comments
Latest MCQs

Which of the following Excel feature allows users to evaluate values and return a result?...?

(A) Formulas
(B) Formatting

(C) Filters
(D) Insertions

Comments
Latest MCQs

In MS Excel ______ shortcut key is used for hiding rows....?

(A) Ctrl+H
(B) Ctrl+7

(C) Ctrl+9
(D) None of the above

Comments
Latest MCQs

What does moving from cell C9 to C11 mean in MS Excel...?

(A) C9:C11
(B) C9-C11

(C) C9 to C11
(D) None of these

Comments
Latest MCQs

When you link data maintained in an excel workbook to a word document...?

(A) The word document contains a copy of the actual data
(B) The word document must contain a hyperlink

(C) The word document contains a reference to the original source application
(D) The word document cannot be edit

Comments
Latest MCQs

What will be result of excel formula =5 + 2 * 3...?

(A) 1
(B) 10

(C) 11
(D) 21

Comments
Latest MCQs

Which of the following option can remove the borders in MS Excel:...?

(A) Press enter
(B) Use no border

(C) Use formula
(D) Not possible in MS Excel

Comments
Latest MCQs

which key is used to minimize excel worksheet...?

(A) CTRL+F5
(B) CTRL+F11

(C) Windows Key + Down Arrow
(D) None of these

Comments
Latest MCQs

Which of the following way cannot be used to link excel worksheet data to a Word document...?

(A) With the right drag method
(B) With a hyperlink

(C) With the copy and paste special commands
(D) With the copy and paste buttons on the standard toolbar

Comments
Latest MCQs

MS Excel Formula starts with__________...?

(A) .
(B) _

(C) =
(D) none

Comments
Latest MCQs

Which of the following displays the contents of the active cell in MS Excel:...?

(A) Active cell
(B) Formula bar

(C) Title bar
(D) Name box

Comments
Latest MCQs

Short cut key ctrl + A use for __________...?

(A) To Select All Text
(B) To copy

(C) To paste
(D) None

Comments
Latest MCQs

Which one cannot be used to enter data in a cell in MS Excel...?

(A) Pressing tab key
(B) Pressing arrow key

(C) Pressing Esc key
(D) clicking the enter button to the formula bar

Comments
Latest MCQs

To select an entire column in MS Excel, press...?

(A) Ctrl +r
(B) Ctrl +s

(C) Ctrl +c
(D) none

Comments
Latest MCQs

How do you freeze panes in Excel...?

(A) Home tab and go to freeze panes
(B) View he tab and go to freeze panes

(C) Review tab and go to Freeze Panes
(D) Page layout tab and go to Freeze panes

Comments
Latest MCQs

How do you display current date and time in MS Excel ...?

(A) Date()
(B) Year()

(C) Now()
(D) Time()

Comments
Latest MCQs

By default line indentation in MS Excel is:...?

(A) 0.5"
(B) 1"

(C) 0.75"
(D) 1.25"

Comments
Latest MCQs

Which of the following formulas MS-Excel 2016 will not be able to calculate =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10...?

(A) =SUM (AI: A5)*.5
(B) =SUM (Sales)-A3

(C) =SUM( AI: A5)/(10-10)
(D) =SUM(AI:A5)-10

Comments
Latest MCQs

What is the use of proper text in MS Excel...?

(A) Engineered
(B) Convert your input text to proper case

(C) Original
(D) None of these

Comments
Latest MCQs

Which of these key are used in ms excel to insert current time In workbook....?

(A) Ctrl + Shift + ;
(B) Ctrl+!

(C) Ctrl+*
(D) None of these

Comments
Latest MCQs

Which key should be pressed continuously while moving a column in MS Excel:...?

(A) Ctrl
(B) Shift

(C) Alt
(D) Tab

Comments
Latest MCQs

MS Excel is a ______...?

(A) Spreadsheet program
(B) Multimedia software

(C) Entertainment software
(D) None of these

Comments
Latest MCQs

Which key is used to GO TO tab in Ms Excel...?

(A) F1
(B) F3

(C) F6
(D) F5

Comments
Latest MCQs

# value which type of error record in excel...?

(A) [\"numeric error\",\"syntax error\",\"excel does not recognize the formula\",\"None\"]
(B) empty

(C) empty
(D) empty

Comments
Latest MCQs

The handout Master consists of placeholders for all these except the _________...?

(A) Title
(B) slide number

(C) header
(D) footer

Comments
Latest MCQs

Which area in an excel window allows entering values and formulas...?

(A) Menu Bar
(B) Title Bar

(C) Formula Bar
(D) None of these

Comments
Latest MCQs

Which of the following is not a valid data type in Excel...?

(A) Number
(B) Character

(C) Label
(D) Date

Comments
Latest MCQs

Which key should be pressed continuously while moving a column in MS Excel...?

(A) Tab
(B) Ctrl

(C) Shift
(D) Alt

Comments
Latest MCQs

Microsoft excel is a powerful______...?

(A) Spreadsheet package
(B) Word processing package

(C) DBMS package
(D) None

Comments
Latest MCQs

Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________...?

(A) Smart tip
(B) Soft Tip

(C) Web Tip
(D) Cell Tip

Comments
Latest MCQs

In Excel, you can sort data in...?

(A) Ascending order
(B) Descending order

(C) Both A & B
(D) None of these

Comments
Latest MCQs

To move between the worksheets in a workbook in MS Excel, we can use which of the following shortcut...?

(A) ALT+=
(B) Ctrl+Tab

(C) Ctrl+F
(D) Ctrl+Page up/Page Down

Comments
Latest MCQs

Which symbol is used to execute formulas in MS Excel...?

(A) :
(B) =

(C) #
(D) ~

Comments
Latest MCQs

In MS Excel 2016, = Now () is used for...?

(A) to show time
(B) to show date

(C) to show both Time and date
(D) None of these

Comments
Latest MCQs

Which shortcut key is used to insert a new worksheet in MS Excel...?

(A) Shift + F8
(B) Shift + F9

(C) Shift + F10
(D) Shift + F11

Comments
Latest MCQs

Which key is used to enter the current date in Excel...?

(A) Ctrl+:
(B) Ctrl+Shift:

(C) Ctrl+;
(D) None of these

Comments
Latest MCQs

How can you apply exactly the same formatting you did to another text...?

(A) Copy the text and paste in new location. Then type the new text again.
(B) Copy the text and click on Paste Special tool on new place

(C) Select the text then click on Format Painter and select the new text
(D) All of above

Comments
Latest MCQs

What displays the content of active cell in MS Excel...?

(A) Name Box
(B) Formula Bar

(C) Row Headings
(D) None of these

Comments
Latest MCQs

Which is the utility of Excel to fill the columns/rows with a series of data...?

(A) Auto sum
(B) Auto filter

(C) Auto fill
(D) Auto calculate

Comments
Latest MCQs

What is the purpose of Crtl=Shift+F6 in MS Excel...?

(A) moves to the previous worksheet
(B) moves to the next worksheet

(C) forward to the previous worksheet
(D) none of these

Comments
Latest MCQs

Embedded Formula in MS Excel can removed by pressing...?

(A) DELETE
(B) BACKSPACE

(C) PAGE DOWN
(D) END

Comments
Latest MCQs

How can you sum up a range of cells in Excel...?

(A) Use the SUM function
(B) Use the AVERAGE function

(C) Use the COUNT function
(D) Use the MAX function

Comments
Latest MCQs

Which is correct form of Cell range in MS Excel:...?

(A) A1-B1
(B) A1:A10

(C) A1 to A10
(D) A1-A10

Comments
Latest MCQs

You can set border in Excel from ___...?

(A) From Line Style tool in Drawing toolbar
(B) You can not set page border in Excel

(C) From Border tool in Formatting toolbar
(D) none

Comments
Latest MCQs

An excel workbook is a collection of:...?

(A) Workbooks
(B) Worksheets

(C) Charts
(D) Worksheets and Charts

Comments
Latest MCQs

________________________ is not a valid data type in excel...?

(A) Number
(B) Label

(C) Character
(D) none

Comments
Latest MCQs

_____ is not a valid data type in excel...?

(A) Number
(B) Label

(C) Character
(D) none

Comments
Latest MCQs

The software which contains rows and columns is called in MS Excel is called...?

(A) Database
(B) Spreadsheet

(C) Word processing
(D) None of these

Comments
Latest MCQs

IF function used in Excel for _____...?

(A) Performing logical comparisons
(B) Formatting text

(C) Creating charts
(D) None of these

Comments
Latest MCQs

In MS Excel, which function automatically total a column or row of values...?

(A) TOTAL
(B) ADD

(C) SUM
(D) AVG

Comments
Latest MCQs

How to duplicate values in cell range in Excel 2016...?

(A) Click the conditional formatting button in the styles group of the theme
(B) Select the range of cell in the work sheet

(C) Both A and B
(D) None of these

Comments
Latest MCQs

Columns in MS Excel are called...?

(A) Fields
(B) Chart

(C) Both
(D) None of these

Comments
Latest MCQs

--- is used to tell excel to include all cell between the two end point cell reference...?

(A) Double colon
(B) Single colon

(C) Double sami colon
(D) None of these

Comments
Latest MCQs

What is the function of the SUM function in Excel...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find the maximum value in a range of cells

Comments
Latest MCQs

How many rows are in one Microsoft Excel sheet...?

(A) 65,536
(B) 16,384

(C) 1,048,576
(D) None of Above

Comments
Latest MCQs

Which formula will automatically capitalize the first letter of text in MS Excel...?

(A) Proper
(B) Upper case

(C) Capitalize
(D) None of these

Comments
Latest MCQs

To return the reminder after the number is divided by a divisor in Excel we use the function...?

(A) ROUND ( )
(B) FACT ( )

(C) MOD ( )
(D) None

Comments
Latest MCQs

What does Ctrl + = key effect...?

(A) Superscript
(B) Subscript

(C) All Caps
(D) Shadow

Comments
Latest MCQs

How many types of references are used in Excel:...?

(A) 3
(B) 4

(C) 5
(D) 6

Comments
Latest MCQs

To edit in an embedded excel worksheet object in a word document...?

(A) Edit the hyperlink
(B) Use the excel menu bar and toolbars inside the word application

(C) Both
(D) None

Comments
Latest MCQs

Which shortcut key is used to create chart in MS Excel...?

(A) F10
(B) F12

(C) F11
(D) None

Comments
Latest MCQs

What is the intersection of a column and row called in Excel...?

(A) A cell
(B) A range

(C) A column header
(D) A row header

Comments
Latest MCQs

Move to next cell in row in Ms Excel:...?

(A) Tab
(B) Shift

(C) Space
(D) None of these

Comments
Latest MCQs

Which of these keys are used in MS Excel to insert the current time in workbook?...?

(A) Ctrl + Shift +:
(B) Ctrl+!

(C) Ctrl+
(D) None of these

Comments
Latest MCQs

What is a group of cells called in Excel...?

(A) Cell Range
(B) Workbook

(C) Margin
(D) None of these

Comments
Latest MCQs

In MS Excel = Now () is used ______...?

(A) To show current date
(B) To show current time

(C) To show current date and time
(D) None of these

Comments
Latest MCQs

Which of the following is not a nomenclature of MS Excel...?

(A) Range
(B) Workbook

(C) Document
(D) cell

Comments
Latest MCQs

The Maximum number of rows in MS-Excel is ______...?

(A) 1200000
(B) 1048576

(C) 1020239
(D) None of these

Comments
Latest MCQs

You can edit existing Excel Data by pressing the key...?

(A) F1 key
(B) F2 key

(C) F3 key
(D) F4 key

Comments
Latest MCQs

How many types of references are used in Excel...?

(A) 4
(B) 5

(C) 3
(D) 2

Comments
Latest MCQs

What is the use of a horizontal Scroll Bar in MS Excel...?

(A) to view the data from left to the right
(B) to view the data in Excel from up and down

(C) to view the data from right to the left
(D) None of these

Comments
Latest MCQs

Letters in Excel denote :...?

(A) Columns
(B) rows

(C) numbers
(D) reference

Comments
Latest MCQs

Rows in Microsoft Excel are labeled as _____...?

(A) 1, 2, 3, etc.
(B) A1, A2, etc.

(C) A, B, C, etc.
(D) None of these

Comments
Latest MCQs

Which of these keys are used in Ms Excel to copy value from above cell...?

(A) Ctrl + “
(B) Ctrl+ E

(C) Ctrl+ E
(D) Ctrl+ D

Comments
Latest MCQs

Function key to go to a specific cell in MS Excel is:...?

(A) F4
(B) F5

(C) F6
(D) None of these

Comments
Latest MCQs

In MS Excel window, on the bottom, right area of the spreadsheet there is/are:...?

(A) Horizontal scroll bar
(B) Zoom tool

(C) Page view commands
(D) All of these

Comments
Latest MCQs

Which of these key are used to apply outline border to the selected cell in MS Excel...?

(A) CTRL+SHIFT+ %
(B) CTRL+SHIFT+ &

(C) CTRL+SHIFT+ ~
(D) CTRL+SHIFT+ $

Comments
Latest MCQs

In MS Excel 2016 one has to go to _____ option for setting or clearing print area....?

(A) Insert
(B) Page Layout

(C) Data
(D) Review

Comments
Latest MCQs

How can you show or hide the grid-lines in Excel worksheet ...?

(A) Click Gridline tool on Forms toolbar
(B) Go to Tools > Options > View tab and mark or remove the check box named Gridline

(C) both
(D) none

Comments
Latest MCQs

When you open an Excel sheet, what is the topmost bar called...?

(A) Title Bar
(B) Status Bar

(C) Menu Bar
(D) Tool Bar

Comments
Latest MCQs

How many sheets are there in the Excel workbook by default...?

(A) 2
(B) 3

(C) 4
(D) 5

Comments
Latest MCQs

Which of the following methods can not be used to enter data in MS Excel cell:...?

(A) Pressing an arrow key
(B) Pressing the Tab key

(C) Pressing the Esc key-
(D) Clicking on the formula bar-

Comments
Latest MCQs

MS excel is used to data...?

(A) Organize
(B) Share

(C) Communicate
(D) Obtain

Comments
Latest MCQs

Which of the following is correct syntax in Excel...?

(A) =IF(LogicalTest, TrueResult, FalseResult)
(B) =IF(LogicalTest, (TrueResult, FalseResult)

(C) =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
(D) =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Comments
Latest MCQs

Which of the following functions in Microsoft Excel is used to count items in a cell range...?

(A) COUNT
(B) AVERAGE

(C) SUM
(D) MAX

Comments
Latest MCQs

What is the function of the IF function in Excel...?

(A) To perform a logical test and return a value based on the result
(B) To add up a range of cells

(C) To find the average of a range of cells
(D) To count the number of cells in a range

Comments
Latest MCQs

Which of the following is the key to close a run dialog box in window...?

(A) SHIFT
(B) ESC

(C) TAB
(D) F8

Comments
Latest MCQs

How many worksheets are there in Excel by default:...?

(A) 01
(B) 03

(C) 05
(D) 07

Comments
Latest MCQs

Which is the shortcut key to display active cells in Excell...?

(A) Shift+Backspace
(B) Crtl+Backspace

(C) Alt+Backspace
(D) none

Comments
Latest MCQs

With which of the following all formulas in excel starts ...?

(A) /
(B) *

(C) $
(D) =

Comments
Latest MCQs

Which of the following is not a valid option to insert a hyperlink in excel, which can link to...?

(A) existing file or web page
(B) place in this document

(C) e-mail address
(D) link to home

Comments
Latest MCQs

Which of the following operators take only integer operands in MS Excel...?

(A) %
(B) +

(C) /
(D) None of these

Comments
Latest MCQs

Which key deletes the character to the right of the cursor in Ms Word...?

(A) End
(B) Backspace

(C) Home
(D) Delete

Comments
Latest MCQs

The shortcut key to close a selected window is...?

(A) Alt + F4
(B) Ctrl + F4

(C) Alt + F5
(D) Alt + F3

Comments
Latest MCQs

Which of the following is associated with Excel program...?

(A) Graphic program
(B) Word Processor

(C) Presentation
(D) Spreadsheet

Comments
Latest MCQs

How can you apply exactly the same formatting you did to another text?...?

(A) Copy the text and paste in new location. then type the new text again
(B) copy the text and click on past special tool on new place

(C) select the text then click on format painter and select the new text
(D) All of these

Comments
Latest MCQs

The freezing row and column in Excel is in which pane...?

(A) Freezing row
(B) Freezing column

(C) Freezing pane
(D) None of these

Comments
Latest MCQs

Function in MS Excel is known as ____...?

(A) Formula
(B) Command

(C) Operation
(D) None of these

Comments
Latest MCQs

Ctrl+R is used in excel to...?

(A) Fill the selection with active cells to the right
(B) Right align the content of cell

(C) Remove the cell contents of selected cells
(D) none

Comments
Latest MCQs

Which of the following symbols is used to enter a formula in MS Excel:...?

(A) $
(B) +

(C) #
(D) =

Comments
Latest MCQs

If a formula references a cell that contains text instead of a numerical value, what error does Excel display...?

(A) #NUM!
(B) #VALUE!

(C) #REF!
(D) #DIV0

Comments
Latest MCQs

What is the result of the Excel formula (7-3)×(4+3)/4...?

(A) 6
(B) 7

(C) 8
(D) 5

Comments
Latest MCQs

When you insert an Excel File into a word document, the data are...?

(A) Hyperlinked
(B) Placed in a word table

(C) Linked
(D) Embedded

Comments
Latest MCQs

Microsoft Excel 2019 files have a default extension of ________...?

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments
Latest MCQs

How a cell can be edit on Excel sheet...?

(A) Edit contents of cell directly in cell
(B) Edit by typing in formula bar

(C) Edit mode
(D) All above mentioned

Comments
Latest MCQs

The actual working area of the Computer's Microsoft Excel is...?

(A) Workbook
(B) Worksheet

(C) Note sheet
(D) Notebook

Comments
Latest MCQs

In a new workbook in MS Excel, which one appears on the topmost of the screen...?

(A) Status Bar
(B) Title Bar

(C) Vertical Scroll bar
(D) Horizontal scroll bar

Comments
Latest MCQs

The ______________ function in Excel returns the highest value in a set of data that you specify...?

(A) AVG
(B) MAX

(C) LRG
(D) None of these

Comments
Latest MCQs

An excel workbook is a collection of__________...?

(A) Worksheets& Charts
(B) Slides

(C) Pages
(D) documents

Comments
Latest MCQs

Which of these keys are used in ms excel to copy values from the above cell...?

(A) ctrl +
(B) ctrl F

(C) ctrl S
(D) ctrl D

Comments
Latest MCQs

Actual working area of Computer’s Microsoft Excel is ________ ...?

(A) Workbook
(B) Worksheet

(C) Notesheet
(D) Notebook

Comments
Latest MCQs

Which of the following functions is used to calculate the average of a range of cells in Excel...?

(A) AVERAGE
(B) SUM

(C) COUNT
(D) None of these

Comments
Latest MCQs

Microsoft Excel 2019 files have a default extension of___________...?

(A) .Xlsx
(B) .Xls

(C) .excel
(D) .123

Comments
Latest MCQs

Can you merge the main document with data source in excel. In mail merge operation, the word usually...?

(A) Server
(B) Client

(C) Source
(D) none

Comments
Latest MCQs

Autosave default time in MS Excel is ________....?

(A) 10 hours
(B) 10 minutes

(C) 10 second
(D) None of these

Comments
Latest MCQs

Maximum zoom percentage in Excel is _________...?

(A) 100%
(B) 300%

(C) 400%
(D) 500%

Comments
Latest MCQs

Which of the following is not a function in Microsoft Excel?...?

(A) SUM
(B) MAX

(C) MIN
(D) AVG

Comments
Latest MCQs

An excel workbook is a collection of:...?

(A) Worksheets
(B) Charts

(C) Both A & B
(D) None of these

Comments
Latest MCQs

_______ is the short key to select the entire column in Excel....?

(A) Alt + space bar
(B) Shift + space bar

(C) Control + space bar
(D) None of the above

Comments
Latest MCQs

Which feature is used to wrap extra-long text into multiple lines in MS Excel ...?

(A) wrap text
(B) text wrap

(C) letter warp
(D) word wrap

Comments
Latest MCQs

Shortcut in excell to insert new sheet...?

(A) Shift+F6
(B) Shift+F12

(C) Shift+F11
(D) Shift+A1

Comments
Latest MCQs

In MS Excel, to create a formula, you can use:...?

(A) Values but not cell references
(B) Cell references but not values

(C) Values or cell references although notboth at the same time
(D) Both value and cell references

Comments
Latest MCQs

Where can you set the shading color of a range of cells in excel ...?

(A) Choose required color on Fill Color tool in Formatting toolbar
(B) Choose required color on Fill Color tool in Drawing toolbar

(C) Choose required color form Patterns tab of Format Cells dialog box
(D) All of these

Comments
Latest MCQs

_________ is used to tell excel to include all cell between the two end point cell reference...?

(A) Double colon
(B) Single colon

(C) Double sami colon
(D) None of these

Comments
Latest MCQs

What are the number of columns in MS Excel 2007...?

(A) 16,284
(B) 16,384

(C) 16,584
(D) None of these

Comments
Latest MCQs

Cell entry "July 16, 2016" will be considered a _____ by Excel sheet....?

(A) Label
(B) Value

(C) Formula
(D) Text string

Comments
Latest MCQs

Maximum zoom percentage in Ms excel...?

(A) 300%
(B) 200%

(C) 400%
(D) 500%

Comments
Latest MCQs

Which area in MS Excel window allows entering values and formulas...?

(A) Title bar
(B) Menu bar

(C) Formula bar
(D) Standard toolbar

Comments
Latest MCQs

What is the main function of MS Excel...?

(A) organized data
(B) loss data

(C) gain data
(D) none of these

Comments
Latest MCQs

In MS Word. "Delete" key delete letters from the side of curser...?

(A) Right
(B) Up

(C) Down
(D) Left

Comments
Latest MCQs

which key is used for help in MS excel------...?

(A) F1
(B) F2

(C) F3
(D) NONE OF THESE

Comments
Latest MCQs

Which symbol is used for division in Excel...?

(A) /
(B) *

(C) +
(D) .

Comments
Latest MCQs

How can you apply exactly the same formatting you did to another text in Ms Word...?

(A) Copy the text and click on Paste Special tool on new place
(B) Select the text then click on Format Painter and select the new text

(C) Copy the text and paste in new location. Then type the new text again
(D) All of above

Comments
Latest MCQs

Which sign is used to create an absolute cell reference in MS Excel...?

(A) $
(B) @

(C) &
(D) %

Comments
Latest MCQs

Which among the following wildcard characters are recognized by MS excel...?

(A) + and –
(B) !and ^

(C) *and
(D) < and >

Comments
Latest MCQs

Which of these keys are used in Ms Excel to copy formula from above cell...?

(A) Ctrl+ ”
(B) Ctrl+ ;

(C) Ctrl+ :
(D) Ctrl+ ‘

Comments
Latest MCQs

In MS Excel, Conditional Formatting is in ______ tab...?

(A) Home
(B) View

(C) Page Layout
(D) Insert

Comments
Latest MCQs

Microsoft Excel functions arguments are always written in __ ...?

(A) Rows
(B) Cells

(C) Columns
(D) Parentheses

Comments
Latest MCQs

What is a Macro in MS Excel...?

(A) A single instruction that performs a specific task
(B) A set of instructions that can be executed as a single command

(C) A type of chart or graph used for data visualization
(D) A feature that allows users to create and edit images

Comments
Latest MCQs

Formula in Excell starts with...?

(A) +
(B) -

(C) =
(D) [

Comments
Latest MCQs

What does the term “filter” refer to in Excel...?

(A) To permanently delete rows or columns
(B) To format the appearance of cells

(C) To temporarily hide certain data based on specific criteria
(D) To create a chart

Comments
Latest MCQs

Another name for a pre programmed formula in excel is ___...?

(A) Cell
(B) Graph

(C) Function
(D) Range

Comments
Latest MCQs

Which is the correct form in MS Excel...?

(A) 6A
(B) A6

(C) AA6
(D) +A+

Comments
Latest MCQs

In Microsoft Word shortcut key CTRL+W is used for___________...?

(A) open the Print dialog box
(B) Update the current Web page

(C) close the current window
(D) None of these

Comments
Latest MCQs

Go To command in Excel is located in...?

(A) Menu
(B) Find and select

(C) Search
(D) Help

Comments
Latest MCQs

To insert chart in MS Excel, which shortcut key used...?

(A) Alt+F1
(B) F2

(C) F3
(D) F4

Comments
Latest MCQs

Which value remains unchanged in MS Excel...?

(A) Constant
(B) Function

(C) Variable
(D) None of these

Comments
Latest MCQs

How is a selected cell indicated in MS Excel...?

(A) Dotted line
(B) Double line

(C) Wide bold line
(D) Single line

Comments
Latest MCQs

A worksheet in Excel is divided into _____...?

(A) Height & Width
(B) Layers & Planes

(C) Columns & Rows
(D) Lines & Spaces

Comments
Latest MCQs

Move to Next Sheet in Ms Excel:...?

(A) Ctrl + Page Down
(B) Shift + Page Down

(C) Page Down
(D) None of these

Comments
Latest MCQs

In Microsoft Excel the Intersection of columns and rows is called a:...?

(A) Data
(B) Table

(C) Cell
(D) Schema for:

Comments
Latest MCQs

In MSS Excel 2016 Print Title option is available in ___ menu...?

(A) Review
(B) View

(C) Insert
(D) Page layout

Comments
Latest MCQs

_____ is used for arranging data in ascending/descending order in MS Excel....?

(A) Data, order
(B) Data, sort

(C) Data, all
(D) None of these

Comments
Latest MCQs

MS Excel, MS PowerPoint and MS Word are the part of:...?

(A) Microsoft Office Suite
(B) Microsoft Outlook

(C) Microsoft one drive
(D) All of these

Comments
Latest MCQs

Who gave the cell theory...?

(A) Robert Hooke
(B) Ernst Haeckel

(C) Matthias Schleiden and Theodor Schwann
(D) Albrecht Von Roelliker

Comments
Latest MCQs

User-developed instructions for excel are called...?

(A) Program
(B) Macros

(C) Procedure
(D) All of these

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link