Q1: Which one is used to group rows or column?
- a) ctrl + G
- b) ctrl + D
- c) alt + shift + right arrow
- d) alt + shift + left arrow
Q2: What is the shortcut key to hide a column, row or cell?
- a) ctrl + 0
- b) ctrl + Y
- c) ctrl + Z
- d) ctrl + D
Q3: Which one is used to insert the auto sum formula?
- a) alt + +
- b) alt + =
- c) ctrl + =
- d) ctrl + +
Q4: What is the maximum number of panes in window?
- a) 4
- b) 5
- c) 6
- d) 7
Q5: What is the maximum number of nested levels of functions?
- a) 4
- b) 5
- c) 7
- d) 8
