Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

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

Questions
41 What is the keyboard shortcut for creating a chart from the selected cell range ?
A F9
B F10
C F11
D F12

Answer: Option [C]
42 What is the shortcut key to insert current date in a cell ?
A CTRL + ;
B CTRL + T
C CTRL + D
D CTRL + '

Answer: Option [A]
43 Which of the following function will use to find the highest number in a series of number ?
A HIGH (B1:B3)
B MAXIMUM (B1:B3)
C MAX(B1:B3)
D None of the above

Answer: Option [C]
44 Which of the following syntax is correct regarding to SUM function in Excel ?
A =SUM (A1, B1)
B =SUM (A1:B9)
C =SUM (A1:A9, B1:B9)
D All of the above

Answer: Option [C]
45 What is the shortcut key to hide entire column ?
A CTRL + H
B CTRL + 0
C CTRL + −
D None of the above

Answer: Option [B]

Computer Science Books

Chapters

Please Like Us
Brand