Q1: Auto fit is used to
- a) adjust the row height as contents
- b) adjust the column width as contents
- c) both a and b
- d) none of the above
Q2: Which formula is used to make multiple calculations?
- a) simple
- b) complex
- c) both a and b
- d) none of the above
Q3: Which one is used to join text from two cells?
- a) &
- b) +
- c) #
- d) *
Q4: What is the use of LEN function?
- a) counts the number of characters in a cell
- b) counts the number of spaces in a cell
- c) deletes extra space in a text
- d) all of the above
Q5: Which functions does Excel contain?
- a) relative
- b) text
- c) built-in
- d) all of the above
