Spreadsheets Basic
What program do we use to organize data in rows and columns?
What Is Microsoft Excel (or Google Sheets)
What symbol must every formula start with?
What is =
What does “currency” mean?
What Is Money used to buy and sell things.
What does “quantity” mean?
The number of items.
What does “average” mean?
The middle value — total divided by how many numbers.
What do we call the boxes where rows and columns meet?
What Is Cells
Write the formula to multiply 3 × 4.
What Is =3*4
How do you format numbers to show dollars in Excel?
What Is Apply the Currency or $ format.
If you have 5 notebooks at $2 each, what’s the total cost?
$10
What formula finds an average in Excel?
=AVERAGE()
What are the vertical sections in a spreadsheet called?
What Is Columns
What formula adds numbers from C2 to C5?
=SUM(C2:C5)
If 1 pizza costs $5 and you buy 4, what’s the total?
$20
Why do we multiply quantity by cost?
To find the total cost.
Find the average of 10, 20, and 30.
20
What are the horizontal sections called?
What Is Rows
What formula multiplies Quantity in C2 by Cost in D2?
=C2*D2
Why do we use currency formatting?
It shows money values clearly and helps avoid confusion.
Give two examples of items you could track in a spreadsheet.
Example: Snacks, pencils, drinks, shirts, etc.
If the total cost is $60 for 6 items, what is the average cost?
$10
What is the name of the bar where you type formulas?
What Is Formula Bar
What is the difference between a formula and a function?
What Is A formula is written by the user; a function is a built-in command (like SUM or AVERAGE).
Create a word problem using money and write the formula to solve it
Example: “If 3 drinks cost $2 each, total = =3*2
How could tracking items in a spreadsheet help a store?
Helps organize inventory and see costs easily.
Why might a business want to know average cost?
To plan budgets and compare prices.