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

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

Article and Schedule Quiz Start Test!
(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]

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!

Chapters