Multiple Choice Questions and Answers on MS Excel | Page-6

26 What is the short cut key to highlight the entire column ?
A Ctrl + Space Bar
B Ctrl + Enter
C Ctrl + Right Arrow key
D None of the above

Answer: Option [A]
27 In the formula, which symbol specifies the fixed columns or rows ?
A &
B %
C $
D All of the above

Answer: Option [C]
28 What does COUNTA () function do ?
A counts cells having alphabets
B counts selected cells
C counts empty cells
D counts non-empty cells

Answer: Option [D]
29 In Excel, you can sum a large range of data by simply selecting a tool button called ....
A Auto sum
B Auto correct
C AutoFill
D None of the above

Answer: Option [A]
30 Which of the following is not a term of MS-Excel ?
A Document
B Cells
C Rows
D Workbook

Answer: Option [A]


Useful Computer Science EBooks