Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel LESSONS 12 and 13 : QUIZ

Total questions: 22

Worksheet time: 11mins

Name
Class
Date
1.

FIRST name

4 lines
2.

LAST name

4 lines
3.

Mia is creating a budget spreadsheet in Excel. She wants to add a formula to calculate the total expenses. What symbol must Mia begin her Excel formula with?

a)

#

b)

$

c)

=

d)

&

4.

Emma is creating a budget spreadsheet in Excel and wants to calculate the total cost by multiplying the price of an item by the quantity purchased. Which mathematical operator should Emma use to represent multiplication in Excel?

a)

%

b)

+

c)

×

d)

*

5.

Emma is creating a budget spreadsheet and wants her calculations to update automatically if she changes any expenses. What is the primary advantage of using cell references in her 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

6.

Abigail is working on a spreadsheet and enters a formula in a cell. What will appear if the formula result is too large to display in the cell?

a)

Blank cell

b)

Zeros

c)

Pound signs (#######)

d)

Error message

7.

Jackson is working on a spreadsheet and wants to create formulas easily by selecting cells with his mouse instead of typing their addresses. Which method should Jackson use?

a)

Drag-and-drop method

b)

Point-and-click method

c)

Copy-paste method

d)

Manual entry

8.

Liam is working on a budget spreadsheet in Excel. He wants to quickly apply the same formula to calculate totals across several rows. What tool should Liam use to copy formulas to adjacent cells?

a)

Changing cell colors

b)

Formatting text

c)

Copying formulas to adjacent cells

d)

Deleting rows

9.

Sophia is working on a spreadsheet and wants to quickly check all the formulas she has used. How can she view all formulas in the spreadsheet?

a)

Click Formula Reveal

b)

Use the View tab

c)

Right-click menu

d)

Press Ctrl+`

10.

Olivia is preparing a budget spreadsheet in Excel and needs to divide the total expenses by the number of months. Which mathematical operator should Olivia use to represent division in Excel?

a)

%

b)

-

c)

/

d)

÷

11.

Noah is working on a budget spreadsheet. If Noah changes the value in a cell that is referenced by a formula, what happens to the formula?

a)

The formula breaks

b)

The formula automatically recalculates

c)

You must manually update the formula

d)

Nothing changes

12.

Ava is creating a spreadsheet to calculate the growth of her savings over time. She wants to use an exponent in her Excel formula. What symbol should Ava use to represent exponents in Excel formulas?

a)

**

b)

*

c)

^

d)

×

13.

Charlotte wants to print her Excel worksheet. What is the first step she should take to access the Print pane in Excel?

a)

Press Ctrl+P

b)

Right-click the worksheet

c)

Click the Home tab

d)

Select the File tab

14.

James needs to print several copies of a report for a meeting. He notices the 'Collated' option in the print settings. What does the 'Collated' option control when printing multiple copies?

a)

Color settings

b)

Page order

c)

Printer selection

d)

Print quality

15.

Aria is preparing a report in Excel and wants to print only specific worksheets from her workbook. What should she do?

a)

Click the Print Entire Workbook option

b)

Hold Ctrl and select multiple worksheets

c)

Use the Page Layout tab

d)

Use the Print Selection option

16.

Jackson is preparing a presentation and wants his slides to be wider rather than taller. What does landscape orientation do to his slides?

a)

Orients the page horizontally

b)

Reduces print quality

c)

Rotates the page vertically

d)

Adds more margins

17.

Mason is preparing a large spreadsheet for printing. He wants to ensure that the header row appears at the top of every printed page for easy reference. What feature should Mason use to achieve this?

a)

To select print range

b)

To repeat specific rows or columns on each printed page

c)

To adjust page margins

d)

To change print color

18.

Evelyn is preparing a financial report in Excel and needs to ensure that the pages print correctly without splitting important tables. How can she adjust page breaks in Excel?

a)

By changing printer settings

b)

Through the File menu

c)

By editing cell contents

d)

Using the Page Break Preview command

19.

Hannah is preparing a report to print for her class. She notices the 'Scaling' option in the print settings. What does the 'Scaling' option help Hannah do when printing?

a)

Select print range

b)

Change print color

c)

Fit content onto a specific number of pages

d)

Adjust printer resolution

20.

Anika needs to prepare a report in Excel and wants to ensure only a specific section of her worksheet prints out. How can she set a specific print area in advance?

a)

Use the File tab

b)

Right-click the worksheet

c)

Click Print Selection

d)

Select cells, go to Page Layout, choose Print Area

21.

Aiden is preparing a report in Excel and wants to print it. He selects the 'Fit All Columns on One Page' scaling option before printing. What will happen as a result?

a)

Adds more white space

b)

Changes page orientation

c)

Increases print quality

d)

Condenses the worksheet to fit on a single page

22.

Jackson is designing a flyer to print for an event. He needs to ensure there is enough space between the content and the edge of the page so nothing important gets cut off during printing. What does this space represent in printing?

a)

Worksheet gridlines

b)

Space between content and page edge

c)

Page content

d)

Print quality