Q1: Which is used for searching the data of left most column vertically?
- a) SLOPE
- b) VALUE
- c) VLOOKUP
- d) all of the above
Q2: Which ensures that the data entered into a cell or range of cells is within limits?
- a) validation
- b) calculation
- c) guideline
- d) maximization
Q3: Which is the shortcut key to edit a cell comment?
- a) F2
- b) alt + F2
- c) ctrl + F2
- d) shift + F2
Q4: Which one is used to unhide column?
- a) ctrl + u
- b) ctrl + shift + )
- c) ctrl + shift + 0
- d) alt + )
Q5: Which one is native file format for MS Excel? (2003)
- a) .doc
- b) .xls
- c) .txt
- d) .cel
