Current Affairs Quiz 2024Courses UGC NETADRE 2.0English

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

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

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

LEAVE A COMMENT