Selected MCQ

Current Question
How do you automatically adjust the width of a column in Excel?
  • A. Double-click the left border of the column
  • B. Double-click the right border of the column
  • C. Double-click the column header
  • D. All of the above
Correct Answer: B
Explanation:
Double-clicking the right border of the column header auto-fits the column width.
Related Question 1
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 2
$ sign in excel formula to ____ row and column.
  • A. update
  • B. new
  • C. fixed
  • D. duplicate
Correct Answer: C
Explanation:
The $ sign fixes (makes absolute) the row or column reference.
Related Question 3
In Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of reference should you use?
  • A. Absolute reference
  • B. Relative reference
  • C. Mixed reference
  • D. Circular reference
Correct Answer: A
Explanation:
Absolute reference ($A$1) keeps the cell fixed across sheets.
Related Question 4
In Microsoft Excel the intersection of column and row is called a ____.
  • A. Data
  • B. Table
  • C. Cell
  • D. Schema
Correct Answer: C
Explanation:
The intersection of a row and a column is a single cell.
Related Question 5
In Excel, spacing in column is called as ____.
  • A. Strikethrough
  • B. Paper Size
  • C. Page Layout
  • D. All of the above
Correct Answer: C
Explanation:
Column spacing and layout settings are managed under the Page Layout tab.