Which of these is not an operator in MS Excel?
Text Concatenation Operator
Reference Operator
Arithmetic Operator
Logical Operator
SHOW ANSWERHow many steps are there to create charts in MS Excel?
2
3
4
5
SHOW ANSWERThe cell address in the Microsoft Office Excel document is__________
Column Name
Row Name
First Row then Column Name
First Column then Row Name
SHOW ANSWERIf you want a blank line after the title in the worksheet, which of these methods Will be the best?
Re-format the spreadsheet
Insert the Row
Increase the column width
Use the Space bar
SHOW ANSWERHow the data is organize in the spreadsheet?
Line and Spacing
Rows and Columns
Layers and Pallets
Height and Width
SHOW ANSWER“Comment” option is found in the _____menu.
Insert
Data
Review
View
SHOW ANSWERWhich of these statements is not correct?
You can create graph in Excel sheet
Excel sheet has an extension .doc
The new workbook is called book 1
None of these
SHOW ANSWERWho can use a spreadsheet?
Finance professionals
Engineers
Stoke Brokers
All of these
SHOW ANSWERWhat is the shortcut to open the dialog box of format cell?
Alt +1
Ctrl +1
Ctrl+ Shift+1
None of these
SHOW ANSWERThe programming language in which Excel keeps the Macro code record.
Java
Visual Basic
Basic
Video Basic
SHOW ANSWERWhich menu is used to show and hide the Status Bar in Excel?
Edit
File
View
Format
SHOW ANSWERWhich column will you select to insert a new column between column D and E?
Select column E
Select column D
Select column E,F,G
Select column D,E,F
SHOW ANSWER