Selected MCQ

Current Question
The function is ____ which can calculate the value given in a specific order.
  • A. Program
  • B. Predefined formula
  • C. Software
  • D. None of these
Correct Answer: B
Explanation:
Functions are built-in, predefined formulas in Excel.
Related Question 1
Which function calculates the largest value in a set of numbers in Excel?
  • A. Average
  • B. Count
  • C. Minimum
  • D. Maximum
Correct Answer: D
Explanation:
The MAX function returns the largest value in a range.
Related Question 2
In MS Excel, which function automatically totals a column or row of values?
  • A. Total
  • B. ADD
  • C. SUM
  • D. AVG
Correct Answer: C
Explanation:
SUM is the dedicated function for totaling values.
Related Question 3
The ____ function in Excel returns the highest value in a set of data that you specify.
  • A. MAX
  • B. AVG
  • C. LRG
  • D. None of these
Correct Answer: A
Explanation:
MAX returns the largest value in a range.
Related Question 4
A ____ is a dynamic mathematical calculation that displays a single value for a specific field.
  • A. Format row
  • B. Criteria row
  • C. Aggregate function
  • D. Format layout
Correct Answer: C
Explanation:
Aggregate functions (SUM, AVERAGE, COUNT, etc.) calculate a single summary value.
Related Question 5
____ is the set of instructions given to the computer to perform a specific task.
  • A. Monitor
  • B. Software
  • C. Hardware
  • D. Printer
Correct Answer: B
Explanation:
Software is a set of instructions that tells the computer what to do.