WorksheetsExcel LESSON 13 _ Formulas _ Quiz
Total questions: 10
Worksheet time: 5mins
Elijah, Aria, and Sophia are having a friendly Excel competition! To start their formulas correctly, what symbol must they use at the very beginning?
#
$
=
&
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?
%
+
×
*
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?
To ensure formulas remain accurate when cell values change
To increase file size
To make spreadsheets look more complex
To slow down calculation speed
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?
Blank cell
Zeros
Pound signs (#######)
Error message
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?
Drag-and-drop method
Point-and-click method
Copy-paste method
Manual entry
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?
Changing cell colors
Formatting text
Copying formulas to adjacent cells
Deleting rows
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?
Click Formula Reveal
Use the View tab
Right-click menu
Press Ctrl+`
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?
%
-
/
÷
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?
The formula breaks
The formula automatically recalculates
You must manually update the formula
Nothing changes
Michael and Aria are having a friendly Excel challenge! They want to know: which symbol should they use to represent exponents in Excel formulas?
**
*
^
×
