Question Detail

Shortcut to enter current date ?

Home + ;
Shift + ;
Alt + ;
Ctrl + ;

Answer: Option D

Similar Questions :

1. VLOOKUP function used to ?

Finds related records
Looks up text that contain "v"
Check if two cells are identical
None of above

Answer: Option A

2. To insert three columns between columns A and B you would

Select column A
Select A and B
Select B
All of above

Answer: Option C

3. Which of these will not select all the cells in a document ?

Using the Edit – Select All menu
Pressing Ctrl + A on the keyboard
Clicking three times with the right mouse button in the spreadsheet

Answer: Option C

4. How we can view a cell comment ?

position the mouse pointer over the cell
click the comment command on the view menu
click the edit comment commands on the Insert menu
click the Display comment command on the window menu

Answer: Option A

5. You can check the conditions against ____ when applying conditional formatting ?

Cell Value
Formula
Both of above
None of above

Answer: Option C

Read more from - MS Excel Questions Answers