Q1: Which one is used hold down the column titles or rows titles so that they do not scroll while scrolling worksheet?
- a) freeze panes
- b) unfreeze panes
- c) both a and b
- d) none of above
Q2: Which of the following can be paste using paste special command?
- a) validation
- b) formats
- c) formula
- d) all of the above
Q3: Which category of Excel functions return (true-false) values?
- a) logical
- b) statistical
- c) information
- d) all of the above
Q4: What will be the result in given formula if data in A1 = “YES”? (=IF (A1 = “YES”, “START”, “RESTART”)?
- a) result will be “START”
- b) result will be “RESTART”
- c) result will be “YES”
- d) the formula is incorrect
Q5: What is the use of F1 key?
- a) save
- b) help
- c) edit
- d) close
