GkSeries.com

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

Download PDF

Download in pdf microsoft excel(MS Excel) multiple choice questions(mcqs) & answers. These general awareness quiz objective questions answers include mcqs on rows and columns, COUNTA () etc.
Go To Download Page
(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

Comment

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

Comment

Answer: Option [C]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

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

Comment

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

Comment

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

Comment

Answer: Option [A]

Please share this page

Chapters

Click Here to Read more questions

Teacher Eligibility Test