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
1. You want to find if TCP/IP Services are working properly on your Computer, you would use which command? a. PING LOCALHOST b.
Olegator [25]

Answer:

Option A

Explanation:

Option B is rejected because it is used to get the startup network settings, processes extra features used by the network.

Option C is rejected because it is used to check the stats like ping,fps of the network by using a loop back.

Option A is selected because PING command is used to check the data packets transfer rate between two ends using ICMP protocol. Local host means that you are specifying the one end as your side. If the packets are there then it is working else the IP service is down.

3 0
4 years ago
the guest would like to convert his 100 dollar to peso.How much will the guest receive if the exchange rate is 1 dollar=Php 50.5
Lera25 [3.4K]

Answer:

the guest receive 5050 peso if he exchange

$ 100

Explanation:

  • 1 $ = 50.50 peso
  • 1 $ × 100 = 50.50 peso × 100
  • 100 $ = 5050 peso

<em>i</em><em> </em><em>hope</em><em> </em><em>it</em><em> </em><em>helped</em><em>.</em><em>.</em><em>.</em><em>.</em>

4 0
3 years ago
Read 2 more answers
M/J Business Keyboarding Guided Notes Module 2
attashe74 [19]
Why is there so much
8 0
3 years ago
A ____ is an area in ram or on the hard drive designated to hold input and output on their way in or out of the computer system.
Goshia [24]

A buffer is a region in RAM or on the hard drive assigned to hold information and yield on their way in or out of the framework. In <span>computer science , <span>an information cushion or simply support is a zone of a physical memory stockpiling used to briefly store information while it is being progress starting with one place then onto the next. However, a buffer might be utilized while moving information between forms inside a PC.</span></span>

4 0
4 years ago
What is cryptography
deff fn [24]
<span>Cryptography is a science to transform using secret key called conventions, information or clear signals in information or signals unintelligible to third parties not having the knowledge of the secret, or perform the reverse operation through means hardware or software designed for this purpose.

Cryptography is used to detect the loss of integrity of information, contacts authenticate and protect <span>the confidentiality of information</span></span>
6 0
3 years ago
Read 2 more answers
Other questions:
  • If a method writes to a file it should start out like (fill out the blank, what should you write after the parameters in the met
    12·1 answer
  • Denny often uses his word-processing program. Which of the following would Denny do to more easily access this program and incre
    14·2 answers
  • Select
    14·1 answer
  • A photograph with more yellows has which mood
    6·2 answers
  • The two primary methods of memory allocation are:
    6·1 answer
  • Assume the following:
    10·1 answer
  • T.L.E
    6·1 answer
  • Any action that causes harm to your computer is called a
    15·1 answer
  • The template code provided is intended to check whether an integer entered by the user is outside of the range 20-29 (inclusive)
    9·1 answer
  • Does anyone know how to do Python Essentials 5.7.1.6 because i am completely lost
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!