All categories

3 years ago

If you wanted to round $3.99 located in Cell B3 to the nearest dollar, what is the correct Microsoft excel formula?

2 answers:

6 0

<span>The formula is B.=ROUND(B3,0)

So, the format is = ROUND (cell #, # of decimal places)

well if # of decimal places is 0, it just rounds to the nearest integer.

Happy studying ^-^

</span><span>
</span>

lesantik [10]3 years ago

5 0

Answer:

=ROUND(B3,0) and we got $4.00

=ROUNDUP(B3, 0) and w got $4.00

Explanation:

First we need to put on cell B3 $ 3.99

For this case we can use two functions ROUND or ROUNDUP

The general formal for ROUND is given by:

=ROUND(Numbers, # of digits)

For our case since we want to round to the nearest dollar or integer the # of digits would be 0:

=ROUND(B3,0) and we got $4.00

With the ROUNDUP formula we can do a similar procedure the general format is given by:

=ROUNDUP(Number, $ of digits to take in order to round up)

Since we want to round to the nearest dollar or integer the # of digits to round up would be 0

=ROUNDUP(B3, 0) and w got $4.00

You might be interested in

A data analyst adds descriptive headers to columns of data in a spreadsheet. How does this improve the spreadsheet?.

Marrrta [24]

The way that adding descriptive headers to columns of data in a spreadsheet improve the spreadsheet is that; It adds context to the data.

Usually in spreadsheets in Microsoft Excel, we could just naturally use letters like A, B or C or even numbers like 1, 2, or 3 as title headers for columns. However, sometimes it becomes necessary to use descriptive headers. This is because the person reading it may not be able to easily comprehend the details or numbers in that particular column.

Thus, in order to add more context to the data in the column of the spreadsheet and improve understanding of context using descriptive headers is very useful.

Read more on excel spreadsheets at; brainly.com/question/25863198

7 0

2 years ago

8.9 Lesson Practice edhesive

lapo4ka [179]

Is what it is so it can’t be what it isn’t

6 0

3 years ago

Read 2 more answers

Mara is a network system analyst for a large investment firm. What kind of

Alchen [17]

Mara is a network system analyst for a large investment firm. The education that Mara would have needed to achieve this position is a bachelor's degree in computer science

Explanation:

Network systems analysts monitor and maintain computer hardware and software applications for businesses and organizations.
They specialize in the infrastructural design of the network and analyze the performance of these systems to best improve it.
The network system analyst also research and report the costs of upgrading or replacing the current networking technology used within a business.
Most bachelor's programs require completion of general education courses in mathematics, English and statistics.
Employers require systems analyst applicants to have at least a bachelor's degree in computer systems analysis, computer science, computer information systems, management information systems, business intelligence or a similar field of study.
A network analyst should hold a bachelor's degree in a field related to programming, information assurance, or computer science as a minimum.
The new criteria include the employers to look for those who hold a master's degree with the master of business administration.

8 0

3 years ago

Split the worksheet into panes at cell G1.

nikdorinn [45]

Answer:

1. Select below the row where you want the split, or the column to the right of where you want the split.

2. On the View tab, in the Window group, click Split.

Explanation:

3 0

3 years ago

What is the utility of a lever?

Kamila [148]

Muy cosas.
fazer una montanha russa andar,ativar una armadilha, ativar una puerta etc.

3 0

3 years ago

Read 2 more answers