Selected MCQ

Current Question
Cell entry “July 16, 2016” will be considered a ____ by Excel sheet.
  • A. Number
  • B. Formula
  • C. Value
  • D. Label
Correct Answer: C
Explanation:
Excel automatically recognizes and stores dates as numeric values.
Related Question 1
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 2
How to duplicate values in a cell range in MS-Excel 2016?
  • A. Select the range of cells in the worksheet
  • B. Click the conditional formatting button in the Styles group of the Home tab
  • C. Both A and B
  • D. None of these
Correct Answer: C
Explanation:
Duplicate values can be highlighted using Conditional Formatting → Highlight Cells Rules → Duplicate Values.
Related Question 3
In MS Excel 2016, we can go to cell A1 by pressing ____.
  • A. Title + Home
  • B. Home
  • C. Shift + Home
  • D. Alt + Home
Correct Answer: B
Explanation:
Pressing the Home key moves the cursor to column A of the current row; Ctrl + Home takes you to A1.
Related Question 4
The first cell in an EXCEL worksheet is labeled as ____.
  • A. AA
  • B. A1
  • C. A a
  • D. AO
Correct Answer: B
Explanation:
The top-left cell is always A1.
Related Question 5
Computer spreadsheet cell that is highlighted with a heavy border is a ____.
  • A. Active cell
  • B. Cell containing a formula
  • C. Locked cell
  • D. Cell
Correct Answer: A
Explanation:
The cell with a heavy border is the active (currently selected) cell.