Current Affairs Quiz 2024GKCourses AptitudeADRE 2.0EnglishUGC NET

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

Download PDF

Download in pdf microsoft excel(MS Excel) multiple choice questions(mcqs) & answers. These general awareness quiz objective questions answers include mcqs on cell, currency, now function, conditional formatting etc.
Go To Download Page
(6) Which of the following methods will not enter data in a cell ?
[A] Pressing the Esc key
[B] Pressing the tab key
[C] Clicking the enter button to the formula bar
[D] None of the above

Comment

Answer: Option [A]
(7) Formatting a cell in Currency, you can specify
[A] Decimal Places
[B] Currency Symbol
[C] Percentage symbol
[D] None of the above

Comment

Answer: Option [B]

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

Article and Schedule Quiz Start Test!
(8) Which function will you use to enter current time in a worksheet cell ?
[A] =currentTime()
[B] =time()
[C] =now()
[D] All of the above

Comment

Answer: Option [C]
(9) Which of the following format you can decide to apply or not in AutoFormat dialog box ?
[A] Font format
[B] Number format
[C] Border format
[D] All of the above

Comment

Answer: Option [D]
(10) When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
[A] Use =if() function to format the required numbers red
[B] Apply Conditional Formatting command on Home Tab
[C] Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
[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