I need to know how to calculate the following in excel with the given data? OrderDate ProductID ProductName Quantity Unit Price Total Sales  Unit Cost   Total Cost   Profit  Profit Margin 1/4/2021 22 Mozzarella cheese 28  $                24.00 ? ? ? ? ?

Q: Write a SQL statement that displays the customer code, customer first name, customer last name and…

A: SELECT Cus_Code, Cus_FName, Cus_LName, Cus_Balance AS Amount Owed FROM CUSTOMER ORDER BY Cus_Code;

Q: Find the numbers that has not been used as DEPTNO in the DEPT table.

A: you can use this query

Q: Calculate the profit (profit) as the retail price minus the wholesale price

A: Note: Since programming language is not mentioned in the question, we will answer this program in…

Q: In the above Excel file that contains a data sheet 'Profit Goal', each quarter's net profit of 2023…

A: The question asks how to use Excel's Goal Seek feature to determine the Gross revenue needed in the…

Q: Excel: Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded.…

A: For finding out the first part of some string text , find and left function is used. For error…

Q: What was the amount of the total sale of all products (sum of quantity * price of the product) for…

A: The SQL query for the given question is provided below using the the class diagram reference.

Q: Consider the tables provided below and answer the following SQL questions: Table 1: Author…

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

Q: Given the following Staff2 table, please write a SQL statement to find the superno who supervised 4…

A: To find the superno where COUNT(superno) is greater than or equal to 4.

Q: Use the given data to classify the record below using the​ k-NN algorithm for k=1 to 5.   Loan…

A: Based on the information you provided, we can classify the record with the given loan purpose,…

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

A: the code is given below:-

Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…

A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…

Q: Check the following statement: select sysdate Today, (select count (*) from departments)…

A: Solution :

Q: use the following data to shown minimum and maximum and average of parts unit price

A: Parts table: Creating parts table: create table parts (PartNo varchar(5)  primary key,Description…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Write a SQL statement that will change the value of the Task description with ID 3 to “Add logo to…

A: We will use an update query to modify the required string.

Q: Find all manager names and all the employees each manager supervises

A: The given sample table has EMPNO as the primary key and MGR a foreign key which is refereing to same…

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: You are the manager of a Best Buy and you would like to see how much profit you made from your store…

A: The solution is given in the next step with an explanation Happy to help you ?

Q: Find the total revenue generated by each product in the past quarter (last 3 months), you would need…

A: In SQL Server, we can use the DATEADD() function to get last 3 months (or n months) records.

Q: Create a new field named Projected Sales that calculates how much each employee's sales would be if…

A: I have added the column of projected sales by 10% of sales.

Q: How do I use the subtotal function in excel?

A: The Subtotal command allows you to automatically create groups and use common functions like SUM,…