Example CS 104 Lab Test 1

For the test you will use a file that is located on the network drive. Find Network Neighborhood icon. Highlight and click on the Arthur icon. Open the CS104 folder. In the folder you will find many files. For this test you will select the file named ztest1ss. (Naturally for this lab test example, the actual file will not be found. However, you can create this file by the using the information found in the test directions. For more practice, you can do some of the other Cases and Places found at the end of each of the Excel projects.

Save the file on YOUR floppy diskette as test1.

This test will work on this file. Do as many of the following as you can in the time allotted. Do not spend too much time on any one part. Save your work often in case of a power failure or some other accident (like someone kicking the power cord).

The spreadsheet is for a small luggage shop. It includes the following columns beginning with the labels, Item in cell A1, Category, Cost, Price and Number Sold as the labels for the remaining labels in columns B1 through F1. Spreadsheet section:

1. Using the spreadsheet in the file test1, enter the a new column title Gross Profit into cell G1.
2. In row 15 add the label Prepared by: your name .
3. Add a new row to the spreadsheet in Row 9. Enter Luggage Tags for the Item, Luggage for Category, 99 cents for the cost, $1.99 for the Price and 50 for the Number Sold.
4. Create a formula for gross profit and place it cell G2. Gross profit is (price-cost) * number sold.
5. Copy the formula for Gross Profit from cell G2 to the rest of the column.
6. In E12 add a formula to sum up the number sold.
7. In F12 add a formula to add up the total gross profit.
8. Adjust the width of all columns such that all labels appear and values appear.
9. Bold only the label headings.
10. Copy the contents of worksheet1 to worksheet2. Add conditional formating to the values in number sold, so that when the number sold is greater than 100 it appears in red.
11. Add a column title Gains to cell H1. Down the column, create a formula to either display the profit when profit is positive or 0 when negative. Add up the gains.
12. Add a column title Loss to cell I1. Down the column, create a formula to either display a 0 when profit is positive or the actual loss when it is negative. Add up the losses.
13. Save the spreadsheet as test1.
14. Create a 2D pie chart using the Gains column. Use the Item column as the labels on the pie chart.

Check that you have saved both files to YOUR diskette. Exit Office. Check the directory of your diskette to see that these files are saved. Hand in the diskette plus this test. THANK YOU