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

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 17:30, Samsonb

Working on this program in python 3.7: a year in the modern gregorian calendar consists of 365 days. in reality, the earth takes longer to rotate around the sun. to account for the difference in time, every 4 years, a leap year takes place. a leap year is when a year has 366 days: an extra day, february 29th. the requirements for a given year to be a leap year are: 1) the year must be divisible by 42) if the year is a century year (1700, 1800, the year must be evenly divisible by 400some example leap years are 1600, 1712, and 2016.write a program that takes in a year and determines whether that year is a leap year. ex: if the input is 1712, the output is: 1712 is a leap year. ex: if the input is 1913, the output is: 1913 is not a leap year. your program must define and call the function isleapyear(useryear). the function should return true if the input year is a leap year and false otherwise.

Answers: 1

continue

Computers and Technology, 23.06.2019 12:20, jshhs

When guido van rossum created python, he wanted to make a language that was more than other programming languages. a. code-based b. human-readable c. complex d. functional

Answers: 1

continue

Computers and Technology, 24.06.2019 10:10, nakeytrag

Which view in a presentation program displays a split window showing the slide in the upper half and a blank space in the lower half?

Answers: 1

continue

Computers and Technology, 24.06.2019 11:00, airbenderjermai

Need fast im timed in a paragraph of 125 words, explain at least three ways that engineers explore possible solutions in their projects.

Answers: 2

continue

Do you know the correct answer?

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