Bypass Exam - BYPASS EXAM NAME _ CSC203 SPREADSHEET...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
BYPASS EXAM NAME ________________________________________ CSC203 SPREADSHEET APPLICATIONS 1. Open the workbook Excel file located on the P: drive in the Bypass folder and the CSC 203 folder. 2. Save the workbook on your disk using your name for the file name -- save the workbook frequently as you complete the exam 3. View each sheet to become familiar with the workbook content 4. Select the Purchase Data sheet 5. Wrap the text in cells E3:F3 6. AutoFit columns A through F 7. Enter a formula in cell F4 to calculate the purchase amount 8. Copy the formula through cell F48 9. Format all dollar values in the sheet using Currency with 2 decimal places and the $ symbol 10. Center align the values in column E 11. Create a pivot table to show the total purchase amount and the number of items from each manufacturer for each location 12. Place the pivot table in a new sheet - name the sheet Pivot Table 13. Move the Pivot Table sheet after the Sales Tax sheet 14. Format the pivot table using the Report 5 AutoFormat
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Bypass Exam - BYPASS EXAM NAME _ CSC203 SPREADSHEET...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online