M.S.Excel QUIZ-01

Getting data from a cell located in a different sheet is called….
Accessing
Referencing
Updating
Functioning


A numeric value can be treated as label value if …… precedes it.
Exclamation (!)
Apostrophe (‘)
Hash (#)
Tilde (~)

Comments can be added to cells using …..
 Edit -> Comments
Insert -> Comment 
File -> Comments
View –> Comments

Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar 
Standard Tool Bar

 Which elements of a worksheet can be protected from accidental modification?
 Contents
 Objects
 Scenarios
All of the above

Concatenation of text can be done using
 Apostrophe (‘)
 Exclamation (!)
 Hash (#)
 Ampersand (&)

Comments put in cells are called …..
Smart Tip
Cell Tip
Web Tip
Soft Tip

Multiple calculations can be made in a single formula using…..
Standard Formulas
Array Formula
Complex Formulas
Smart Formula

Which menu option can be used to split windows into two?
Format -> Window
View -> Window-> Split
Window -> Split 
View –> Split

Read More:- 02  03  04 05