1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
ki77a [65]
2 years ago
7

Insert in the Current Values section at the top of the worksheet summary functions that use the range I9:I54. In cell I2, calcul

ate the total of all the Current Values. In cell I3, calculate the average current value. in cell I4, calculate the lowest current value. In cell I5, calculate the highest current value
Computers and Technology
1 answer:
Rainbow [258]2 years ago
3 0

Answer:

Cell I2: =SUM(I9:I54)

Cell I3: =AVERAGE(I9:I54)

Cell I4: =MIN(I9:I54)

Cell I5: =MAX(I9:I54)

Explanation:

I wasnt able to find the worksheet referenced, however it is not needed to answer correctly.

The question states there are several values in the cell range I9:I54, and we need to perform different operations:

  • <u>In cell I2, calculate the total of all the Current Values</u>

To obtain the TOTAL calculation, we use the SUM function for all the range of values

=SUM(I9:I54)

  • <u>In cell I3, calculate the average current value</u>

Average is calculated with the function named the same

=AVERAGE(I9:I54)

  • <u> </u><u>In cell I4, calculate the lowest current value</u>

The lowest value of all the range is found with the MIN function

=MIN(I9:I54)

  • <u>In cell I5, calculate the highest current value</u>

The highest value of all the range is found with the MAX function

=MAX(I9:I54)

You might be interested in
To change lowercase letters to uppercase letters in a smaller font size, which of the following should be done?
sergeinik [125]

Explanation:

Format the text in Small caps. Manually replace the lowercase letters with uppercase letters.

7 0
3 years ago
What is Roko's Basilisk?
serious [3.7K]

Answer:

Roko’s basilisk is a thought experiment proposed in 2010 by the user Roko on the Less Wrong community blog. Roko used ideas in decision theory to argue that a sufficiently powerful AI agent would have an incentive to torture anyone who imagined the agent but didn't work to bring the agent into existence.

7 0
3 years ago
Password combined with pin used as an authentication requirement is an example of:
Bingel [31]
...something that the user knows.
4 0
3 years ago
IT ethics are rules, policies, or principles that guide the behavior of IT professionals.
Vadim26 [7]

Answer: true

Explanation: true

6 0
3 years ago
Why would a store owner want to calculate a mean
chubhunter [2.5K]

Answer:

a store owner would calculate a mean to see the how much a person spends

Explanation:

4 0
3 years ago
Other questions:
  • Which of the following can you use to attach external hardware devices to a computer?
    11·2 answers
  • Write an assembly language program with a loop and indexed addressing that calculates the sum of all the gaps between successive
    11·1 answer
  • Assume that you have an array of integers named arr. Which of these code segments print the same results?
    15·1 answer
  • Evaluating how current, credible, and unbiased a source is ensures:
    7·1 answer
  • Which processor family is most likely found on recent gaming laptops (Gaming laptops require a lot of computational power)?
    11·1 answer
  • HURRY!!!!!!!!!!!!!
    15·1 answer
  • Question # 7
    11·1 answer
  • The _____ method randomly rearranges the items in the list provided in the parentheses.
    5·2 answers
  • 8.3 code practice edhesive PLEASE HELP AND HURRY
    9·1 answer
  • All Office programs have similar commands on the tab for changing the document view a. File b. View c. Locate d. display ​
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!