wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel LESSON 13 _ Formulas _ Quiz

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

Elijah, Aria, and Sophia are having a friendly Excel competition! To start their formulas correctly, what symbol must they use at the very beginning?

a)

#

b)

$

c)

=

d)

&

2.

Grace and Noah are having a friendly Excel challenge! They want to multiply numbers in their spreadsheet. Which mathematical operator should they use for multiplication in Excel?

a)

%

b)

+

c)

×

d)

*

3.

Anika and Luna are preparing a budget spreadsheet for their team. They want to make sure that if any expense amount changes, the totals and calculations update automatically. What is the primary advantage of using cell references in their formulas?

a)

To ensure formulas remain accurate when cell values change

b)

To increase file size

c)

To make spreadsheets look more complex

d)

To slow down calculation speed

4.

Harper and Jackson are working on a spreadsheet, and suddenly their formula result is too huge to fit in the cell! What mysterious thing will appear in the cell when this happens?

a)

Blank cell

b)

Zeros

c)

Pound signs (#######)

d)

Error message

5.

Emma and Ava are preparing a budget report in a spreadsheet for their school project. They want to quickly create formulas by selecting cells with their mouse, rather than typing out each cell address. Which method allows them to do this?

a)

Drag-and-drop method

b)

Point-and-click method

c)

Copy-paste method

d)

Manual entry

6.

Grace and Benjamin are preparing a budget spreadsheet in Excel. They want to quickly apply the same formula to a series of cells in a column. What cool trick can they use the fill handle for?

a)

Changing cell colors

b)

Formatting text

c)

Copying formulas to adjacent cells

d)

Deleting rows

7.

Mason and Maya are working late in the office, trying to finish a financial report in their spreadsheet. They need to quickly check all the formulas they've used. Which magical shortcut will instantly reveal every formula at once?

a)

Click Formula Reveal

b)

Use the View tab

c)

Right-click menu

d)

Press Ctrl+`

8.

Emma and Rohan are at a grocery store using Excel to split the total bill equally among their friends. Can you help them figure out which mathematical operator represents division in Excel?

a)

%

b)

-

c)

/

d)

÷

9.

Arjun and Kai are collaborating on a budget spreadsheet for their team. Arjun updates the amount in a cell that Kai's formula uses to calculate total expenses. What happens next?

a)

The formula breaks

b)

The formula automatically recalculates

c)

You must manually update the formula

d)

Nothing changes

10.

Michael and Aria are having a friendly Excel challenge! They want to know: which symbol should they use to represent exponents in Excel formulas?

a)

**

b)

*

c)

^

d)

×