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: Using the results of the preceding command as a guide, compile a complete inventory of all sales to…

A: results of the preceding command as a guide, compile a complete inventory of all sales to individual…

Q: worksheet,then create the following formulas: In cell D40 use the SUM function with a structured…

A: Formula to sum all the admission in an hospital for 2021  In cell D40, Assume that B1 to B40…

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: w an ERD & include all the entities, attributes and relationships, PKs and F

A: 1-ERD, showing the connection between one entity to every other entity, and ER diagram enables to…

Q: Why does Microsoft Access perform better than Microsoft Excel in managing data?

A: Microsoft Access: Microsoft Access is a database management system (DBMS) by Microsoft that combines…

Q: Other name of DBSN is _______________ Source Name.

A: This question wants other name of dbsn.

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: of 2 you can repres

A: Step 1: Biggest power of 2 you can represent in Excel   To specify an exponent, use the "Power"…

Q: What is data normalization? Write Advantages of Data Normalization?

A: Data normalization is a process in database design that organizes and structures data in a…

Q: Friends functions, when and how to use them, and their specifications at build and run time will be…

A: Friends functions: A buddy function, or "friend" of a particular class, in object-oriented…

Q: What are the differences between Personal, Standard, and Enterprise editions of Oracle 11g? Please…

A: Definition Oracle Database is available for various creating and deploying scenarios. Oracle also…

Q: All the following are true with respect to surrogate keys EXCEPT one. Which of the following is NOT…

A: Surrogate keys are database keys that are usually used as primary keys to uniquely identify…

Q: Name Rambutan Longan Fruit salad plant Mangosteen Snake fruit ($) Price per kg 44 34 30 25.50 21.25…

A: The excel sheet is given below with explanation and formulas

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: 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: Using data as shown above, you need to : 1)Create January to March data each from different…

A: As per our company guideline I am answering only first 3 part. Please repost others.   Creating…

Q: how can I Create 5 Functional UPDATE Statements?   Relational schema The primary key is bold and…

A: In functional update statements you cant update tables rather you can update table variables. 5…

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: 1. Create table of excel and name it as sales.xlsx. 2. By using excel form entry function, add (3)…

A: Solution: Given: Here,  Ali (1-1-1999), Abu (2-1-1999) and Ahmad (3-1-1999) have bought some items.…

Q: difference between a table and a PivotTable in Excel

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

Q: Which of these is NOT a type of relationship in a relational database? a. two-to-one b.…

A: A relational database is collection of data sets that use tables, records, and columns.A relational…

Q: a) How to import mysql databases using console sql statement? b) How is possible to start the MySQL…

A:

Q: Which MS Excel function should be used to find the first date that customer A bought bananas? Select…

A: On this Transaction table, we have to apply the condition on Customer column as it should be A and…

Q: Which of the following is NOT an advantage of DBMSs? Increased concurrency Data consistency…

A:

Q: consists of one or more columns in a table that can be used together to identify a single row in A…

A: A compound key is another term for a composite key, which is a primary key that consists of multiple…

Q: Which of the following option is correct about DBMS (Data Base Management System)? Choose an answer…

A: The data is collected from different sources. The raw facts and figures which are collected are…

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: Which of the following are true about 'test data approach'? Select the three options that are…

A: a. Test data must be representative of the conditions the auditor wants to test   c. Test data…

Q: Create a list that shows each department name, # of employees, maximum salary, minimum salary, total…

A: First EMP and DEPT tables have to join basing deptno in both.  Then group them by using dname. Then…

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: Please provide specific instances of how calls and returns fit into the larger picture.

A: In computer science, calls and returns are fundamental concepts that play a crucial role in many…

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: This does not handle the end of month processing correctly. The monthly fee should only be deducted…

A: Below is the code in java for given scenario and sample output:

Q: In excel, which of the following is an example of relative reference.

A: GIVEN QUESTION    In excel, which of the following is an example of relative reference. Select one:…