Selected MCQ

Current Question
Which function displays row data into a column or column data into a row?
  • A. Hyperlink
  • B. Index
  • C. Transpose
  • D. Rows
Correct Answer: C
Explanation:
TRANSPOSE switches rows and columns.
Related Question 1
A computer application program that displays data arranged in rows and columns is called ____.
  • A. Spreadsheet
  • B. Register
  • C. Form
  • D. Box
Correct Answer: A
Explanation:
A spreadsheet displays data in rows and columns.
Related Question 2
Which function is used to find the related data in MS Excel?
  • A. VLOOKUP
  • B. FLOOKUP
  • C. RLOOKUP
  • D. HLOOKUP
Correct Answer: A
Explanation:
VLOOKUP searches vertically for related data.
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
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 5
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.