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).

Q: If you are building a small to medium sized Web site and needed a database to simply track sales and…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: Fill up the blanks with all numeric data types. Do you know how to use SQL?

A: Introduction: Given that SQL enables you to compare character values, it is possible to claim that…

Q: What is the most important thing? Join together the data.

A: In today's world, data is the new currency. Organizations of all sizes are generating and collecting…

Q: design paradigm should we employ when using Microsoft Access?

A: Which table design paradigm should we employ when using Microsoft Access?

Q: How can we figure out which model to create if we are going to use Microsoft Access as the base for…

A: Microsoft Access is a management solution for databases. It is a system for relational database…

Q: Which of these SQL clauses is most disruptive for indexes and generally affects performance most…

A: The question has been answered in step2

Q: Explain the following categories in your own words a. Window level principals b. SQL Server level…

A: To Do: To explain the principles.

Q: Identify the SQL statement used to modify the structure of the table.

A: Find the SQL statement used to modify the structure of the table.

Q: Considering the above table, what appropriate Excel function to use in finding the the difference,…

A: In this question we have to find the differences in days, between the closing date and the release…

Q: plz provied ans in excel   13.1. Using an MS Excel function, Create a List in J3 of countries in…

A: VLOOKUPVLOOKUP is an Excel function used to look up and retrieve data from a specific column within…

Q: The Car Maintenance team wants to learn how many times each car is used in every month and day to…

A: Note: I had filled the table  for reference, you have to fill according to the question reference.…

Q: 43. Which change will place this table in first normal form? A:Structuring the table to contain both…

A: First Normal Form says that any column should contain at most one value As we have multiple values…

Q: A.Write a SELECT statement to list each city and zip code in New York or Connecticut. Sort the…

A: The Database is : Student Banne It has 7 Relations/Tables COURSE, STUDENT, ENROLLMENT, SECTION,…

Q: repare the loan amortization table/schedule from scratch (not the Excel template) for a $300,000,…

A: Please refer the table we have calculated the loan value as 520000 = 650000*(1-0.80) as 20% is down…

Q: difference between a table and a PivotTable in Excel

A: What is the difference between a table and a PivotTable in Excel?

Q: Can you explain what the "subtotal" function performs and how to use it in Excel?

A: Subtotal automatically creates groups and summarizes data using SUM, COUNT, and AVERAGE. steps…

Q: Fill up the blanks with all numeric data types. Do you know how to use SQL?

A: Tip One may argue that since SQL enables you to compare character values, character values can…

Q: How can we figure out which model to create if we are going to use Microsoft Access as the base for…

A: An application for managing databases is Microsoft Access. A relational database management system…

Q: What are the applications of SQL?

A: It is a standard technology that is used by many different web platforms and web applications. It is…

Q: Question: a) new rows and columns cannot be inserted in Excel sheet once the spreadsheet is saved.…

A: Question: a) new rows and columns cannot be inserted in Excel sheet once the spreadsheet is saved.…

Q: How can one go about altering the SQL table structure? Which of these major changes should be…

A: SQL is a sophisticated language for managing and manipulating data in relational databases. It…

Q: Make a list of the many types of use cases.

A: NOTE  :-  Below i explain the answer in my own words by which you understand it well.   Whenever…

Q: Using Excel function, find the following P(Z > 0.32)?

A: Probability theory is a branch of mathematics that deals with quantifying uncertainty and predicting…

Q: Select the best answer from the given choices: Using the company schema, when creating the…

A: Actually, database is used to stores the data.

Q: Your university runs many hundreds of courses each semester and needs to keep track of key…

A: the code is given below:-

Q: 4. Which was the 1st version of SQL Server to introduce in memory capability? a) SQL Server 2005 b)…

A: Question 4. Which was the 1st version of SQL Server to introduce in memory capability? a) SQL…

Q: Which one of the following criteria is applied to make sure values are defined and used…

A: Answer :   Variable value criteria is applied to make sure values are defined and used…

Q: You are a baker, and you're using Excel to analyze this week's sales data for your bakery. Perform…

A: Please refer to the following step for the complete solution to the problem above.

Q: What filter will you use if you want more than two conditions in single run in Excel?

A: Multiple filters are to be used for more than two conditions in single run in the Excel

Q: Question 1 Sort the data on the basis of the length of the name (descending order). Nime City…

A: Note: As per our guidelines we can able to solve only three subdivisions. So, please repost the…

Q: Please elaborate on the meaning and function of an audit trail. Please provide an example of SQL…

A: An audit trail is a chronological record of activities or events in a system.It provides a history…

Q: Would you be able to explain SQL in additional detail?

A: Structured Query Language (SQL): Structured Query Language, often known as SQL, is a standardized…

Q: Describe the Excel method?

A: Excel Methods: - The MS Excel contains several formulas to use the values to perform some basic…

Q: Please provide examples for these topics. It's about SQL server. Please do it in MySQL and do it…

A:

Q: How can I make use of the subtotal feature in Excel?

A: You may use the Subtotal command to automatically construct groups and summaries your data by using…

Q: PostgreSql differs from the SQL Standard primarily by requiring which of these constructs.   a.…

A: Actually, PostgreSql is also known as Postgres.

Q: Use Microsoft Excel with table that contain any numeric data and illustrate how you can do the…

A: The following figure will show an excel sheet with numeric data, keeping record of some monthly…