Learn Mode

Study questions with answers visible

Back
MS Excel Group C
50 Questions
Change Set
Question 1
MS Excel is primarily used for:
  • A Word Processing
  • B Spreadsheets
  • C Presentation
  • D Email
Correct Answer: B
Question 2
Default Excel file extension is:
  • A docx
  • B xlsx
  • C pptx
  • D txt
Correct Answer: B
Question 3
Rows in Excel are identified by:
  • A Letters
  • B Numbers
  • C Symbols
  • D Codes
Correct Answer: B
Question 4
Columns in Excel are identified by:
  • A Numbers
  • B Letters
  • C Symbols
  • D Codes
Correct Answer: B
Question 5
Intersection of row and column is called:
  • A Table
  • B Cell
  • C Sheet
  • D Box
Correct Answer: B
Question 6
Formula in Excel always starts with:
  • A @
  • B =
  • C #
  • D $
Correct Answer: B
Question 7
SUM function is used to:
  • A Multiply
  • B Add
  • C Divide
  • D Subtract
Correct Answer: B
Question 8
AVERAGE function calculates:
  • A Total
  • B Middle value
  • C Mean
  • D Maximum
Correct Answer: C
Question 9
Maximum function is written as:
  • A =MAX(A1:A10)
  • B MAX(A1:A10)
  • C =MAX(A1A10)
  • D =MAXA1:A10
Correct Answer: A
Question 10
To edit a cell quickly press:
  • A F1
  • B F2
  • C F5
  • D F7
Correct Answer: B