Question 9 of 20
Jerry keeps a spreadsheet of all the tools he owns He wants to figure out
how many nails and screws he has so he knows how many more he needs to
buy to have 500 total, If the number of nails and screws is in cells B2 and B3,
what formula would he use to solve this problem?

Answers

Answer 1

Answer:

C. The formula is =500-SUM(B2:B3).

Multiple-choices

A. The formula is EADD(B2:B3).

B. The formula is =SUM(B2:B3)-500

C. The formula is =500-SUM(B2:B3).

D. The formula is =500-ADD(B2 B3).​

Explanation:

An excel formula must start with =

The formula needs to express the answer of subtracting the total of screws and nails from 500. If the required total is 500, Jerry needs to order  500 minus the total number screws and nails.

i.e., 500 -(no. of nails + screws)

Using excel commands

=500 - sum(B3,B5)


Related Questions

Please help?? WILL MARK IF THERE ARE MULTIPLE ANSWERS!!!!!

Answers

High school probably

Discovering objections in the minds of potential buyers often takes place when the seller attempts to ____ the sale.

A. Close
B. Approach
C. Prospect
D. Present​

Answers

Answer:

D. Present​

Explanation:

Sales objection can be defined as a hindrance or an obstacle posed as questions or statements to a salesperson by a potential or prospective buyer (prospect), indicating his or her unwillingness to buy a product.

Generally, in the selling process, prospective or potential buyers may object to a service, producer, competitor, price, time, product etc.

Hence, discovering objections in the minds of potential buyers often takes place when the seller attempts to present the sale such as explaining the benefits attached to a product or demonstrating how to use the product.

Additionally, in order to convince a potential buyer or handle the objections raised during the presentation of a product, salespersons are usually advised to listen, respond, clarify, and respect rather than being defensive.

Answer:

d.

Explanation:

Question 2 of 10
Jeremy doesn't have a lot of money to spend on advertising, but he knows his
target audience are local outdoor enthusiasts. Which type of media format
should Jeremy use to advertise?
A. Local newspapers
B. Billboards on busy streets
C. National television commercials
D. Plane banners

Answers

Answer:

B. Billboards on busy streets

Explanation:

Billboard advertising involves making use of large-scale print advertisements to market a company's products and services.  Billboards are strategically mounted in high traffic areas to pass their message to as many people as possible. Busy highways and streets, strategically located buildings are ideal places to put billboards.

Jeremy should consider using billboards for the following reasons.

His clients are local outdoor enthusiasts;  he needs to find out their favorite destinations are put billboards along the way. This way, he will capture their attention.Billboards are less costly compared to other advertisement options, such as television or plane banners.Billboards will be effective in his case. Because his clients are local, and billboards remain in place for several days or weeks,  his target clients will not fail to spot them.

Answer:local news papers

Explanation:

Allison corporation acquired 90 percent of bretton on January 1, 2016. Of Brettons total acquisition date fair value, $60000 was allocated to undervalued equipment

Answers

Answer:

Hello your question is incomplete attached below is the complete question

answer : consolidated Total sales = $1008000

Explanation:

Determine the consolidated totals for sales

to get the consolidated totals for sales we have to add up the two book values then subtract $92000 ( which is the entity transfers )

Consolidated Total sales = ($70000 + $400000 ) - $92000

                                          = $1100000 - $92000 = $1008000

The farm always comes_______. This is something many feel the general public does not understand unless they came from a farm.

Answers

Answer:

First

Explanation:

something many people dont understand is a farm is a business and it always comes first. hope this helps

One way products can be categorized is by brand.
O a) True
Ob) False

Answers

Answer:

A. True.

Explanation:

One of the direct implementation for this categorization can be seen if you go to your supermarket. Supermarkets tend to categorize their product in a way that resulted in the most sales.

In order to achieve this, they tend to lined up the most popular brands on a place that's close to costumers' eye level on the shelf. The less popular brand will be place on top or lower part of the shelf that's a little bit harder to see.

2. How should employers respond to K to 12 graduates who apply for vacant positions in
3. What were the perceived disadvantages of K to 12 graduates pcompared to college students?
4. What factors could give K to 12 graduates an advantage in the labor market?
Discussion Questions
1.
What is the dilemma K to 12 graduates face when applying for a job?
their company? Pa help asap po

Answers

Answer:

am sorry

Explanation:

i had to do it pls give me pts

have seen ystuckey on brainly

Answers

???????????????????????????????????????

Which is NOT a fee you need to worry about with a checking account?

Answers

Answer:

It depends on the bank provider. All bank providers have different fee policies.

Explanation:

There is no specifc answer to this.

If you are inserting an address block with the Address Block dialog box and the fields do not connect automatically, what can you do?

Answers

Answer: Click Match Fields and match them manually.

what is the opposite of the opposite of left???
if you get it fight you get brainliest!!!!

Answers

Answer:

Opposite of left, right. Opposite of right, left

I lost some brain cells O.O

Answer:

left??? i think

Explanation:

Explain one advantage of good branding to a business.

Answers

Answer:

I DIDN'T COPY FROM GOOGLE, I PUT IT IN MY OWN WORDS

Explanation:

Having a good, customary brand amplifies your reliability with Customers, your production, and the marketplace as a whole. As you boost your credibility, you also construct acknowledgment, allegiance, and competitiveness.

Pls help i need help fast pls
The percentage of a person's pay that is deducted for FICA-Social Security is _____.
Group of answer choices

6.2%

1%

3%

10%

Answers

Answer:

6.2%

Explanation:

According to the Employers Tax guide Employer's publication 15 of  2020, an employee social security deduction should be  6.2% of their gross pay.  It means the employee is deducted 6.2% of gross pay as social security tax. The employer is also expected to contribute 6.2% of the employee' gross pay.

Ben Thomas is earning an annual salary of $15,090 at Custom Stereos. He has been offered a job at the local Ford dealer for $16,660 annually. How much more would Ben earn per week if he accepts the position at the Ford dealer?

Answers

Answer:

$30.2

Explanation:

The current annual salary for Ben Thomas is $15,090. the weekly salary will be $15,090 divide by 52

=$15,090 / 52

=$290. 2

The new annual salary at the Ford dealer is $16,660

Weekly salary is the annual salary divided by 52

= $16,660 / 52

=$320.4

Ben Thomas will earn much more by:

=$320.4 - $290. 2

=$30.2

Who wants points answer in this question points for 10 points ;)

Answers

Answer:

OK Thanks for the free points

yesExplanation: yes thank you so much

Malinda's auto dealership of imported cars made $895,000 in revenue. The manager has determined that the total expenses equal to $598,000. Will this business net a profit or loss? _____ How much of a profit or loss? _____

Answers

Answer:

Profits : $297,000

Explanation:

Revenue is the money a business gets by selling its products and services to customers. Expenses are the cost incurred in the normal business process, like production and selling.

A business is profitable when revenues are more than expenses.

For Malinda Auto dealership, the revenue ($895,000) is more than expenses($598,000). Therefore, the business will make a profit.

Profit = revenue - expenses

=$895,000 -$598,000

=$297,000

the fact that companies can store and access emails sent or received on their equipment limits which of your rights

Answers

Answer: the answer is Privacy

Explanation:

They are limiting your rights of privacy by them being able to access your emails and such if that makes sense.

Answer:

Privacy

Explanation:

A p e x

Match the examples with the types of goods. To match them, click the example, and then click the type of good.
Match the examples with the types of goods.



To match them, click the example, and then click the type of good.

Omar buys a snack bag of chips that he noticed while waiting in line at the store.

Unsought good

Joaquin pays for renters' insurance so that he will get paid if his belongings are destroyed in an accident or burglary.

Convenience impulse good

Jamie goes to the store to buy toothpaste.

Convenience staple good

Wanda reads reviews of different video cameras to decide what brand she wants, and then chooses the store with the lowest price on that item.

Shopping good

Adriana only buys doughnuts from her favorite local doughnut shop.

Specialty good

Answers

Answer:

1. Convenience impulse good

2. Unsought good

3. Convenience staple good

4. Shopping good

5. Specialty good.

Explanation:

1. Omar buys a snack bag of chips that he noticed while waiting in line at the store: Convenience impulse good.

A convenience impulse good can be defined as goods (products) that an individual purchases without planning to buy them or having prior intention to do so. Therefore, convenience goods are easily available and often purchased by impulse.

2. Joaquin pays for renters' insurance so that he will get paid if his belongings are destroyed in an accident or burglary: Unsought good.

Unsought goods can be defined as goods or services that an individual do not think of buying or isn't aware of but purchases due to a fear of danger (damage).

3. Jamie goes to the store to buy toothpaste: Convenience staple good.

A convenience staple good can be defined as goods (products) that an individual consumes on a regular basis and as such are purchased more often.

4. Wanda reads reviews of different video cameras to decide what brand she wants, and then chooses the store with the lowest price on that item: Shopping good.

Shopping goods can be defined as goods (products) that an individual purchases after doing due diligence by comparing its style, quality and price in other stores.

5. Adriana only buys doughnuts from her favorite local doughnut shop: Specialty good.

Specialty goods refers to consumer goods that an individual considers to be exclusive and unique, for which he or she would go any length and perhaps, do anything to get them due to the strong preference.

As a student, you are able to earn extra money by assisting your neighbors with odd jobs. If you charged $10.25 an hour for your assistance, about how many hours would you need to work to earn $8,425? Show your work.

Answers

Answer:

822 hours

Explanation:

The charge per hour is $10.25.

To earn a total of $8,425,  one need to work ? hours.

1 hr =$10.25

? hrs = $8,425

?hrs = $8,425 / $10.25

=821.951

=822 hours

Does walking your neighbors dog everyday (and there elderly) count as community service?

Answers

Answer:

It depends.

Explanation:

If you are helping people who need help, and if they are your neighbors, then they are in your community. Thus, you are doing community service.

Although, if they don't need help and you keep insisting, then that might not be community service because they don't need your help.

Why is international trade important to most countries?
A. Trade allows countries to acquire natural resources not found in
their own territories.
B. Trade ensures that countries will not create trade deficits that
harm their economies.
C. Trade protects countries from economic competition with
neighboring countries.
D. Trade encourages countries to produce all the goods their citizens
need.

Answers

The transfer of welfare's, services, commodities among the nation for financial gain is called international trade.

The correct answer is:

Option A. Trade allows countries to acquire natural resources not found in their territories.

This can be explained as:

Import and export of sources between the countries allow the nation to grow their market and assets.

Because of the international trade modes, the availability of the assets not produced in their country is available for the citizens to utilize.

It gives more employment and hence improves the nation's economy.

Therefore, trade allows countries to avail resources that are found in their region.

To learn more about international trade follow the link:

https://brainly.com/question/20344185

Answer:

A

Explanation:

Which of the following skills are
important for secretarial positions, as
much of the varied business
operations go through them and they
must be prepared for a lot of
simultaneous activity?
A. organization
B. editing
C. analytical

Answers

Answer:

A. organization

Explanation:

a secretary writes the minutes during a meeting and also schedules the meetings for his boss therefore he/she must be organized for the work to be done efficiently.

Which of the following is an advantage of using focus group research instead of survey research?
You can get information from a medium sized group of people.
You can get information from larger numbers of people.
You can get more detailed information from vantage of using focus group research Instead of survey research?
You can get information from a medium sized group of people
You can get information from large numbers of people.
You can get more detailed information from individuals
You can get information from a more representative sample
You can get information from a more representative sample.

Answers

Answer:

you can get information form a good medium sized group of people .

Explanation:

hope this helps.

 have a great day. <3

25 points
What is it called when you change the color within a theme?

Question options:

Color change


Transition color


Variant


Flexible coloring

Answers

Answer:

transition color

Explanation:

i just finished the test

A large corporation wants to expand into Asian markets. They want to issue a bond and plan to guarantee the bond with land holdings in Latin America so What type of bond would they issue ? Why?

A. Corporate
B. Municipal
C. Agency
D. US Treasury

Explain why

Answers

Answer:

A. Corporate

Explanation:

Corporate bonds are debts instruments used by public and private corporations to raise capital from investors. They offer predetermined interest payments to the investor and the principal amount when the bond matures. Corporate bonds are riskier than government securities; that why they offer a higher interest rate.  

To attract investors to purchase a bond, a corporate may use some of its assets to back the bond. The assets become collateral for the bond. The land in Latin America will guarantee the bond. Investors will have the right to dispose of the land to recover their money should the company fail in its bond obligations.

air transport is not dense in​

Answers

Answer:

La niebla

Explanation

Answer:

Stratosphere

Explanation:

An earned education certificate track
after an individual has successfully
completed the necessary course
requirements for a particular field at a
community college

Answers

associates degree !!!!!!!

when the Vat rate is 15% a customer pays Rs 1610 to buy an electric iron . Find the cost of the iron without Vat.​

Answers

is this a real answer what the actual f

What's the difference between product and brand?

Answers

A product is made by a company and can be purchased by a consumer in exchange for money while brands are built through consumer perceptions, expectations, and experiences with all products or services under a brand umbrella.

Answer:

A product is made by a company and can be purchased by a consumer in exchange for money while brands are built through consumer perceptions, expectations, and experiences with all products or services under a brand umbrella. For example, Toyota's product is cars. ... Without a product, there is no need for a brand.

The people who are working for and supporting a company's success are also known as what?
A. Sales leads
B. Prospects
C. Authoritative managers
D. Human resources

Answers

Answer:

D. Human resources

Explanation:

Human resource is the term that describes the people who work for an organization, business, or industry. The term human resource describes the employees, workforce, or personnel in a company.  

Human resource contributes different skills and talents to a business making it succeed.  Anybody who to trade their labor, energy, skills, knowledge, or time for compensation to grow an organization is a human resource. Part-time workers, full-time employees, contractors, and freelancers are all considered human resources in a company.

Answer:

D. Human Resources

Explanation:

Edg2020 quiz

Other Questions
Pagewhat are the challenges of adolescence How many mL of ethanol would youadd to water to make 1750 mL of a40.0% ethanol solution (v/v%)? Which description best summarizes why the feudal system benefited all its members? did america need to be an imperial nation? Breaking information down into organized and manageable chunks for your study guide will help to reduce test anxiety. Two identical conducting spheres each have a charge of 2 C. They have a radius of 0.1 m and are separated by 0.5 meters. If you were to increase the radius of these spheres to 0.2 meters, the electrostatic force between them would A first-person narrator whose understanding or interpretation of the events in a story may differ from those of the author.A. NarratorB. Unreliable narratorC. First person Solve for x.10x3x+5=26 Write each number below in Scientific Notation.1. 92, 000 = 9.2 x 1042. 109,000 = 1.09 x 1053. 4,673 = 4.673 x 1034. 0.00087 = 8.7 x 10-45. 0.0235 = 2.35 x 10-2 What is 15.23 rounded to the nearest hundredth SOMEONE PLEASE HELP ME WITH THIS!!!! What is mechanical weathering? What are some examples of mechanical weathering? Pa help po plssss Letter B,C po plss What can you infer about triangular trade? A cat is walking down a sidewalk and spots a dog in a nearby yard. The cat starts to run in the opposite direction and then quickly climbs a tree. Which of the following changes most accurately describes the movement of the cat? A. change in speed B. change in distance C. change in velocity D. change in motion(i think i know it, i just wanna be sure i have the right answer) I WILL MARK AS A BRAINLIEST ASAP PLEASE!!!!!What three (3) things does Okoye have that make him a successful man?a) |b)c) Brainiest!!!!!!! please help What magnification would be obtained if an eyepiece with a focal length of 0.38 m was placed on telescope? Write as an exponent with the base of b:[tex]bb^{m}[/tex] Should boys and girls be in separate classes?