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

Questions
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

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

Answer: Option [B]

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
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

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

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

Answer: Option [B]

Chapters

ADRE 3.0 Complete Study Material