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]
3 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]3 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
What are the disadvantages of using pointers?
garik1379 [7]

Explanation:

The pointer is the variable that will store the address of the other variable of the same datatype.

Following are the disadvantages of using a pointer.

1. Pointer sometimes causes a segmentation fault in the program.

2. Sometimes pointer leads to a memory leak.

3. A pointer variable is slower than normal variable.

4. Sometimes the program is crash if we using pointer because sufficient memory is not allocated during runtime.

5. If we using pointer it is difficult to find the error in the program.

5 0
3 years ago
In which type of referencing do you get a warning message? Explain why.​
Art [367]

Answer:

These are the problems that are not severe enough to prevent processing. They mainly complain about the previous version of your document. In the case of command invalid, the latex gives a warning and henceforth it needs to be fixed.

Explanation:

There are some bugs in which they are not that severe that make the system not process.. but they are still mistakes in which might affect how the program run those parts.. like in JavaScript in the program i use, the minor bugs are like symbolized as yellow triangle and they are normally like signalizing a grammar error in the code and the app still runs but just that part of the code is invalid or reads wrong.. while big errors like codes that dont make sense, those make a red squareish that as soon as you try to run the program the debug console states in all red "Line 50(or whatever line) SyntaxError" or other things

5 0
3 years ago
Given an existing class, BankAccount, containing: a constructor accepting a String corresponding to the name of the account hold
Dimas [21]

Answer:

Refer below.

Explanation:

Refer to the picture for the brief explanation of the code.

4 0
3 years ago
Suppose you create a class Square to be a subclass of GeometricObject. Analyze the following code:
Lemur [1.5K]

Answer:

B. The program has a compile error because you attempted to invoke the GeometricObject class's constructor illegally.

Explanation:

To call a superclass constructor, the user must use super(). This is necessary unless default constructors are used. Also, it is vital to make sure if their are appropriate argument to be used while invoking the superclass constructor.

3 0
4 years ago
Method does not override or implement a method from a supertype
muminat
Where is the question? if there was a question i could potentially help you.
4 0
3 years ago
Other questions:
  • Databases that carry their data in the form of tables and represent relationships using foreign keys are called _____ databases.
    9·1 answer
  • Which of the following methods are acceptable for opening the Word application?
    8·1 answer
  • What is the definition of framerate?
    7·1 answer
  • Can someone help me with these questions on linear dimensions pls
    11·2 answers
  • Which unique address is a 128-bit address written in hexadecimal?
    13·1 answer
  • Marco is ready to create his first slide. He wants to put the title of the
    11·1 answer
  • Which of the following is true about database queries?
    11·1 answer
  • A large lens can be very heavy and can only be supported at the_______.
    13·1 answer
  • Claire writes a letter to her grandmother, in which she describes an amusement park she visited last week. She adds pictures of
    13·1 answer
  • Assume three jobs arrive at approximately the same time (arrival time are all 0), but Job A arrives slightly before Job B, and J
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!