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 :

Twitter
Back To Top

facebook main

counter

Powered by Blogger.