Selected MCQ

Current Question
In MS Excel evaluate the formulae (7-3) (6+1)/4 result will be ____.
  • A. 5
  • B. 3
  • C. 7
  • D. 8
Correct Answer: C
Explanation:
(7-3) × (6+1) ÷ 4 = 4 × 7 ÷ 4 = 7.
Related Question 1
Which of the following Excel features allows users to evaluate values and return a result?
  • A. Formulas
  • B. Formatting
  • C. Filters
  • D. Insertions
Correct Answer: A
Explanation:
Formulas and functions evaluate data and return results.
Related Question 2
Excel would evaluate the formula, =2010/58, and return answer as ____.
  • A. 34.655
  • B. 6.25
  • C. 320
  • D. 132
Correct Answer: A
Explanation:
2010 ÷ 58 equals approximately 34.655.
Related Question 3
MS Excel will not be able to calculate which of the following formulae?
  • A. =SUM(Sales)-A5
  • B. =SUM(A1:A5)/5
  • C. =SUM(A1:A5)*(10)
  • D. =SUM(A1:A5)-10
Correct Answer: A
Explanation:
“Sales” is not a valid cell reference or defined name, so Excel cannot calculate it.
Related Question 4
Comment put on Excel cell, which is displayed by taking the Mouse Pointer there, is called ____.
  • A. Smart tip
  • B. Soft Tip
  • C. Web Tip
  • D. Cell Tip
Correct Answer: D
Explanation:
A comment in Excel is displayed as a Cell Tip when hovering the mouse.
Related Question 5
Actual working area of Computer's Microsoft Excel is ____.
  • A. Workbook
  • B. Worksheet
  • C. Notesheet
  • D. Notebook
Correct Answer: B
Explanation:
The worksheet (spreadsheet) is the actual working area in Excel.