Microsoft Excel Basics - Fill-in-the-Blanks Practice for Beginners

Test your knowledge of Microsoft Excel basics with these fill-in-the-blank exercises. Learn key concepts like workbooks, worksheets, rows, columns, active cells, and Excel shortcuts. Perfect for beginners to assess and strengthen their Excel skills.

🔍 Fill in the Blanks

🟢 Beginner

1. In Excel, a ________ is a file that contains one or more worksheets.
Answer

workbook

A workbook is an Excel file that can contain multiple worksheets, allowing users to organize various kinds of related information.

---

2. Each ________ in Excel is organized into rows and columns and is used to store and work with data.
Answer

worksheet

A worksheet is the primary document in Excel where data is entered and manipulated, consisting of a grid of rows and columns.

---

3. In Excel, the intersection of a row and a column is called a ________.
Answer

cell

A cell is the basic unit of a worksheet where data is entered, formed by the intersection of a row and a column.

---

4. Each column in an Excel worksheet is labeled with a ________, while each row is labeled with a number.
Answer

letter

Columns are identified by letters (A, B, C, etc.), and rows are identified by numbers (1, 2, 3, etc.) in Excel.

---

5. To perform calculations in Excel, you start by typing an ________ sign in a cell.
Answer

equal

Formulas in Excel begin with an equal sign (=), indicating that the cell contains a formula.

---

6. Built-in formulas in Excel that perform specific calculations are called ________.
Answer

functions

Functions are predefined formulas in Excel that perform specific calculations using particular values, called arguments, in a particular order.

---

7. In Excel, the cell reference 'B3' refers to the cell located at column ________ and row ________.
Answer

B, 3

Cell references in Excel combine the column letter and row number to identify a specific cell, such as B3.

---

8. Excel Online can be accessed through a web browser and is part of the ________ suite.
Answer

Microsoft 365

Excel Online is the web-based version of Excel, accessible through browsers and integrated into the Microsoft 365 suite.

---

9. A workbook is a collection of __________.
Answer

worksheets

An Excel workbook contains multiple worksheets where data is stored and organized.

---

10. A worksheet consists of __________ and __________.
Answer

rows, columns

Worksheets are made up of rows (horizontal) and columns (vertical) forming a grid.

---

11. The __________ is the intersection of a column and a row.
Answer

cell

A cell is the box formed at the intersection of a row and a column.

---

12. The __________ cell is the cell that is currently selected.
Answer

active

The active cell is the one currently selected and ready for data entry.

---

13. Excel allows you to perform __________, create __________, and analyze __________.
Answer

calculations, charts, data

Excel is used for calculations, visual data representation using charts, and data analysis.

---

14. The shortcut key to enter the current date in Excel is __________.
Answer

Ctrl + ;

Pressing Ctrl + ; inserts the current date into the selected cell.

---

15. The shortcut key to enter the current time in Excel is __________.
Answer

Ctrl + Shift + ;

Pressing Ctrl + Shift + ; inserts the current time into the selected cell.

---

16. A cell reference combines the __________ letter and the __________ number.
Answer

column, row

A cell is referenced by its column letter and row number (e.g., A1).

---

17. The __________ bar displays the content of the active cell.
Answer

formula

The formula bar shows the formula or value in the currently selected cell.

---

🟡 Intermediate

1. The programming language used in Excel for automating tasks is called ________.
Answer

VBA

Visual Basic for Applications (VBA) is the programming language used in Excel to create macros and automate tasks.

---

🔴 Advanced

📚 Related Resources

• Microsoft Excel Basics

🧠 Practice & Progress

• ✅ True or False
• ✍️ Fill in the Blanks
• 📝 Multiple-Choice Questions (MCQs)
• 🔍 Find and Fix Mistakes
🌐 ✅ Online Quizzes - Test your Knowledge 📊
• 💻 Online Quiz
• 🏋️‍♂️ Exercises
• 🧪 Mini Projects
• 🔄 Review Questions

Explore More Topics

Microsoft Excel Fundamentals

Microsoft Excel More ...