subject

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.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 18:00
Jenna updated her status on a social network regarding her upcoming vacation. what information should jenna not provide when updating her status on a social networking site? a. her favorite quote b. her likes in popular culture c. her routine d. her opinions on social issues res
Answers: 1
question
Computers and Technology, 22.06.2019 17:40
Write a modular program (no classes yet, just from what you learned last year), that allows two players to play a game of tic-tac-toe. use a two-dimensional char array with 3 rows and 3 columns as the game board. each element of the array should be initialized with an asterisk (*). the program should display the initial board configuration and then start a loop that does the following: allow player 1 to select a location on the board for an x by entering a row and column number. then redisplay the board with an x replacing the * in the chosen location. if there is no winner yet and the board is not yet full, allow player 2 to select a location on the board for an o by entering a row and column number. then redisplay the board with an o replacing the * in the chosen location. the loop should continue until a player has won or a tie has occurred, then display a message indicating who won, or reporting that a tie occurred. player 1 wins when there are three xs in a row, a column, or a diagonal on the game board. player 2 wins when there are three ox in a row, a column, or a diagonal on the game board. a tie occurs when all of the locations on the board are full, but there is no winner. input validation: only allow legal moves to be entered. the row must be 1, 2, or 3. the column must be 1, 2 3. the (row, column) position entered must currently be empty (i.e., still have an asterisk in it).
Answers: 1
question
Computers and Technology, 22.06.2019 18:10
Assume that to_the_power_of is a function that expects two int parameters and returns the value of the first parameter raised to the power of the second parameter. write a statement that calls to_the_power_of to compute the value of cube_side raised to the power of 3 and that associates this value with cube_volume.
Answers: 1
question
Computers and Technology, 23.06.2019 07:00
Why were most movies from the late 1890s until the early 1930s only filmed in black and white? there were only a few people who could afford the technology to produce color motion pictures back then. audiences did not want color motion pictures until later. the film used to make color motion pictures often overheated, which was a safety hazard, so it was generally not allowed. color films had to be hand-colored, frame by frame.
Answers: 3
You know the right answer?
Lindsey also needs to calculate the commissions earned each month. If the company earns $200,000 or...
Questions
question
Mathematics, 13.10.2020 07:01
question
History, 13.10.2020 07:01
question
Mathematics, 13.10.2020 07:01
question
Computers and Technology, 13.10.2020 07:01
question
Mathematics, 13.10.2020 07:01
Questions on the website: 13722360