WorksheetsExcel LESSONS 12 and 13 : QUIZ
Total questions: 22
Worksheet time: 11mins
FIRST name
LAST name
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?
#
$
=
&
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?
%
+
×
*
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?
To ensure formulas remain accurate when cell values change
To increase file size
To make spreadsheets look more complex
To slow down calculation speed
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?
Blank cell
Zeros
Pound signs (#######)
Error message
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?
Drag-and-drop method
Point-and-click method
Copy-paste method
Manual entry
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?
Changing cell colors
Formatting text
Copying formulas to adjacent cells
Deleting rows
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?
Click Formula Reveal
Use the View tab
Right-click menu
Press Ctrl+`
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?
%
-
/
÷
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?
The formula breaks
The formula automatically recalculates
You must manually update the formula
Nothing changes
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?
**
*
^
×
Charlotte wants to print her Excel worksheet. What is the first step she should take to access the Print pane in Excel?
Press Ctrl+P
Right-click the worksheet
Click the Home tab
Select the File tab
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?
Color settings
Page order
Printer selection
Print quality
Aria is preparing a report in Excel and wants to print only specific worksheets from her workbook. What should she do?
Click the Print Entire Workbook option
Hold Ctrl and select multiple worksheets
Use the Page Layout tab
Use the Print Selection option
Jackson is preparing a presentation and wants his slides to be wider rather than taller. What does landscape orientation do to his slides?
Orients the page horizontally
Reduces print quality
Rotates the page vertically
Adds more margins
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?
To select print range
To repeat specific rows or columns on each printed page
To adjust page margins
To change print color
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?
By changing printer settings
Through the File menu
By editing cell contents
Using the Page Break Preview command
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?
Select print range
Change print color
Fit content onto a specific number of pages
Adjust printer resolution
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?
Use the File tab
Right-click the worksheet
Click Print Selection
Select cells, go to Page Layout, choose Print Area
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?
Adds more white space
Changes page orientation
Increases print quality
Condenses the worksheet to fit on a single page
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?
Worksheet gridlines
Space between content and page edge
Page content
Print quality
