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
Mariana [72]
3 years ago
11

David uses Office Excel 2013 to calculate his average marks. He enters a formula in cell B5 to calculate the average based on th

e values in cells B2 to B4, as displayed in the exhibit. David realizes that he entered his Science score as 67 instead of 69. What will cell B5 display if he changes the value in cell B4 to 69?
Computers and Technology
1 answer:
bogdanovich [222]3 years ago
8 0

Answer:

The updated average.

Explanation:

The Microsoft excel spread sheet, in this context, requires input average input from cell B2 to B4.

The formula for the average is given with the function "=Average(B2:B4)" is written in the cell B5.

Mathematically, the spread sheet adds the values in cell B2, B3 and B4 and divides it by 3 and displays the result in the cell B5.

When a value in the range of selected values is changed like David's science score, from 67 to 69, the value of the average in the cell B5 changes automatically in the excel worksheet.

You might be interested in
Helen has no experience in security. She would like to earn a certification that demonstrates that she has the basic knowledge n
rewona [7]

Answer:

Option C. Security+ is the correct answer.

Explanation:

8 0
3 years ago
Write a loop that reads strings from standard input where the string is either "land", "air", or "water". The loop terminates wh
Setler79 [48]

The loop terminates when "xxxxx" is read in. If the word is land, the string followed by "land" get outputted. The same with air, and water.

Explanation:

int land = 0;

int air = 0;

int water = 0;

String word = "";

while(!(word.equals("xxxxx"))) {

word = stdin.next();

if(word.equals("land")) {

   land++;

}else if(word.equals("air")) {

   air++;

}else if(word.equals("water")) {

   water++;

}  

}

System.out.println("land:" + land);

System.out.println("air:" + air);

System.out.println("water:" + water);

5 0
3 years ago
To use patterns and observations to say what happens next
posledela
You would need to show a pic
4 0
3 years ago
What is the part of a CSS declaration that describes the HTML tag?
jeyben [28]

Answer:

a selector

Explanation:

4 0
3 years ago
Write the definition of a function named swapints that is passed two int reference parameters. The function returns nothing but
Alja [10]

Answer:

void swapints(int *j,int *k)//Function definition.

{

   *j=*j+*k-(*k=*j); //value swapping.

}

swapints(&j,&k);//call the function.

Explanation:

  • The above function definition takes the address of j and k variables which is stored on the pointer variable j and k.
  • Then the pointer variable uses the j and k value for the above expression, and the user does not need to return the value of j and k.
  • But when the user prints the value of the j and k variable, then he gets the swapping value of the j and k variable.
  • The user needs to know that the "int j" is a normal variable, but "int *j" is a pointer variable that is used to take the address of j variable.
3 0
3 years ago
Other questions:
  • You're working at a large industrial plant and notice a tag similar to the one shown in the figure above. Which of the following
    5·1 answer
  • In the range C15:G15, insert a function to calculate the total daily revenue. In the range H11:H15, insert a function to calcula
    8·1 answer
  • What is the recommended size for bulleted text?
    5·2 answers
  • A(n) ____ path is a path used for external links that includes the complete address for the destination page, including the prot
    12·1 answer
  • 1. You can apply CSS formatting in which of the following ways?
    6·1 answer
  • A computer has the following parameters Operation Frequency Cycles Arithmetic/Logical instructions 65% 1 Register load operation
    11·1 answer
  • One of the primary principles of the Rapid Application Development methodology is early prototyping of the _______ in the develo
    6·1 answer
  • Which of the following statements is TRUE of a peer-to-peer network?
    10·1 answer
  • Maria needs to use a requirement-gathering method that will help her provide a set of questions to the client. Which method shou
    11·1 answer
  • Basics of visual basic
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!