Practice creating spreadsheet formulas that model real situations, including budgets, grades, sales, unit conversions, and simple predictions.
Read each problem carefully. Write the spreadsheet formula or explanation requested. Use standard spreadsheet notation such as =A1+B1, =SUM(A1:A5), and =IF(condition,value_if_true,value_if_false).
Using cell references, functions, and formulas to solve realistic problems
Computer Science - Grade 9-12
- 1
A student is tracking weekly study time. Cells B2 through B8 contain the number of hours studied each day from Monday through Sunday. Write a formula for cell B9 that calculates the total hours studied for the week.
- 2
A class gradebook has homework scores in cells C2:C11. Write a formula that calculates the average homework score.
- 3
A store sells T-shirts for $18 each. Cell B2 contains the number of shirts sold. Write a formula for cell C2 that calculates total revenue from T-shirt sales.
- 4
A spreadsheet tracks monthly electricity use. Cell B2 contains kilowatt-hours used, and cell C2 contains the cost per kilowatt-hour. Write a formula for D2 that calculates the total electricity cost.
- 5
A school fundraiser keeps item prices in column B and quantities sold in column C. Row 2 is for notebooks. Write a formula for D2 that calculates the money earned from notebooks.
- 6
A budget spreadsheet lists income in B2 and expenses in B3. Write a formula for B4 that calculates the remaining balance.
- 7
A cell phone plan costs $35 per month plus $0.10 per text message. Cell B2 contains the number of text messages used. Write a formula that calculates the total monthly cost.
- 8
A temperature spreadsheet has Celsius values in column A. Write a formula for B2 that converts the Celsius value in A2 to Fahrenheit using the formula F = C*9/5 + 32.
- 9
A teacher wants column D to show Pass if a student's score in C2 is at least 70 and Retake if it is below 70. Write the formula for D2.
- 10
A sports tracker records a runner's distance in miles in B2 and time in hours in C2. Write a formula for D2 that calculates average speed in miles per hour.
- 11
A spreadsheet compares prices at two stores. Store A price is in B2 and Store B price is in C2. Write a formula that displays the lower price.
- 12
A student loan calculator has the loan amount in B2 and the annual interest rate as a decimal in B3. Write a formula that estimates one year of simple interest.
- 13
A spreadsheet models the cost of ordering custom stickers. There is a $12 setup fee and each sticker costs $0.45. Cell B2 contains the number of stickers ordered. Write a formula for C2 that calculates the total cost.
- 14
A science club tracks plant growth. Cell B2 contains the plant height at the start of the week, and C2 contains the plant height at the end of the week. Write a formula for D2 that calculates the growth during the week.
- 15
A cafeteria inventory sheet has the number of sandwiches sold each day in cells B2:F2. Write a formula that calculates the greatest number of sandwiches sold on any one day.