Objective/s: Apply logical functions given certain conditions 1. Open a new workbook and type the following to the corresponding cells: Percent Invoice Sales Cost Margin Paid? Commission 00001 50000 45000 YES 00002 150000 60000 NO 00003 60000 45800 YES 00004 45000 20000 YES 00005 85000 64000 YES 00006 36000 9000 NO 00007 591000 350000 NO 00008 25000 14000 YES 00009 78000 60000 YES 00010 36000 28000 YES 00011 65000 60000 YES Note: Commission can only be availed if margin is at least 20% and paid. Commission is 5% of sales. 2. Compute the percent margin and the commission following the stated rule. Percent margin is sales less cost all over cost (expressed in percent).

Objective/s: Apply logical functions given certain conditions 1. Open a new workbook and type the following to the corresponding cells: Percent Invoice Sales Cost Margin Paid? Commission 00001 50000 45000 YES 00002 150000 60000 NO 00003 60000 45800 YES 00004 45000 20000 YES 00005 85000 64000 YES 00006 36000 9000 NO 00007 591000 350000 NO 00008 25000 14000 YES 00009 78000 60000 YES 00010 36000 28000 YES 00011 65000 60000 YES Note: Commission can only be availed if margin is at least 20% and paid. Commission is 5% of sales. 2. Compute the percent margin and the commission following the stated rule. Percent margin is sales less cost all over cost (expressed in percent).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

How do Excel Help in Excel program, work? What are the types of error messages we might encounter when building formulas, functions or in other areas using Excel. What is one of those messages. What is the actual error that would appear in the cell, the error message and explain what causes the error.
Problem: You work at Bark Bark Bark, a locally owned day spa for dogs. One of your responsibilities at the day spa is to manage the company’s sales and expenses using Excel. Another is to convince the current staff that Excel can help them make daily operation decisions more easily and efficiently. To do this, you decide to create charts using the previous year’s operating expenses including rent, utilities, and payroll. The manager will use these charts at the next monthly meeting
Please give me the answer with step-by-step solution Qns:Please explain to me how to create same this template in Excel and the sizes for each cloum
Provide some illustrative examples of how to rearrange the contents of the cells in Excel.
1. How many report formats are available in Excel?
Explain the five different functions available in a spreadsheet software (e.g. Google Sheet) considering five business uses in an organization (e.g. GrameenPhone). Organization: Function Business use at ….
What is linear programming, and how can it be utilized to make the best financial decisions?
To what end may I put the subtotal function in Excel?
61. An entity type is which of the following? a. A major category of data about people, place, and things b. The various departments of an organization c. The application software d. The business processes the support the mission of an organization
Please answer the Numerical Solutions problem using Fixed Point Iteration method on excel. Also give the step by step process.
Use Microsoft Visio to develop a use case and a use case scenario for making air, hotel, and car reservations for domestic travel. Also, include foreign travel. How do the use case and use case scenario change with foreign travel?
Business Modeling with Excel. Think of a feature in Excel that has caused you to say to yourself, "Hey, that's so cool!" Then, write out a thorough, step-by-step explanation of how that feature works, so that anyone reading, even someone brand new to Excel, could make it work. Feel free to add visuals like icons or screen grabs, bullet or number your steps if you like, or even record yourself performing the task. Just don't link to someone else's explanation, like we did in Help Links. This is your opportunity to teach us.