GkSeries.com

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

Download PDF

Download in pdf microsoft excel(MS Excel) multiple choice questions(mcqs) & answers. These general awareness quiz objective questions answers include mcqs on chart, current date, sum and max function etc.
Go To Download Page
(41) What is the keyboard shortcut for creating a chart from the selected cell range ?
[A] F9
[B] F10
[C] F11
[D] F12

Comment

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

Comment

Answer: Option [A]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

(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

Comment

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

Comment

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

Comment

Answer: Option [B]

Please share this page

Chapters

Click Here to Read more questions

Teacher Eligibility Test