Home >> MS Excel MCQs >>

MS Excel Set 06

MS Excel Set 06

Q.1 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

View Answer

ANSWER: A) position the mouse pointer over the cell
Explanation : When we hover the pointer on a cell MS Excel show the contents in a cell tip
Q.2 Which of these will not select all the cells in a document?
A. None of These
B. Using the Edit – Select All menu
C. Pressing Ctrl + A on the keyboard
D. Clicking three times with the right mouse button in the spreadsheet

ANSWER: D) Clicking three times with the right mouse button in the spreadsheet
Explanation : Clicking three times with the right mouse button in the spreadsheet is not a valid shortcut in MS Excel.
Q.3 Which of following is not an element of computer spreadsheet interface?
A. Active cell
B. Pencil work
C. Workbook
D. Menu bar

ANSWER: B) Pencil work
Explanation : MS Excel is a accounting based sofware and pencil work is not a valid option in it.
Q.4 Basic unit of a computer worksheet in which you enter text and numbers is known as __________ ?
A. workbook
B. cell
C. row
D. column

ANSWER: B) cell
Explanation : Cell is the basic buiding clock of Excel workbook which is used to enter and manage data in a workbook.
Q.5 User developed instruction for excel are called__________?
A. Procedure
B. Macros
C. Programs
D. All of these

ANSWER: B) Macros
Explanation : User can make his own short key by recording a macro in MS Excel. Macros is a very powerful tool to work with MS Excel.
Q.6 Computer spreadsheet cell that is highlighted with a heavy border is a _________ ?
A. Cell
B. Active cell
C. Locked cell
D. Cell containing a formula

ANSWER: B) Active cell
Explanation : When we select a cell to in MS Excel for woek. It is highlighted with a heacy border. This Cell in known as Active Cell.
Q.7 In a computer spreadsheet, block of cells is called __________ ?
A. Workbook
B. Function
C. Column
D. Range

ANSWER: D) Range
Explanation : When we select multiple cell at same time this block of cell is known as Cell Range.
Q.8 In a computer spreadsheet, which is true if current or active cell is B4 and you pressed Enter key?
A. you will be in the cell A1
B. you will be in the cell B5
C. you will be in the cell B3
D. you will be in the cell B6

ANSWER: B) you will be in the cell B5
Explanation : Pressing enter, the control will move to the next row in same column so you will be in Cell B5.
Q.9 Title bar in MS-Excel displays name of the __________ ?
A. Worksheet
B. Workbook
C. Formula
D. Location

ANSWER: B) Workbook
Explanation : Title bar contains name of both file and program. As MS Excel file is called Workbook. So we can say that title bar contains the name of workbook.
Q.10 In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?
A. Length
B. Counter
C. Counting
D. Count

ANSWER: D) Count
Explanation : Count() function is used to count numbers of entries in given range
Test Your Learning

Related Posts

More MCQs