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
A network administrator has been given a network of 172.16.85.0/21 and wants to know the usable range of IP addresses on that su
viktelen [127]

Answer:

The correct answer to the following question will be option C.

172.16.80.1-172.16.87.254

Explanation:

IP Address: IP Address stands for Internet Protocol Address, a unique numerical label allotted to every computer network that are connected to the network of the computer and communicate through the internet protocol.

  • An IP address can be separated by periods and having four numbers that are called Octet. Range of IP address can be from 0 to 255.
  • We have to keep the first 21 bits and start setting all from the 22nd bit on to 0 (zero).
  • To get the suitable and the correct range of the address, we add and subtract 1 from the given broadcast address i.e.,172.16.85.0/21.

So, option C is the right answer and no other option is usable according to the given explanation and the address given by the administrator.

3 0
3 years ago
Match each term with the statement that best describes it.
chubhunter [2.5K]

Answer:

Field: A placeholder for information that changes

Explanation:

The are on the page where we write our information. Each page consist of field area where we write text, insert figures and tables.

Table: A grid of columns and rows that you can fill with text and graphics

Explanation:

The arrangement of row and columns to organize the information for the purpose of analyzing and comparing is called Table.

Section break: A formatting mark that divides a document into parts that can be formatted

Explanation:

If we want to divide the document in terms of formatting, we apply section breaks in the document. e.g. If we are writing a document in landscape mode and want to insert few pages in portrait mode then we apply section break.

Header: Text or graphics that appear at the top of every page in a document

Explanation:

The place at the top of the page, where we want to insert some text that should be fixed on each page such as page number, chapter name or book name. We use header.

Manual page break  of the next page: A formatting mark that forces the text following the mark to begin at the top

Explanation:

If we complete the working on one page and want to start work on new page. we apply page break so that any change in formatting of the previous page could not affect the new page.

Footer:Text or graphics that appear at the bottom of every page in a document

Explanation:

The place at the bottom of the page, where we want to insert some text that should be fixed on each page such as page number.

Bibliography: A list of the sources used to create a document

Explanation:

The list of sources that we use to complete our document, from we read some literature to support our arguments. It has been added at the end of the document.

Citation:  A parenthetical reference in the document text that gives credit to a source

Explanation:

The information that we read from other document and insert in our document, assign it a reference to insert in bibliography section.

Margin: The blank area between the edge of the text and the edge of the page

Explanation:

The space between text and edges of the the page from top, bottom, left and right side is called margin.

6 0
3 years ago
Application software developed by the user or at the user’s request is called ____ software.
Zolol [24]
End-User Software. Because it is not professional

4 0
3 years ago
Gettier contributed to what we know about the __________ model, while Rosch contributed to what we know about the __________ mod
svet-max [94.6K]

Gettier contributed to what we know about the exemplar model, while Rosch contributed to what we know about the prototype model. Prototype and exemplar theories are both versions of statistical theories of concepts. Prototype theories hold that concepts represent categories by means of a summary of the typical properties that category members possess, while exemplar theories hold that concepts represent categories by means of a cluster of individual category members that may be used to extract the statistical central tendency of the category.

6 0
3 years ago
Read 2 more answers
Someone help me please
MA_775_DIABLO [31]

Answer:

I think it is the last 2 but i am not 100% sure.

Explanation:

3 0
3 years ago
Other questions:
  • Which relationship is possible when two tables share the same primary key? one-to-one one-to-many many-to-one many-to-many
    15·2 answers
  • Tiffany is an instructor at a college that is run on student tuition and not state taxes. Which statement best describes her emp
    6·2 answers
  • which kind of device does a computer need in order to provide information to a person or something else
    7·1 answer
  • CAD workstations
    11·1 answer
  • ___ involves connecting geographically remote computers into a single network and combining the computational power of all compu
    14·1 answer
  • An algorithm that could execute for an unknown amount of time because it depends on random numbers to exit a function may:______
    13·1 answer
  • Create a two functions: first called grocery_cost(food), where food can be one item or a list of items from the stock and price
    7·1 answer
  • Explain how files can be identified as entities on the magnetic surface?
    8·1 answer
  • PLS HELP WITH MY PYTHON HW ILL GIVE YOU BRAINLIEST
    12·1 answer
  • ____ the most popular word processing applications software<br><br>​
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!