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
Computers and Technology, 21.06.2019 17:20
Find the inverse function of f(x)= 1+squareroot of 1+2x
Answers: 2
Computers and Technology, 22.06.2019 19:30
The following is an excerpt from a slide presentation. today we will inverse operations solving equations using inverse operations solving inequalities using inverse operations from which part of the presentation does the slide most likely come from? a. introduction b. outline c. body d. conclusion
Answers: 1
Computers and Technology, 23.06.2019 12:00
From excel to powerpoint, you can copy and paste a. cell ranges and charts, one at a time. b. cell ranges and charts, simultaneously. c. charts only. d. cell ranges only.
Answers: 3
Computers and Technology, 23.06.2019 12:50
Which syntax error in programming is unlikely to be highlighted by a compiler or an interpreter? a variable name misspelling a missing space a comma in place of a period a missing closing quotation mark
Answers: 1
Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or...
Mathematics, 03.07.2019 15:30
English, 03.07.2019 15:30
Computers and Technology, 03.07.2019 15:30
Biology, 03.07.2019 15:30
Business, 03.07.2019 15:30
English, 03.07.2019 15:30
Mathematics, 03.07.2019 15:30
Mathematics, 03.07.2019 15:30
Spanish, 03.07.2019 15:30
Chemistry, 03.07.2019 15:30