Selected MCQ

Current Question
When adding two cells in a spreadsheet, which of the following represents the correct formula?
  • A. #REF?
  • B. = A1 + A2
  • C. (A1 + A2)
  • D. SUM(A1,A2)
Correct Answer: B
Explanation:
=A1+A2 is the correct basic addition formula.
Related Question 1
Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as ____.
  • A. Decoration
  • B. Data appearance
  • C. Functions
  • D. Charting
Correct Answer: D
Explanation:
The feature is called charting or chart creation.
Related Question 2
After creating the table, which of the following is correct?
  • A. Fields cannot be deleted
  • B. Fields cannot be added, but only once
  • C. Fields cannot be deleted
  • D. None of these
Correct Answer: D
Explanation:
After the table is created, fields can normally be added or deleted.
Related Question 3
Which of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument?
  • A. COUNT
  • B. AVERAGE
  • C. SUM
  • D. MAX
Correct Answer: A
Explanation:
COUNT tallies only numeric cells.
Related Question 4
If you want to add the contents of cells A1 and A2 together in Excel, which formula would you use?
  • A. =SUM(A1, A2)
  • B. #NAME?
  • C. =A1 + A2
  • D. None of these
Correct Answer: C
Explanation:
The simple addition formula =A1+A2 directly adds the two cells.
Related Question 5
With which of the following do all formulas in Excel start?
  • A. /
  • B. =
  • C. +
  • D. &
Correct Answer: B
Explanation:
Every formula in Excel must begin with the equals sign (=).