Create a new workbook as shown below and save the file with the name “Call Statistics". Panda EST 2 Monthly Sales Report - July 3. 4 Emp. No. Name 5 5101 6 S105 7 S112 8 S107 9 S110 10 S103 Salary Sales Amount Total Salary Ahmed Hassan Ali Waleed Comission 2500? 3000 2200 4500 3500 1600 1800 1500 2000 Mohammed 1700 Samir 1600 2500 11 Totals Average Highest Lowest Count 12 13 17 14 17 15 16 a) Create the worksheet shown above. b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15, Columns E & F: 14. c) Enter the formula to find COMMISSION for the first employee. The commission rate is 2% of sales, COMMISSION = SALES * 2% Copy the formula to the remaining employees. d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY= SALARY + COMMISSION Copy the formula to the remaining employees. %3D e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy the formula to each column. f) Format numeric data to include commas and two decimal places. g) Align all column title labels horizontally and vertically at the center. h) Create a Header that includes your name in the left section, page number in the center section, and your ID number in the right section. i) Create footer with DATE in the left section and TIME in the right section. j) Save the file with name panda EST.

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: List the isbn of the book, the id and firstname of the editors. Include all books in the bookeditor…

A: Script to List the ISBN of the book, the id, and first name of the editors mentioned in step 2, and…

Q: What type of references remain constant, no matter where they are copied? Relative Mixed Absolute…

A: "References" refer to cell references within a spreadsheet, particularly in the context of formulas.…

Q: If you can't remember where the update.txt file is on your machine, print it out.

A: As a subject matter expert, I understand that locating a specific file on a computer system can…

Q: Assume that there are 12 records in training data and there are three classes: C1, C2, and C3. Write…

A: We need to find the number of records in each class so that the Gini index is maximum.

Q: List the item ID as ITEM_ID and description as ITEM_DESC for all items. The descriptions should…

A: Below is the query to get the desired output:

Q: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in…

A: It enables to save query with a name so that it can be executed whenever required rather than…

Q: If you do not know the location of the update.txt file on your computer, print a copy.

A: Here we have given complete solution to know the location of update.txt file and print the text…

Q: Answer the following questions then copy your code to a text document (with print screens) and…

A: As per our guidelines we are suppose to answer only first three questions. Kindly repost other…

Q: Use the HOL Small Company ERD and HOL Small Company Details xlsx to complete the steps listed below.…

A: 1. Write CREATE TABLE statements to create the tables listed below. Do not include constraints…

Q: Jump to level 1 CREATE TABLE Country ( Name VARCHAR (60), Population INTEGER, Over 65 PopPct FLOAT,…

A: The question is asking about the values of certain columns in a database table named 'Country' for a…

Q: We have discussed greedy algorithm during lectures. A greedy algorithm is an algorithm that…

A: ANSWER:-

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001',…

A: Attached handwritten Image of the procedure  to add a row to the INVOICES table.

Q: Property Number PG4 Property Address Inspection Date Inspection Time 18-Oct-2014 10:00 15-April-2015…

A: Normalization:- Normalization is a process used to organize data in a database. It is the process of…

Q: Write a script that creates and calls a stored procedure named spInsertDepartment. First, code a…

A: Answer : Stored Procedure : /*creating stored procedure*/create procedure…

Q: Create a PL/SQL anonymous block to insert a new project in DoGood Donor database. Create and use a…

A: The question asks you to create a PL/SQL anonymous block to insert a new project into the DoGood…

Q: Chapter 34 Custom Exercise: Create a JavaFX GUI that allows the user to retrieve records from the…

A:

Q: Task 9: Create the DISP_PROPERTYS procedure to retrieve and output the office number, address,…

A: Given Procedure name is DISP_PROPERTYS Suppose the relation name is PROPERTY and the attribute…

Q: Open the start file EX2019-ChallengeYourself-6-3. The file will be renamed automatically to include…

A: Solution a) Go to cell C10 enter the following formula =AVERAGE(C8:C9)

Q: Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a…

A: Question given:  A excel table is given. This table stores project details. Create a formula using…

Q: Please write a view  to list staff’s names, salary, ages, and their supervisors’ names, salary, and…

A: To list staff members and their supervisors meeting the given criteria, you can create a SQL view…

Q: Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the…

A: Given : Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of…

Linux

An operating system (OS) is the software which manages hardware and resources, like CPU, storage and memory. The OS bridges the applications and hardware and makes the connections between all of your software and the hardware resources.