🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

How to fit long texts in a single cell with multiple lines?

  • A. Use the Wrap Text option in the Format → Alignment menu
  • B. Start typing in the Formula bar and press the Enter key
  • C. Use the Shrink to Fit option in the Format → Cells → Alignment menu
  • D. All of the above
Explanation:
The Wrap Text command automatically breaks long text into multiple lines within the cell.

When applying conditional formatting, you can check the conditions against ____.

  • A. Formula
  • B. Cell Value
  • C. Both A & B
  • D. None of these
Explanation:
Conditional formatting rules can be based on cell values or formulas.

How often does MS Excel auto-save a file by default?

  • A. Every 10 minutes
  • B. Every 20 minutes
  • C. Every 30 minutes
  • D. Every 40 minutes
Explanation:
The default AutoRecover interval in Excel is every 10 minutes.

In MS Excel, Ready-made templates are available under ____ tab.

  • A. File
  • B. Insert
  • C. Design
  • D. None of these
Explanation:
Templates are accessed from the File → New menu.

How do you tell one cell from another?

  • A. By address
  • B. By values
  • C. By formulas
  • D. All of these
Explanation:
Each cell is uniquely identified by its address (e.g., B5).

In MS Excel 2016, we can go to cell A1 by pressing ____.

  • A. Title + Home
  • B. Home
  • C. Shift + Home
  • D. Alt + Home
Explanation:
Pressing the Home key moves the cursor to column A of the current row; Ctrl + Home takes you to A1.

When we open the new worksheet, which is at the top?

  • A. Title bar
  • B. Menu bar
  • C. Formula bar
  • D. Home
Explanation:
The Title bar is always at the very top of the Excel window.

Address of the cell at 27th column and 30th row is ____.

  • A. AA20
  • B. AZ26
  • C. 26,30
  • D. None of these
Explanation:
Column 27 = AA, row 30 = AA30.

Which of the following is the correct column name?

  • A. AA
  • B. 30A
  • C. 3B
  • D. B3
Explanation:
Columns are labeled with letters (AA is column 27).

Which of the following is a valid cell address?

  • A. A6
  • B. 6A
  • C. A-6
  • D. None of these
Explanation:
Cell addresses follow the column-letter + row-number format.