Q1: What is the result of the function LEFT(“computer”,4)?
- a) uter
- b) comp
- c) computer
- d) all of the above
Q2: Which of the following is type of filter?
- a) auto filter
- b) advanced filter
- c) both a and b
- d) none of the above
Q3: Which of the following can be used in a cell?
- a) value
- b) formula
- c) format
- d) all of the above
Q4: What is the group of cells in spreadsheet called?
- a) range
- b) formula
- c) text
- d) menu
Q5: Which tool is used to sum large range of data?
- a) auto fill
- b) auto sum
- c) auto correct
- d) auto format