Question: Create the spreadsheet: Create five columns, Individual Name, Business, Total Sales, Number of Sales, Salary, Bonus and Salary + Bonus . Enter 10-15 lines of

Create the spreadsheet:

  • Create five columns, Individual Name, Business, Total Sales, Number of Sales, Salary, Bonus and Salary + Bonus.
  • Enter 10-15 lines of data that fits the criteria for the first six columns above. Make sure data in Sales is over $50,000 and number of sales ranges from 15 to 100.
  • In the Salary+Bonus field create a function that indicates which individual(s) should receive a bonus because he/she sold more than $250,000 and had more than 50 sales.
  • Enter at least 10 records

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Hi, I need a help from those people who have a great knowledge regarding accounting. Please help me to resolve the questions in attached file. BSB51215 Diploma of Marketing BSBFIM501 Manage budgets...

Q:

Hi, I need a help from those people who have a great knowledge regarding accounting. Please help me to resolve the questions in attached file. BSB51215 Diploma of Marketing BSBFIM501 Manage budgets...

Q:

Slyses ELE UNIVERSE TO IF and Nested IF (Spoints) 1. Examine the Assignment details worksheet and enter your full name. 2. Click on the Customer Relations worksheet and play around with the data by...

Q:

I am attaching all of the questions. These are basically small questions which are required to be answered as per the exact requirements. These are all related to finance. No irrelevant details are...

Q:

I need to complete phase 3 of the schnappauf family case. PHASE lI-CHAP'I'EIIE 5-5 This is the seeenci phase eF the te:t tenIIn prehlem Ire-u began at the end efhapter 1r. Th' phase uf the tax return...

Q:

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Q:

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

Q:

5/13/2016 MGMT404 Course Home Course Project (SEP15) Course Project Listen What's this? Objectives The objective of the Course Project is to give you an opportunity to practice the skills learned in...

Q:

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Q:

I have the following completed: 1120, 2220,1125 A , 1125 E I need the following forms completed asap:SCHEDULE D and G form 4562, form 4797 schedule detail M-1 it should be fairly easy to do the rest...

Q:

LeMond has 50 full time employees. Recently the company decided to initiate a pension plan as part of its employee compensation package. The pension plan will start on January 1, 2019. As required by...

Q:

Natural hedges sometimes exist for a company with an operation abroad. What is meant by this term, and why are natural hedges important?

Q:

Preparing a budget does not allow managers to eliminate any variagoes that would have been created without a budget. help divilions withint the organitation to communicate with one another. assess...

Q:

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...