Case Problems

Download as a Word document: Case Problems Ch03 (7.0K)

In this exercise you will enhance the appearance of the worksheet, format numeric and date values, and print the results. Open the file EX03CP-HIBS, and immediately save it to your personal storage location as Balance. Start by formatting the Heading rows. The date in row three should be m/d/yy. Pick an attractive font, enlarge the type size and merge and center across columns A through D.

Make column A 34 characters wide, and double the row height of rows 5 and 18. Also, merge and center the labels in this row. And any other enhancements you feel would be beneficial, but don’t add so much that it detracts from the over all appearance. All the numbers which aren’t already formatted with a dollar sign, and don’t represent a date, should be formatted as comma style, and no decimals. As a quick check, all numbers in a column should have their commas line up. If the number is out of alignment, but has a comma, still format it as comma style.

Next save the sheet as a web page. Save just the selected sheet. Use the same file name, and click save. Before finishing, preview the web page.

Data File: EX03CP_HIBS (14.0K)

Roscommon Hardware and Gifts

You are to finish the Income statement for the company. File "EX03CP-RHGIS" contains the basic template. After you open the file, save it as "RHG-Income" in your personal storage area. You will need to enter simple formulas in cells E7, E11, and E12. Format the numbers correctly. All commas and or decimals should align.

Remove any rows which are not necessary. For example, row could be removed and the row height increased to maintain the white space. Remove the unnecessary columns, B and C, but widen column A to accommodate the widest label.

Merge and center the title across the columns that now contain the data (note: you should have data in three columns, A, B and C).

Set print options such that the work sheet is centered across the page when printed, and place a header which reads "Prepared By: your name" right aligned.

Preview and print the worksheet.

Save your changes and close the file, and then exit Excel.

Data File: EX03CP_RHGIS (13.0K)