Learn Mode

Study questions with answers visible

Back
MS Excel Group C
50 Questions
Change Set
Question 21
Filter option is available under:
  • A Home
  • B Insert
  • C Data
  • D Review
Correct Answer: C
Question 22
To merge cells use:
  • A Merge & Center
  • B Wrap Text
  • C Format
  • D Insert
Correct Answer: A
Question 23
COUNT function counts:
  • A Text only
  • B Numbers only
  • C Both
  • D Blank cells
Correct Answer: B
Question 24
Shortcut to select entire sheet:
  • A Ctrl+A
  • B Ctrl+S
  • C Ctrl+Z
  • D Ctrl+F
Correct Answer: A
Question 25
Chart in Excel is used to:
  • A Typing
  • B Graphical representation
  • C Delete data
  • D Email
Correct Answer: B
Question 26
Pie chart shows:
  • A Trends
  • B Comparison
  • C Proportion
  • D Sequence
Correct Answer: C
Question 27
Column chart is used for:
  • A Comparison
  • B Total only
  • C Average
  • D None
Correct Answer: A
Question 28
Freeze Panes is used to:
  • A Lock rows/columns
  • B Delete rows
  • C Hide sheet
  • D Print
Correct Answer: A
Question 29
Wrap Text is used to:
  • A Delete text
  • B Fit text in cell
  • C Copy text
  • D Print text
Correct Answer: B
Question 30
Conditional Formatting is used to:
  • A Delete data
  • B Highlight data
  • C Print data
  • D Sort data
Correct Answer: B