MS-Excel (Online Practice) Page 14

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

Share :

Back To Top

facebook main


Powered by Blogger.