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
just olya [345]
3 years ago
6

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

Computers and Technology
2 answers:
natali 33 [55]3 years ago
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
Design a circuit that will tell whether a given month has 30 days in it.
Ipatiy [6.2K]

The simplified equation is given as Y=A_3A0+A3A0. To draw the circuit diagram using a minimum number of gates we use this equation and the x^2 equation to form the truth table. This is further explained below.

<h3>What is a circuit?</h3>

Generally, a circuit is simply defined as a full circular channel via which electricity travels in electronics. A power flow, terminals, and a drain make up a basic circuit.

In conclusion, The circuit will need 4 inputs to produce 16 combinations in order to determine if the month contains 31 days. At 4 inputs, there are 12 inputs required. the

Hence,we use this information and the x^2 equation to form the truth  table

the Equation is given as

Y=A_3A0+A3A0

Read more about  circuit

brainly.com/question/27206933

#SPJ1

6 0
2 years ago
The encapsulation unit on the presentation layer of the osi model is
Zielflug [23.3K]
<span>The encapsulation unit on the presentation layer of the OSI model is the Data link layer (2).</span>
7 0
3 years ago
Which one of these tasks is part of the pre-production phase of game development?
pickupchik [31]
[B], developing the art style guide and production plan.

It wouldn't be [A], because patches are released to consumers of the game, to fix bugs and add new content, which won't be done until post-production.

It wouldn't be [C] either, as it is also post-production, because you are sending the game to produced, packaged and shipped, meaning the game has already been pretty much fully developed.
7 0
3 years ago
Read 2 more answers
When you are typing data that is in a series, such as days of the week or months of the year, you can use this tool to complete
sertanlavr [38]

Answer:

Days of the week including weekends Fill Weekdays – you can autofill working days of the week excluding weekends. This is very cool. I can autofill dates excluding the weekends. Fill Months – and you can use the full word or a standard abbreviation for the month, and Excel will autofill the sequence.

Explanation:

3 0
2 years ago
Which type of worker would most likely be able to begin work after receiving a high school degree and completing an
makvit [3.9K]
I’m pretty sure it’s miner

“I’ll give you head I mean brainiest”
3 0
2 years ago
Other questions:
  • Which shortcut key combination will move the cursor to the beginning of the line
    10·1 answer
  • How many bits must be “flipped” (i.e., changed from 0 to 1 or from 1 to 0) in order to capitalize a lowercase ‘a’ that’s represe
    11·1 answer
  • )What is proceduralabstraction, and why is it important inComputer Science
    14·1 answer
  • Baking Cookies. Sweet Dough Inc. bakes cookies—a popular dessert—based on the quantities ordered by their customers. Three raw m
    12·1 answer
  • What simple machine is most often used to lift the blinds on a window?
    8·2 answers
  • What is cyber ethics​
    10·2 answers
  • Which of the following is an example of a long-term goal?Developing a lifetime savings plan
    11·1 answer
  • Question 1:
    5·1 answer
  • Which of the following images illustrates safe driving?
    8·2 answers
  • Operating systems move code and data, as necessary, to a portion of the disk that is used as if it were memory, not just disk st
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!