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

PPSC Past Papers

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 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 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

Maximum zoom percentage in Excel is _________...?

(A) 100%
(B) 300%

(C) 400%
(D) 500%

Comments
Latest MCQs

Which of the following is not a term pertaining to spreadsheets...?

(A) cell
(B) character

(C) browser
(D) formula

Comments
Latest MCQs

A feature of MS Office that saves the document automatically after certain interval is called:...?

(A) Save
(B) Save as

(C) Auto save
(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

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

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

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

(A) Cell address
(B) Range

(C) Formula
(D) Current cell

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

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

A feature of MS Office that saves the document automatically after certain interval is called:...?

(A) Save
(B) Save as

(C) Auto save
(D) None of these

Comments
Latest MCQs

A feature of MS Office that saves the document automatically after certain interval is called ____...?

(A) Save
(B) Save As

(C) Auto save
(D) None of the above

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

# 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

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

(A) Number
(B) Character

(C) Label
(D) Date

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 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 key is used to edit the selected cell in excel...?

(A) F2
(B) F10

(C) F4
(D) F8

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

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

(A) F1
(B) F3

(C) F6
(D) F5

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

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

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

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

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

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

(A) 6A
(B) A6

(C) AA6
(D) +A+

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

Letters in Excel denote: ______________...?

(A) Columns
(B) rows

(C) numbers
(D) reference

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

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

Letters in Excel denote :...?

(A) Columns
(B) rows

(C) numbers
(D) reference

Comments
Latest MCQs

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

(A) Number
(B) Label

(C) Character
(D) none

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

A feature of MS Word that saves the document automatically after certain interval is available on___________...?

(A) Save tab on Options dialog box
(B) Save As dialog box

(C) Both of above
(D) None of above

Comments
Latest MCQs

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

(A) Number
(B) Label

(C) Character
(D) none

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

Which of the following will not enter data in a cell...?

(A) Pressing the Esc key
(B) Pressing the Tab Key

(C) Both of these
(D) None of above

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

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

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

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

(A) 01
(B) 03

(C) 05
(D) 07

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link