Learn with Yasir

Share Your Feedback

Microsoft Excel MCQs - Test Your Knowledge of Excel Basics

« Back Next »

Challenge your understanding of Microsoft Excel with these multiple-choice questions. Covering topics like worksheets, workbooks, formulas, shortcuts, and data entry, this quiz is perfect for beginners to assess and improve their Excel skills.

📝 Multiple Choice Questions

🟢 Beginner

Q1. What is a file that contains one or more worksheets in Excel called?

  • 🟢 A. Workbook
  • 🔵 B. Document
  • 🟠 C. Spreadsheet
  • 🔴 D. Database
Answer

Workbook

A workbook is an Excel file containing one or more worksheets for organizing related data.

Q2. What is the intersection of a row and a column in Excel called?

  • 🟢 A. Box
  • 🔵 B. Cell
  • 🟠 C. Grid
  • 🔴 D. Slot
Answer

Cell

A cell is where a column and row meet, and it's where data is entered in Excel.

Q3. Which symbol is used to begin a formula in Excel?

  • 🟢 A. +
  • 🔵 B. @
  • 🟠 C.
  • 🔴 D. =
Answer

=

All formulas in Excel begin with an equal sign.

Q4. What is the web-based version of Excel called?

  • 🟢 A. Excel Lite
  • 🔵 B. Excel Anywhere
  • 🟠 C. Excel Online
  • 🔴 D. Excel Web
Answer

Excel Online

Excel Online is the browser-based version of Microsoft Excel, part of Microsoft 365.

Q5. What is a cell in a spreadsheet?

  • 🟢 A. A collection of workbooks
  • 🔵 B. A single spreadsheet
  • 🟠 C. The intersection of a row and column
  • 🔴 D. A formula in a spreadsheet
Answer

The intersection of a row and column

A cell is the basic unit in Excel where a row and a column intersect.

Q6. What is the address of a cell?

  • 🟢 A. The name of the workbook
  • 🔵 B. The name of the worksheet
  • 🟠 C. The letter of the column and the number of the row
  • 🔴 D. The formula in the cell
Answer

The letter of the column and the number of the row

A cell's address is identified by its column letter and row number, like A1.

Q7. What is the term used for a single page in an Excel workbook?

  • 🟢 A. workbook
  • 🔵 B. worksheet
  • 🟠 C. row
  • 🔴 D. column
Answer

worksheet

A worksheet is a single tab or sheet within a workbook.

Q8. What is the unique identifier for a cell in a worksheet?

  • 🟢 A. workbook
  • 🔵 B. worksheet
  • 🟠 C. cell address
  • 🔴 D. row
Answer

cell address

The cell address (e.g., B3) uniquely identifies a cell's position.

Q9. What are rows and columns?

  • 🟢 A. Both rows and columns are vertical divisions of a worksheet.
  • 🔵 B. Both rows and columns are horizontal divisions of a worksheet.
  • 🟠 C. Rows are vertical divisions of a worksheet, and columns are horizontal divisions of a worksheet.
  • 🔴 D. Rows are horizontal divisions of a worksheet, and columns are vertical divisions of a worksheet.
Answer

Rows are horizontal divisions of a worksheet, and columns are vertical divisions of a worksheet.

Rows run horizontally and columns vertically in Excel, forming the grid.

🟡 Intermediate

Q1. In Excel, what is used to automate tasks and write macros?

  • 🟢 A. JavaScript
  • 🔵 B. Python
  • 🟠 C. VBA
  • 🔴 D. ExcelScript
Answer

VBA

Visual Basic for Applications (VBA) is used in Excel to automate tasks and write macros.

🔴 Advanced