Q1: Which is the latest date allowed for calculation?
- a) December 31, 3000
- b) December 31, 2099
- c) December 31, 5555
- d) December 31, 9999
Q2: Which one is used to insert blank cell in MS Excel?
- a) ctrl + B
- b) ctrl + shift + +
- c) ctrl + shift + =
- d) ctrl + alt + =
Q3: Which shortcut key is used to remove the outline boarder?
- a) ctrl + O
- b) ctrl + alt + O
- c) ctrl + shift + _
- d) ctrl + alt + _
Q4: Which one is used to create names from row and column label?
- a) ctrl + F3
- b) ctrl + shift + F3
- c) ctrl + alt + F3
- d) alt + F3
Q5: A data validation rule that is cautionary, is also considered to be a
- a) warning
- b) mandatory
- c) formula
- d) reference