Computers and Technology, 18.10.2021 01:00 boxergirl9875

The spreadsheet below shows how much money each store raised for charity during the months of January, February, and March. A1: Blank. B1: Store 1. C1: Store 2. D1: Store 3. A2: January. B2: 170 dollars. C2: 100 dollars. D2: 150 dollars. A 3: February. B3: 235 dollars. B4: 80 dollars. D3: 240 dollars. A4: March. B4: 300 dollars. C4: 75 dollars. D4: 450 dollars.

Using this information, answer the following questions.

To obtain the total amount raised by Store 1, which range of cells would you use?
✔ B2:B4

Which function will yield the total amount raised by each store from January through March?
✔ SUM

Suppose one hundred stores participated in the fund-raiser for one year. What would be the most efficient way to calculate totals and store averages by month?
Using the sum and average functions on the range of cells

Manually adding and averaging values

Using formulas that reference values instead of cell addresses ( theses are the answers)

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 20:40

Instruction active describing list features which statements accurately describe the features of word that are used to create lists? check all that apply. the tab key can be used to create a sublist. the enter key can be used to add an item to a list. the numbering feature allows for the use of letters in a list. the numbering feature can change the numbers to bullets in a list. the multilevel list feature provides options for different levels in a list.

Answers: 2

Answer

Computers and Technology, 23.06.2019 22:50

An environmental protection agency study of 12 automobiles revealed a correlation of 0.47 between engine size and emissions. at 0.01 significance level, can we conclude that there is a positive association between the variables? what is the p value? interpret.

Answers: 2

Answer

Computers and Technology, 24.06.2019 08:00

Java the manager of a football stadium wants you to write a program that calculates the total ticket sales after each game

Answers: 1

Answer

Computers and Technology, 24.06.2019 15:00

Universal windows platform is designed for which windows 10 version?

Answers: 1

Answer

You know the right answer?

The spreadsheet below shows how much money each store raised for charity during the months of Januar...