Computers and Technology, 28.11.2019 01:31, alanisalvarez2000

Use an if function in cell h18 to calculate the commission rate for the total sale for order 1. the commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. no commission is paid on sales that total $5 or less. reference the threshold levels (cells f13 and f14) in your logical tests for your if function and the commission rates (cells g13 and g14) as your "value_if_true" and "value_if_false" arguments. use appropriate relative and absolute references.

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 06:30, eddsworldfrantic

You have a small company and want to keep your costs low, but it is important your employees share data. which network would provide you with the most economical solution?

Answers: 1

continue

Computers and Technology, 23.06.2019 12:00, trippie4life

3. when you right-click a linked spreadsheet object, what commands do you choose to activate the excel features? a. linked worksheet object > edit b. edit data > edit data c. linked spreadsheet > edit d. object > edit data

Answers: 2

continue

Computers and Technology, 23.06.2019 18:00, bubbles173883

While inserting images, the picture command is usually used to insert photos from a digital camera, and the clip art command is usually used to a. edit the sizes and other characteristics of photos that have been inserted. b. take a screenshot of an image and copy it to the clipboard for pasting. c. search for drawings or other images from a library of prepared pictures. d. make illustrations using lines and shapes that are easy to manipulate.

Answers: 1

continue

Computers and Technology, 24.06.2019 02:00, arubright177

Write an expression that will cause the following code to print "equal" if the value of sensorreading is "close enough" to targetvalue. otherwise, print "not equal". ex: if targetvalue is 0.3333 and sensorreading is (1.0/3.0), output is:

Answers: 1

continue

Do you know the correct answer?

Use an if function in cell h18 to calculate the commission rate for the total sale for order 1. the...