🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

A reference that remains unchanged after copying is called ____.

  • A. Absolute Reference
  • B. Relative Reference
  • C. Static Reference
  • D. Dynamic Reference
Explanation:
Absolute references do not change when the formula is copied.

Which of the following is an absolute cell reference?

  • A. L$A1
  • B. $A$1
  • C. #A1
  • D. None of these
Explanation:
$A$1 is the standard absolute cell reference format.

$ sign in excel formula to ____ row and column.

  • A. update
  • B. new
  • C. fixed
  • D. duplicate
Explanation:
The $ sign fixes (makes absolute) the row or column reference.

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
Explanation:
Absolute reference ($A$1) keeps the cell fixed across sheets.

Which symbol is used for an Excel cell reference?

  • A. +
  • B. $
  • C. !
  • D. None of these
Explanation:
The dollar sign ($) is used to create absolute cell references.

Getting data from a cell located in a different sheet is called ____.

  • A. Accessing
  • B. Updating
  • C. Cell Referencing
  • D. Functioning
Explanation:
Referring to a cell in another sheet is called external cell referencing.

When you insert an Excel file to a Word document, the Data are ____.

  • A. Embedded
  • B. Linked
  • C. Hyperlinked placed in a Word table
  • D. None of these
Explanation:
The inserted Excel data is usually linked or embedded; document marks B.

In MS Excel you can use the horizontal and vertical scroll bars to ____.

  • A. Split a worksheet into two panes
  • B. View different rows and columns
  • C. Edit the contents of a cell
  • D. View different worksheets
Explanation:
Scroll bars allow navigation through rows and columns.

The thin black cross-shaped pointer in MS Excel is used to ____.

  • A. Complete lists and fill patterns
  • B. Move a group of cells
  • C. Resize
  • D. Highlight duplicate cells
Explanation:
The fill handle (black cross) is used for AutoFill and copying patterns.

In MS Excel, if a numeric value starts with ____ then this value is treated as a label.

  • A. Hash
  • B. Equal Sign
  • C. Apostrophe
  • D. Title
Explanation:
Prefixing with an apostrophe (') forces Excel to treat the entry as text/label.