🏠 Home
MCQ Practice

Computer & IT MCQs

Cells in MS Excel can be uniquely identified by ____.

  • A. Column letters and row numbers
  • B. Column numbers and row letters
  • C. Cell coordinates
  • D. None of these
Explanation:
Cells are identified by column letter + row number (e.g., A1).

The basic unit of a worksheet into which you enter data is called as ____.

  • A. Tab
  • B. Cell
  • C. Box
  • D. Range
Explanation:
Data is entered into a cell.

A single worksheet contains ____.

  • A. 1048576 columns
  • B. 16384 columns
  • C. 256 columns
  • D. None of these
Explanation:
A single worksheet has 1,048,576 rows and 16,384 columns.

A collection of related worksheets is called ____.

  • A. Workbook
  • B. File
  • C. Group
  • D. None of these
Explanation:
Multiple worksheets together form a workbook.

Which is not a nomenclature of MS Excel?

  • A. Workbook
  • B. Cell
  • C. Document
  • D. Worksheet
Explanation:
“Document” is not used in Excel; it uses workbook and worksheet.

Basic unit of a computer spreadsheet in which you enter text and numbers is known as ____.

  • A. Workbook
  • B. Column
  • C. Row
  • D. Cell
Explanation:
The basic unit is a cell.

The intersection of a column and row in a spreadsheet is called ____.

  • A. Key
  • B. Field
  • C. Cell
  • D. Menu
Explanation:
The intersection is called a cell.

In Microsoft Excel, the file you create and edit is called ____.

  • A. A form
  • B. A ledger
  • C. A table
  • D. A workbook
Explanation:
The file created in Excel is called a workbook.

In MS Excel, how many worksheets are in a workbook by default?

  • A. 3
  • B. 4
  • C. 5
  • D. None of these
Explanation:
Excel opens with 3 worksheets by default.

An excel workbook is a collection of ____.

  • A. Workbooks
  • B. Worksheets
  • C. Charts
  • D. Worksheets and Charts
Explanation:
A workbook contains multiple worksheets and charts.