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 04:31

Q14 what is most important for you to choose before you build a network? a. private network b. nos c. network media d. network protocol e. directory service

Answers: 1

Answer

Computers and Technology, 24.06.2019 00:50

3. what is the output of the following statements? temporary object1; temporary object2("rectangle", 8.5, 5); temporary object3("circle", 6, 0); temporary object4("cylinder", 6, 3.5); cout < < fixed < < showpoint < < setprecision(2); object1.print(); object2.print(); object3.print(); object4.print(); object1.set("sphere", 4.5, 0); object1.print();

Answers: 1

Answer

Computers and Technology, 24.06.2019 11:00

Each row in a database is a set of unique information called a(n) ? a.) table. b.) record. c.) object. d.) field.

Answers: 2

Answer

Computers and Technology, 24.06.2019 13:50

What does code do? a creates a text box that says "solid black" b creates a black border of any width c creates a black border 1 pixel wide

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...