Graded Quiz :Excel Basics for Data Analysis (IBM Business Analyst Professional Certificate) Answers 2025

Question 1

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

❌ Use the Freeze Frames option
❌ Use the Zoom button
❌ Use the 100% button
✅ Use the Zoom to Selection button

Explanation:
Zoom to Selection zooms Excel to fit the selected cells exactly on the screen.

Question 2

What do you use the AutoFill feature for?

✅ Automatically fill cells with data in a sequential series or pattern
❌ Move or copy data between spreadsheets
❌ Drag selected data to another place
❌ Paste data with same column width

Explanation:
AutoFill quickly fills numbers, dates, formulas, or patterns (e.g., 1, 2, 3…).

Question 3

What character do you type first when writing a formula?

❌ Percentage sign %
❌ Plus sign +
❌ Division sign /
✅ Equal sign =

Explanation:
All Excel formulas must begin with =.

Question 4

Which function is found in the AutoSum drop-down list?

✅ Count Numbers
❌ Number
❌ General
❌ Accounting

Explanation:
AutoSum includes SUM, AVERAGE, COUNT NUMBERS, MAX, and MIN.

Question 5

Which is a function category in the Formulas tab (Function Library)?

❌ Medical
❌ Functional
✅ Lookup & Reference
❌ Analytical

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

Question 6

How do you make a cell reference absolute in a formula?

❌ Use *
❌ Use %
✅ Use $ before column and/or row identifiers
❌ Use +

Explanation:
An absolute reference looks like $A$1 and does not change when copied.

Question 7

What do multiple hash symbols (#####) in a cell mean?

✅ Column isn’t wide enough or it contains negative date/time values
❌ Formula has unrecognized text
❌ Formula has multiple errors
❌ Formula is missing a cell reference

Explanation:
Most commonly, ##### means the column width is too small to display the value.

🧾 Summary Table