What is a cell in Excel...? Mcqs

PPSC Past Papers

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

If you press ___, the cell accepts your typing as its contents ...?

(A) Tab
(B) Ctrl+Enter

(C) Enter
(D) Alt+Enter

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

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

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

(A) Cell address
(B) Range

(C) Formula
(D) Current cell

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

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

(A) $
(B) @

(C) &
(D) %

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 these will not select all the cells in a documents ...?

(A) Clicking three times with the right mouse button in the spreadsheet
(B) both

(C) Using the Edit- Select all menu
(D) None

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

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

(A) 2
(B) 3

(C) 4
(D) 5

Comments
Latest MCQs

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

(A) 01
(B) 03

(C) 05
(D) 07

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

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

(A) 10
(B) 100

(C) 300
(D) 500

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

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

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

(A) F2
(B) F10

(C) F4
(D) F8

Comments
Latest MCQs

Maximum zoom percentage in Excel is _________...?

(A) 100%
(B) 300%

(C) 400%
(D) 500%

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

How we can view a cell comment?...?

(A) Position the mouse pointer over the cell
(B) Click the comment command on the viewmenu

(C) Click the edit comment commands on the Insert menu
(D) Click the display comment command on the window menu

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

Constant value in excel also called ...?

(A) Number
(B) words

(C) mark
(D) None

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

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

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

Selected cell of excel...?

(A) Active Cell
(B) Cell No

(C) Formula cell
(D) None Of These

Comments
Latest MCQs

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

(A) Number
(B) Label

(C) Character
(D) none

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

Which of these will not select all the cells in a document?...?

(A) Using the Edit-Selection All menu
(B) Pressing Ctrl + A on the keyboard

(C) Clicking three times with the right mouse button in the spreadsheet
(D) None of these

Comments
Latest MCQs

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

(A) Number
(B) Label

(C) Character
(D) none

Comments
Latest MCQs

The cell referencing that does not change when copied is:...?

(A) Absolute
(B) Comparative

(C) Relative cell addressing
(D) Reference

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

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

(A) Number
(B) Character

(C) Label
(D) Date

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

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

If you press ___, the cell accepts your typing as its contents...?

(A) Enter
(B) Ctrl+Enter

(C) Tab
(D) None

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

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

(A) AA
(B) A1

(C) Aa
(D) None of these

Comments
Latest MCQs

In MS Excel; comments put in the cell are called...?

(A) Smart tip
(B) Vip tip

(C) Soft tip
(D) Cell tips

Comments
Latest MCQs

If you press ____ the cell accepts your typing as its content...?

(A) Tab
(B) Ctrl+Enter

(C) Enter
(D) Alt+Enter

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

How we can view a cell comment ...?

(A) position the mouse pointer over the cell
(B) click the comment command on the view menu

(C) click the edit comment commands on the Insert menu
(D) click the Display comment command on the window menu

Comments
Latest MCQs

Which of these will not select all the cells in a document ...?

(A) Using the Edit – Select All menu
(B) Pressing Ctrl + A on the keyboard

(C) Clicking three times with the right mouse button in the spreadsheet
(D) None of These

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

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

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

(A) 10
(B) 100

(C) 300
(D) 500

Comments
Latest MCQs

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

(A) AA
(B) Aa

(C) A1
(D) None of these

Comments

MCQs Categories


Best of Luck

From ShineGk.com

Share our website's link