Course quiz: Preparing data for analysis with MS Excel :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

When you type an entry into a cell, where does it appear?

❌ In the worksheet grid only
❌ In the Formula tab only
✅ In the worksheet and the Formula tab

Explanation:
Excel shows the typed content inside the cell and in the Formula Bar at the same time.

Question 2

True or False: The maximum number of data rows in an Excel worksheet is one million.

❌ True
✅ False

Explanation:
Excel supports 1,048,576 rows, not exactly one million.

Question 3

A long heading in A1 is hidden because B1 has data. Which option lets text appear on a second line?

✅ Wrap text
❌ Orientation
❌ Merge and center

Explanation:
Wrap Text displays content on multiple lines within the same cell.

Question 4

Which formats can be applied using the Font section? (Select all)

✅ Change the Font choice
✅ Increase the Font size
❌ Wrap text
❌ Merge and center the text
✅ Change the font color

Explanation:
Wrap Text and Merge & Center belong to the Alignment group, not Font.

Question 5

Which mouse shortcut auto-fits column C?

❌ Double-click between B and C
✅ Double-click between C and D
❌ Double-click the letter C

Explanation:
Double-clicking the right boundary of the column auto-sizes it.

Question 6

How do you remove worksheet tab color?

❌ Choose Remove tab color
❌ Choose Clear tab color
✅ Choose No color

Explanation:
Excel uses No color to remove tab color.

Question 7

True or False: You can undo deleting a worksheet if the workbook isn’t saved.

❌ True
✅ False

Explanation:
Deleting a worksheet cannot be undone, even before saving.

Question 8

Which tools show existing defined names? (Select all)

❌ Custom views
✅ Name Manager
❌ Search box
✅ Name Box

Explanation:
The Name Box and Name Manager list defined names.

Question 9

A filter exists on Title = Doctor and City = New York.
You click Clear from the Data tab. What remains?

❌ No filter
❌ City filter
✅ Title filter

Explanation:
Clear removes the filter for the active column only.

Question 10

Cursor is in B2. Row 1 and Column A must stay visible.

✅ Freeze panes
❌ Freeze top row
❌ Freeze first column

Explanation:
Freeze Panes keeps both rows and columns visible.

Question 11

True or False: Operators indicate actions like + − × ÷

✅ True
❌ False

Explanation:
Operators define mathematical operations.

Question 12

Which operator is processed first?
=30+10/2*3

❌ *
❌ +
✅ /

Explanation:
Division and multiplication come before addition, processed left to right.

Question 13

Which symbol is processed first?
=((A3-H4)*G7)/2

❌ Division
❌ Subtraction
✅ Multiplication

Explanation:
Expressions inside parentheses are processed first; then multiplication.

Question 14

Which references remain constant? (Select all)
=((M2-$M$6)+($G$10/H2))

❌ H2
❌ M2
✅ M6
✅ G10

Explanation:
Dollar signs ($) lock references.

Question 15

A2=500, B2=150, C2=10%
Formula: (A2-B2)*C2

❌ 35%
❌ 350%
✅ 3500%

Explanation:
(500−150)=350 → 350×10%=35 → shown as 3500%.

Question 16

Formula: (F10-E10)/E10
E10=125,000, F10=150,000 (Percentage format)

❌ 0.2
✅ 20%
❌ 20

Explanation:
(150k−125k)/125k = 0.2 = 20%

Question 17

Formula: =COUNTBLANK(E7:E9)
E7=150, E8=text, E9=empty

❌ 3
❌ 2
✅ 1

Explanation:
COUNTBLANK counts only empty cells.

Question 18

Formula: =MIN(A2:C2)
A2=50, B2=10, C2=0

❌ 50
✅ 0
❌ 10

Explanation:
MIN returns the smallest value.

Question 19

Initial result = 10
After entering 20 in C3, new AVERAGE?

❌ 10
❌ 15
✅ 12

Explanation:
(10+10+20+0+20)/5 = 12

Question 20

What goes in Number 1 of Function Arguments? (Select all)

❌ Function name
✅ First cell reference
❌ Opening parenthesis
❌ Closing parenthesis
✅ Colon
✅ Last cell reference

Explanation:
Number 1 contains the range definition.

Question 21

Formula: =CONCAT("Dr.",A2,B2)

❌ Dr. Mary Anderson
✅ Dr.MaryAnderson
❌ Mary Anderson

Explanation:
CONCAT does not insert spaces automatically.

Question 22

Formula: =PROPER(C2)
C2 = 2563tt

❌ 2563tt
✅ 2563Tt
❌ 2563TT

Explanation:
PROPER capitalizes the first letter of text.

Question 23

Formula: =MID(D6,15,8)

✅ Freemont
❌ Main
❌ Avenue

Explanation:
MID extracts text starting at position 15 for 8 characters.

Question 24

Extract Brakes System

❌ =RIGHT(E7,13)
❌ =RIGHT(E7,12)
✅ =RIGHT(E7,11)

Explanation:
“Brakes System” contains 11 characters.

Question 25

Always show current date:

✅ =TODAY()
❌ =TODAY(E4)
❌ =TODAY(DD/MM/YYYY)

Explanation:
TODAY has no arguments.

Question 26

45106 appears instead of a date — fix by formatting to Date?

✅ True
❌ False

Explanation:
45106 is a date serial number.

Question 27

=NETWORKDAYS(A2,B2)
06/15/2023 → 07/20/2023

❌ 26
✅ 23
❌ 35

Explanation:
NETWORKDAYS counts weekdays only.

Question 28

Bonus only if all three months exceed target.

❌ IF + OR
❌ IF + IF
✅ IF + AND

Explanation:
All conditions must be TRUE → AND.

Question 29

Sales = $135,000
Formula outcome?

❌ Send congratulation message
❌ Send individual emails
✅ Schedule a meeting

Explanation:
135,000 < 150,000 → meeting required.

Question 30

In SUMIF(A2:A50,"Chicago",C2:C50)
What is the first argument?

❌ Criteria
✅ Criteria range
❌ Sum range

Explanation:
The first argument defines where Excel looks for the condition.

🧾 Summary Table