26-11-2012, 04:00 PM
Excel 2007 Practice Test Version
2 Excel practice.doc (Size: 57 KB / Downloads: 34)
Calculating the Cost of a Newspaper Ad
An original draft of an Excel workbook has been created for you with some of the advertising data for Your Last Name Hardware Outlet. Save this file to your disk. Open the workbook. Make the following additions and corrections:
1. Insert a row above the Third Page Row with the following information:
Size of Ad: Quarter Page
Column Inches: 5.833
Row Inches: 6
Number of Runs Per Month: 12
Color: No
2. Insert a column with the title Cost for Total Inches to the left of the column titled Color.
3. Format the column headings as follows:
• Apply the Heading 3 cell style
• Change to center alignment
• Word wrap the multiword column titles so that they display on two lines. To do this, manually widen these columns and use Alt + Enter to start the second line.
4. Assign the NOW function to Cell A3. Format it to the 3/14/2001 style and left align the date.
5. Set up formulas to perform the calculations in Columns D, F, G and I. Set up the formulas for the first ad size in Row 5 and then copy them down for each of the other ad sizes. Remember to use an absolute cell reference when referring to the ad rates provided at the bottom of the spreadsheet in Cells B16, B17, and B18. Below you will find additional instructions for each formula.