Question

In her budgeting spreadsheet, Erin needs to subtract her expenses from her income. The simplest way to do this would be to use a _____.

(1 point)
Responses

formula

formula

digital form

digital form

pie chart

pie chart

infographic

infographic

Darryl keeps track of his income from his snow shoveling jobs in a spreadsheet. If he wants to add up his income at the end of the winter, what function would he use?

(1 point)
Responses

Sum()

Sum()

Count()

Count()

Max()

Max()

Time()

Time()

What spreadsheet tool can ONLY be used on a computer with macOS?

(1 point)
Responses

Apple Pages

Apple Pages

Google Sheets

Google Sheets

Apple Numbers

Apple Numbers

Microsoft Excel

Microsoft Excel

Jayson is using Microsoft Excel for budgeting as he saves up money to attend a summer baseball camp. How is he MOST likely to use the tool for this purpose?

(1 point)
Responses

create a presentation as part of his camp application

create a presentation as part of his camp application

track his income and expenses

track his income and expenses

sort a list of his baseball teammates by name and position

sort a list of his baseball teammates by name and position

create a bar graph of his baseball stats

create a bar graph of his baseball stats

Leticia signed up for a Google account. It gives her free access to Google Docs, Google Drive, and Google Sheets as part of _____.

(1 point)
Responses

HTML

HTML

Keynote

Keynote

Workspace

Workspace

Canva

Ruth’s class is having a fundraising bake sale, and they want to be able to track donations over time. They also want to organize information and to calculate total donations when the bake sale is complete. What is the BEST application for the class to use?

(1 point)
Responses

spreadsheet

spreadsheet

presentation

presentation

word processing

word processing

infographic

infographic

Coach Duclos is doing equipment inventory at the end of the football season using a spreadsheet. If he wants to find the total number of rows with a number in the cells, what function should he use?

(1 point)
Responses

Average()

Average()

Count()

Count()

Max()

Max()

Time()

Time()

Hayley is taking part in a reading competition at her local library. She has read for 22 hours and 15 minutes this quarter. When she enters her results in the shared Google Sheets document, what function should she use to convert her results to the format 22:15:00?

(1 point)
Responses

Time()

Time()

Sum()

Sum()

Max()

Max()

Count()

Answer 1

1) formula

2) Sum()

3) Apple Numbers

4) track his income and expenses

5) Workspace

6) spreadsheet

7) Count()

8) Time()