Microsoft Office Tutorials and References
In Depth Information
To complete this task:
1. Open the Blades1 workbook located in the Tutorial.03\Cases folder included with your
Data Files, and then save the file as Blades2 in the same folder.
2. Enter your name and the current date in the Documentation sheet, and then switch to
the Sales worksheet.
3. Change the font of the title in cell A1 to a 16–point, dark blue, boldface, Times New
Roman font. Change the subtitles in cells A2 and A3 to an 8-point, blue font. Reduce
the height of row 2 and row 3 to 12 characters.
4. Add a solid black bottom border to the range A1:K1.
5. Format the text in cell A5 in a 12-point, blue, Arial font. Vertically align the text in
this cell with the bottom of the cell.
6. Merge the cells in the range A6:A10, and align the contents of the cell vertically at the
top of the cell. Repeat this for the following ranges: A11:A15, A16:A20, and A21:A25.
7. Change the background color of the cell range A6:I10 to light yellow. Change the
background color of the range A11:I15 to light green. Change the background color
of the range A16:I20 to light turquoise. Change the background color of the range
A21:I25 to pale blue.
8. Reverse the color scheme for the subtotal values in the range B10:I10, so that instead
of black on light yellow, the font color is light yellow on a black background. Reverse
the subtotal values for the other products in the table.
9. Apply the borders, as shown in Figure 3-42, to the cells in the range A6:I25.
10. Rotate the column titles in the range C5:I5 by 45 degrees. Align the contents of each
cell along the bottom-right corner of the cell. Change the background color of these
cells to white, and then add a border to each cell.
11. Open the Options dialog box from the Tools menu. Deselect the Row & column
headings and Gridlines options to remove the row and column headings and grid-
lines from the Sales worksheet window.
12. Set the print area as the range A1:K25.
13. Leave the page orientation as portrait, but center the worksheet horizontally on the page.
14. Create a custom footer with the text “Filename: the name of the file ” left-aligned and
with the text “Prepared by: your name ” and “ the current date ” right-aligned, with
your name and date on separate lines.
15. Preview the worksheet and then print it.
16. Save your changes to the workbook and then close it.
Case Problem 4
There are no Data Files needed for this Case Problem.
Oritz Marine Services Vince DiOrio is an information systems major at a local college.
He works three days a week at a nearby marina, Oritz Marine Services, to help pay for his
tuition. Vince works in the business office, and his responsibilities range from making cof-
fee to keeping the company’s books.
Recently, Jim Oritz, the owner of the marina, asked Vince if he could help computerize
the payroll for the employees. He explained that the employees work a different number
of hours each week at different rates of pay. Jim now does the payroll manually, and finds
it time consuming. Moreover, whenever he makes an error, he is annoyed at having to
take the additional time to correct it. Jim is hoping that Vince can help him.
Vince immediately agrees to help. He tells Jim that he knows how to use Excel and that he
can build a worksheet that will save him time and reduce errors. Jim and Vince meet to
review the present payroll process and discuss the desired outcome of the payroll spread-
sheet. Figure 3-43 displays the type of information that Jim records in the spreadsheet.
Using Figure 3-43 as a
guide, test your knowl-
edge of formatting by
creating your own
design for a payroll