🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

In Microsoft Excel the intersection of column and row is called a ____.

  • A. Data
  • B. Table
  • C. Cell
  • D. Schema
Explanation:
The intersection of a row and a column is a single cell.

In Excel, spacing in column is called as ____.

  • A. Strikethrough
  • B. Paper Size
  • C. Page Layout
  • D. All of the above
Explanation:
Column spacing and layout settings are managed under the Page Layout tab.

“IF function” typically refers to a function used in ____.

  • A. Programming
  • B. Mathematics
  • C. Spreadsheets
  • D. Databases
Explanation:
The IF function is a built-in logical function in spreadsheet software like Excel.

You can activate a cell by ____.

  • A. Active cell
  • B. Cell containing a formula
  • C. Locked cell
  • D. Cell
Explanation:
Clicking or navigating to a cell makes it the active cell.

Which Excel feature is associated with a bold line appearing around a cell when selected?

  • A. Freeze Panes
  • B. Filter
  • C. Data Validation
  • D. Active cell Highlighting
Explanation:
The bold border indicates the active cell.

In MS Excel, you cannot edit the contents of a cell by ____.

  • A. Pressing the Alt key
  • B. Clicking the formula bar
  • C. Pressing the F2 key
  • D. Double-clicking the cell
Explanation:
Alt key does not activate cell editing; the other methods do.

Which keyword is used to find the number of values in a column?

  • A. Total
  • B. Add
  • C. Count
  • D. Sum
Explanation:
The COUNT function tallies the number of numeric values in a range.

To insert a formula, you would typically use the ____.

  • A. Formula Icon
  • B. Function wizard
  • C. AutoSum
  • D. Equation editor
Explanation:
The Function Wizard (fx) helps insert and build complex formulas.

In MS Excel, the undo option will ____ the last action.

  • A. Replace
  • B. Change
  • C. Repeat
  • D. Recoverable
Explanation:
Undo reverses the most recent change made in the worksheet.

Excel would evaluate the formula, =2010/58, and return answer as ____.

  • A. 34.655
  • B. 6.25
  • C. 320
  • D. 132
Explanation:
2010 ÷ 58 equals approximately 34.655.