1. Question 1

How can you zoom to a specific area of data in Excel?

• ✅ Use the Zoom to Selection button

• ❌ Use the Freeze Frames option

• ❌ Use the Zoom button

• ❌ Use the 100% button

Explanation:
Zoom to Selection adjusts the zoom so the selected cells fill the screen.

---

2. Question 2

What do you use the AutoFill feature for?

• ❌ Move or copy data between spreadsheets

• ❌ Drag selected data to another place

• ✅ Automatically fill cells with data in a sequential series or pattern

• ❌ Paste data with same column width

Explanation:
AutoFill can produce sequences like 1, 2, 3, dates, days, formulas, etc.

---

3. Question 3

What character starts every Excel formula?

• ❌ Division sign /

• ❌ Plus sign +

• ❌ Percentage %

• ✅ Equal sign =

Explanation:
Every Excel formula must start with “=”.

---

4. Question 4

One of the functions in the AutoSum dropdown list is:

• ❌ Number

• ✅ Count Numbers

• ❌ Accounting

• ❌ General

Explanation:
AutoSum’s dropdown includes Sum, Average, Count Numbers, Max, Min.

---

5. Question 5

A function category under the Formulas tab → Function Library group:

• ✅ Lookup & Reference

• ❌ Medical

• ❌ Analytical

• ❌ Functional

Explanation:
Excel includes categories like Math & Trig, Logical, Lookup & Reference, etc.

---

6. Question 6

How do you make a cell reference absolute?

• ❌ Put a plus sign

• ❌ Put a % sign

• ❌ Put an asterisk

• ✅ Put a dollar sign ($) in front of the column and/or row identifiers

Explanation:
Examples:
$A$1 → completely absolute
A$1 or $A1 → partially absolute

---

7. Question 7

What does it mean when multiple ####### appear in a cell?

• ❌ Formula is missing a cell reference

• ✅ Column isn’t wide enough OR cell contains negative date/time

• ❌ Formula contains multiple errors

• ❌ Formula contains unrecognized text

Explanation:
Excel shows ######## when the cell can’t display the value due to width or invalid date/time.

---

🧾 Summary Table

---