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
Another question on Computers and Technology
Computers and Technology, 24.06.2019 22:00
Is the process of organizing data to reduce redundancy. a. normalization b. primary keying c. specifying relationships d. duplication
Answers: 1
Computers and Technology, 25.06.2019 02:30
What does a trademark indicate about a product? a trademark is a sign, symbol, or short phrase that indicates the of a product or service. type the correct answer in the box
Answers: 1
Computers and Technology, 25.06.2019 08:00
Most computers today support the standard, in which the computer automatically configures new devices as soon as they are installed and the pc is powered up.
Answers: 1
Computers and Technology, 25.06.2019 08:50
The purpose of this problem is to write some small functions and practice passing things around amoung functions.1) the main function shall ask the user to enter three numbers and read the three numbers.2) write a function named findsum that takes three numbers as arguments and returns their sum. the main function shall call this function.3) write a function named findaverage that takes the sum and the number of numbers and returns the average. the main function shall call this function.4) write a function named findsmallest that takes the three numbers and returns the smallest value. the main function shall call this function.5) the main function shall print the results in the following format, with two decimal positions and the decimal points aligned:
Answers: 3
You know the right answer?
The spreadsheet below shows how much money each store raised for charity during the months of Januar...
Questions
Arts, 15.02.2020 01:52
Computers and Technology, 15.02.2020 01:52
Health, 15.02.2020 01:53
Social Studies, 15.02.2020 01:53
