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
Delvig [45]
3 years ago
11

2. determine the handling surcharge for items which are fragile and insurance cost for items which have a high value. (handling

surcharge for fragile items + insurance for high value items) write an excel formula in cell packlist!g3 to calculate this value for the corresponding item. handling surcharge and insurance values are given on sheet handling. round these charges to the nearest cent. copy your formula down the column to determine this value for each corresponding item.
SAT
1 answer:
shutvik [7]3 years ago
7 0

The handling surcharge for items that are fragile and insurance cost for items that have a high value are two different terms that can be filled in different cells on the Excel Sheet. On the Excel sheet, the excel formula that can be used to calculate the value of the corresponding item is:

  • = SUMIF (handling surcharge for fragile items: insurance cost for high_value items, criteria, [sum_range])

An Excel sheet is a spreadsheet that is used for calculating arithmetic operations, statistical calculations, and graphical analysis. In an Excel sheet, simple commands are input by using the Excel Formulas.

For the given example; the excel formula to be used is:

  • = SUMIF (handling surcharge for fragile items: insurance cost for high_value items, criteria, [sum_range])

The formula is therefore being copied and pasted down in the subsequent cells below to determine the values of other corresponding items.

Therefore, we can conclude that the excel formula to be used can be seen in the format outlined above.

Learn more about excel formulas here:

brainly.com/question/20620378?referrer=searchResults

You might be interested in
Arteries are blood vessels that transport oxygen-rich blood and nutrients throughout the body. what level of organization is an
finlep [7]

The study of a living being is called biology.Artery is the vessel that transfers the oxygen-rich blood from the heart to the different organs.

<h3>What is an artery?</h3>

The artery is the vessel that transfers the oxygen-rich blood from the heart to the different organs.

The vessel is a cylindrical shape tube that carries the blood.

A group of cells is called tissue and the group of tissue is called organ. The vessel is organ level organization.

Hence,an artery is the vessel that transfers the oxygen-rich blood from the heart to the different organs

For more information on Artery refer to the link:-

brainly.com/question/13899929

#SPJ1

8 0
3 years ago
Pls help me ill give u 10 points if u get it right
victus00 [196]

Answer:

the correct answer is capillary

3 0
3 years ago
What are samples values that lie very far away from the vast majority of other sample values
Ivanshal [37]
Outliers are the samples that lie away from others
7 0
3 years ago
ewwwwwwwwwhnn4thb4gkg knlbnk egfn ndca;m slkvnckcx dsmvkrjdmn mjkwfenvcrjdnfv iorjdmnfvjpnemdnvcjewrnvkjdfnij
AlexFokin [52]
Answer is ewwwwwwwww
6 0
3 years ago
Scott’s employer pays 70% of his health insurance premium and deducts the remainder from his paycheck. Scott is paid biweekly, a
kvv77 [185]

The amount deducted from his paycheck for health insurance bi weekly is; $100.94

<h3>What is the amount deducted?</h3>

Since 70% of his health insurance premium is paid by his employer and the remaining deducted, then;

Scott's amount deducted per week for health insurance =  8,748 x 30% = $2,624.40

There are 52 weeks in a year and as such, amount deducted weekly is;

2,624.40/52 weeks = $50.47

Amount deducted bi weekly = 50.47 × 2 = $100.94

Read more about amount deducted at; brainly.com/question/2880026

5 0
2 years ago
Other questions:
  • the up process used to convert seawater to fresh water is known as? A:salination B: deforestation C: desalination D: desertifica
    12·2 answers
  • People learn about norms deviance social behavior through ?
    12·1 answer
  • Which of the following is true about AP classes?
    14·1 answer
  • upaya apa yang dilakukan suatu organisasi agar mampu menjalankan visi dan misi organisasi secara optimal?
    11·2 answers
  • Explain business financing \\
    8·1 answer
  • The price of a house has many variables in determining the price. One of the variables is
    15·1 answer
  • Which substances are necessary for the synthesis of most materials in an organism.
    6·1 answer
  • a school choir has 36 members. this year, there are three times as many returning members as new members. how many new members a
    8·1 answer
  • Which are risk factors for gang involvement? check all that apply. being interested in school using drugs having a network of fr
    8·2 answers
  • Networking is a key benefit to a college education. Which of the following is
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!