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?

  1. Workbook
  2. Document
  3. Spreadsheet
  4. 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?

  1. Box
  2. Cell
  3. Grid
  4. 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?

  1. +
  2. @
  3. =
Answer

=

All formulas in Excel begin with an equal sign.


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

  1. Excel Lite
  2. Excel Anywhere
  3. Excel Online
  4. 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?

  1. A collection of workbooks
  2. A single spreadsheet
  3. The intersection of a row and column
  4. 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?

  1. The name of the workbook
  2. The name of the worksheet
  3. The letter of the column and the number of the row
  4. 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?

  1. workbook
  2. worksheet
  3. row
  4. 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?

  1. workbook
  2. worksheet
  3. cell address
  4. row
Answer

cell address

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


Q9. What are rows and columns?

  1. Both rows and columns are vertical divisions of a worksheet.
  2. Both rows and columns are horizontal divisions of a worksheet.
  3. Rows are vertical divisions of a worksheet, and columns are horizontal divisions of a worksheet.
  4. 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?

  1. JavaScript
  2. Python
  3. VBA
  4. 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 ...