Learn with Yasir

Share Your Feedback

Microsoft Excel MCQs - Test Your Knowledge of Excel Basics


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



๐Ÿง  Practice & Progress

Explore More Topics

Microsoft Excel Fundamentals

Microsoft Excel More ...