Computers and Technology, 16.10.2020 03:01 annekesimonsen
Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or more in a month, the commission is 35% of the sales. If the company earns less than $200,000 in a month, the commission is 27% of the sales. Calculate the commissions as follows:
a. In cell B17, enter a formula that uses the IF function and tests whether the total sales for January (cell B10) is greater than or equal to 200000.
b. If the condition is true, multiply the total sales for January (cell B10) by 0.35 to calculate a commission of 35%.
c. If the condition is false, multiply the total sales for January (cell B10) by 0.27 to calculate a commission of 27%.
d. Use the Fill Handle to fill the range C17:G17 with the formula in cell B17 to calculate the commissions for February through June.
Answers: 2
Another question on Computers and Technology
Computers and Technology, 22.06.2019 11:00
in 2007, floridians died in alcohol-related collisions.a. 501b. 1,051c. 5,015d. 10,839
Answers: 1
Computers and Technology, 23.06.2019 13:30
Jace needs to answer a question on square roots to win a quiz. how can he use a spreadsheet to find the square root of 786? a. use the functions round and count b. create a table and chart c. use the function sqrt d. use the function now
Answers: 3
Computers and Technology, 23.06.2019 17:00
1. which of the following is not an example of an objective question? a. multiple choice. b. essay. c. true/false. d. matching 2. why is it important to recognize the key word in the essay question? a. it will provide the answer to the essay. b. it will show you a friend's answer. c. it will provide you time to look for the answer. d. it will guide you on which kind of answer is required.
Answers: 1
Computers and Technology, 23.06.2019 18:00
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
You know the right answer?
Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or...
Questions
Chemistry, 20.07.2019 23:30
Physics, 20.07.2019 23:30
Social Studies, 20.07.2019 23:30
Mathematics, 20.07.2019 23:30
History, 20.07.2019 23:30
English, 20.07.2019 23:30
History, 20.07.2019 23:30
