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
Sets of keywords and symbols that help refine internet search requests are called _____. boolean operators microsoft operators a
Kay [80]
Boolean operators, it uses the word "and","or" and "not" with keywords to control the search. For example if you search for health and food, the search engine will give a narrow search focusing on the two keywords. Using "or" with keywords will give much broader results. Using a "not" will remove one keyword from the search, ex. windy not rainy will give results of the keyword windy only. An asterisk on the other hand, gives wider results with variations.
3 0
3 years ago
I cant see the answers because the stars are blocking them how can this be fixed
viva [34]

I'm sorry whats your question?

7 0
3 years ago
What the heck is happening what is this?
Brilliant_brown [7]
Just decrease the font size and the size of the like will decrease.

Decrease font size by pressing on the part were it says 29 and typing in a smaller number like 14 for example
4 0
3 years ago
A file containing user information which is transmitted from an online server and attached to your web browser and stored on you
rewona [7]
The answer is: <span>Cookie</span>
5 0
3 years ago
A place where people study space​
fgiga [73]

Answer:

a place where people study space is a Spacey agent

4 0
3 years ago
Other questions:
  • Ryan is working on the layout of his web page. He needs to figure out where the title, links, text, and images should go. Which
    15·2 answers
  • Which is a description of phishing?
    7·1 answer
  • In terms of system thinking, what is process?
    15·2 answers
  • Algorithm that has been coded into something that can be run by a machine.
    10·1 answer
  • Heyyy ik this isn't a dating site but like is there any guy (12,13,14)that would be willing to date a 13 y/o girl
    6·2 answers
  • What are the assignable addresses for the 12th subnet with the network address of 220.100.100.0 and the number of needed subnets
    13·1 answer
  • Selecting missing puppies 1 # Select the dogs where Age is greater than 2 2 greater_than_2 = mpr [mpr. Age &gt; 2] 3 print(great
    8·1 answer
  • Explain any one method of creating a presentation.
    10·1 answer
  • 1: define about information system in computer?
    10·1 answer
  • what is the arrangement of various flash elements, such as the tools panel, control panel, property inspector and stage
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!