{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

LabFinalSample - the chart title “Commission on Sales”...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CS110 Lab Final – Sample 5) Excel 5 a) Create the spreadsheet Excel.xls shown below (Background color is optional, text style is not ): Then, enter a formula to compute the Commission Rate (6% if sales > 27,500; otherwise it is 4%) and the Commission (Sales times Commission Rate). Gotham Car Sales 1st Quarter Sales and Commissions Report ID Salesperson Sales Commission Rate Commission 1 Akerman, Ed $16,500.00 2 Baker, Missy $29,700.00 3 Danforth, Hal $45,900.00 4 Douglas, Pete $18,000.00 5 Gordano, Vinnie $25,900.00 6 Gregory, Allison $23,000.00 7 Jordan, Jennifer $5,000.00 8 Montgomery, Lance $33,000.00 Average b) Use currency format with 2 decimal places for Sales and Commission columns and format the Commission Rate as a percent. c) Compute the average of all columns and enter them in the last row. d) Create a chart of type Column like the one below, showing both the ID versus the Commission. Make
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the chart title “Commission on Sales” followed by your name . Save the file as carsales.xls (make sure you know where you save the file to: Q5 ) then print a copy of it. 6) Access 6 a) Create a new database on your disk, named midterm.mdb, using MS Access. In the design view, specify the following fields for a table named Students: Field Name Field Type Field Size Name Text 12 Class Text 6 Grade Text 2 Year Number Integer b) Input the following data: Name Class Grade Year Alice CS110 B 2006 Alice CS401 A 2005 Alice CS131 B-2005 Bob CS401 C 2006 Carol CS110 A+ 2006 Carol CS131 B 2004 Dan CS110 B-2004 Dan CS1501 B 2005 c) Create a query to find all people who took CS110 in 2006. Have it return just their names and grades. Save the database inside the folder Q6. Print a copy of the query results....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online