Q1: Which key is used to work with non-adjacent cells in excel?
- a) ctrl key
- b) shift key
- c) alt key
- d) tab key
Q2: Which element of a worksheet can be protected from accidental modification?
- a) contents
- b) objects
- c) scenarios
- d) all of the above
Q3: Which one is used to remove the extra space from the left side of string?
- a) LEFT( )
- b) LTRIM( )
- c) RTRIM( )
- d) RIGHT( )
Q4: In MS Excel, the cell can be activated by which of the following method?
- a) clicking the cell
- b) using arrow key
- c) using tab key
- d) all of the above
Q5: Which one is valid cell address?
- a) 1A
- b) $1A
- c) $A
- d) A1
