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
Ethics is a way of behaving so that you are
vichka [17]

Answer:

Doing what is right I think

3 0
3 years ago
Read 2 more answers
While the Internet can be a great resource, the information is not always reliable, as anyone can post information. Select one:
Olin [163]

Answer: True

Explanation: Because anyone can post something and it can be non reliable

7 0
3 years ago
Which of the following statements is true of alert files?
ozzi

Answer:

They are only generated by Wireshark.

3 0
3 years ago
_____ refers to unsolicited commercial emails, usually sent to a large number of people with little regard to the users interest
frozen [14]
Spam refers to large unsolicited email irregardless of the recipients views on the matter
5 0
3 years ago
16.50. Suppose we have a sequential (ordered) file of 100,000 records where each record is 240 bytes. Assume that B = 2,400 byte
Nat2105 [25]

Answer and Explanation:

Given that total number of records in a file = 100000

Each record consists of= 240 bytes

Given that B= 2400 bytes.

Then total blocks in file = 100000 records * 240 / 2400

= 10000 blocks.

Time that will take for exhaustive read

= s + r + b.btt

= 16 + 8.3 + (10000) * 0.8

= 8024.3 msec

Now as per given X be the number of records that are searched randomly and it takes more than exhaustive read time.

Hence, X (s + r + btt) > 8024.3

X (16+8.3+0.8) > 8024.3

X > 8024.3/25.1

So that, X > 319.69

Hence, atleast 320 random reads should be made to search the file

8 0
3 years ago
Other questions:
  • PLEASE HELP ASAP!!!
    15·2 answers
  • When troubleshooting a desktop motherboard, you discover the network port no longer works. What is the best and least expensive
    10·1 answer
  • 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
  • In terms of object-oriented programming, after a class is defined,
    11·1 answer
  • A byte contains how many bits? Question 3 options:
    13·2 answers
  • Which of the following technologies can operate in the 125 kHz to 134 kHz range?
    10·1 answer
  • Write programs in python to display “Valid Voter”. (condition : age of person should be
    15·1 answer
  • An alternative to configuring individual workstations is to establish configurations dynamically when the computers connect to t
    7·1 answer
  • CHOOSE THE CORRECT CONTINUOUS TENSES( PRESENT CONTINUOUS,PAST CONTINUOUS AND FUTURE CONTINUOUS) : 1. I saw a snake while I _____
    10·1 answer
  • Jjhb ft fv tuning Denise l Debbie
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!