Online GK Series

This site is dedicated to the aspirants of competitive exams SSC, UPSC, Railways, Postal Assistants, Bank, GATE and NET

Get Attractive Job

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 symble
D None of the above

Answer: Option [B]
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

Useful Computer Science EBooks