Microsoft Excel Basics Quiz – True or False Questions for Beginners

Test your understanding of JavaScript fundamentals with this beginner-friendly true or false quiz. Learn key concepts like variables, functions, DOM manipulation, and script placement in a fun and simple format.

🔍 True or False

🟢 Beginner

1. A workbook is a collection of worksheets.
Answer

✅ True – In Excel, a workbook is a file that contains one or more worksheets, which are used to organize and analyze data.

---

2. Rows are numbered from 1 to 1,048,576.
Answer

✅ True – Excel supports up to 1,048,576 rows in a single worksheet, providing ample space for data entry and analysis.

---

3. A worksheet is the intersection of a row and a column.
Answer

❌ False – A worksheet is a single page or sheet within a workbook. The intersection of a row and a column is called a cell.

---

4. The active cell is the cell that is currently selected.
Answer

✅ True – The active cell in Excel is the one currently highlighted and ready to receive data input.

---

5. Excel is a powerful tool for data analysis.
Answer

✅ True – Excel provides a wide range of tools and functions for analyzing data, including charts, formulas, pivot tables, and more.

---

6. Excel can retrieve data from external sources and use it in worksheets.
Answer

✅ True – Excel supports importing data from various external sources, allowing users to integrate and analyze data within worksheets.

---

7. Each worksheet in Excel can contain up to 16,384 columns.
Answer

✅ True – Excel worksheets are structured with columns labeled from A to XFD, totaling 16,384 columns.

---

8. A cell reference in Excel combines a column letter and a row number, such as B3.
Answer

✅ True – Cell references identify specific cells by combining the column letter and row number, facilitating data manipulation and formula creation.

---

9. In Excel, formulas must begin with a dollar sign ($).
Answer

❌ False – Formulas in Excel start with an equal sign (=). The dollar sign is used to denote absolute references within formulas.

---

10. Excel Online allows real-time collaboration with others through a web browser.
Answer

✅ True – Excel Online enables users to collaborate in real-time via web browsers, enhancing teamwork and productivity.

---

11. Entering a number with a leading apostrophe in Excel treats it as text.
Answer

✅ True – Prefixing a number with an apostrophe in Excel formats it as text, preventing it from being used in calculations.

---

12. Excel is exclusively available as a desktop application for Windows.
Answer

❌ False – Excel is accessible on multiple platforms, including desktop applications for Windows and Mac, mobile apps, and online through web browsers.

---

13. To rename a worksheet in Excel, you can double-click on its tab.
Answer

✅ True – Double-clicking on a worksheet tab allows users to rename the sheet directly.

---

14. In Excel, the formula bar is used to display and edit the contents of the active cell.
Answer

✅ True – The formula bar in Excel shows the content of the active cell and allows users to edit formulas and data entries.

---

15. Excel's fill handle can be used to quickly copy cell contents or continue a sequence.
Answer

✅ True – The fill handle in Excel enables users to drag and fill adjacent cells with data, formulas, or sequences efficiently.

---

🟡 Intermediate

🔴 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 ...