Microsoft Office Tutorials and References
In Depth Information
In the Lab
8. One at a time, merge and center the worksheet title and subtitle across columns A through F.
Select cells A1 and A2 and change the background color to light blue (column 7 in the Standard
Colors area in the Fill Color gallery). Apply the Title cell style to cells A1 and A2. Change the
worksheet title in cell A1 to 28-point white (column 1, row 1 on the Font Color gallery). Change
the worksheet subtitle to the same color. Assign a thick box border to the range A1:A2.
9. Center the titles in row 3, columns A through F. Apply the Heading 3 cell style to the range A3:F3.
Use the Italic button (Home tab | Font group) to italicize the column titles in row 3 and the row
titles in the range A10:A12.
10. Assign a thick box border to the range A10:F12. Change the background and font color for cell F12
to the same colors applied to the worksheet title in Step 8.
11. Change the row heights of row 3 to 36.00 points and row 10 to 30.00 points.
12. Assign the Accounting number format to the range B4:F4. Assign the Comma style format to the
range B5:F9. Assign a Currency format with a l oating dollar sign to the range B10:F12.
13. Rename the sheet tab as Start-Up Financing Needs. Apply the Light Blue color to the sheet tab.
Change the document properties, as specii ed by your instructor. Change the worksheet header
with your name, course number, and other information as specii ed by your instructor. Save the
workbook using the i le name Lab 2-1 Part 1 Electry Auto Start-Up Financing Needs. Print the
entire worksheet in landscape orientation. Next, print only the range A3:B9.
14. Display the formulas version by pressing ctrl+accent mark ( ` ). Print the formulas version
using the Fit to option button in the Scaling area on the Page tab in the Page Setup dialog box.
After printing the worksheet, reset the Scaling option by selecting the Adjust to option button on
the Page tab in the Page Setup dialog box and changing the percent value to 100%. Change the
display from the formulas version to the values version by pressing ctrl+accent mark ( ` ). Do
not save the workbook.
15. Submit the revised workbook as requested by your instructor.
Instructions Part 2: In this part of the exercise, you will change the revenue amounts until the lowest
ending balance is greater than zero, indicating that the company does not require i nancing in its i rst
six months of operation. Open the workbook created in Part 1 and save the workbook as Lab 2-1 Part 2
Electry Auto Start-Up Financing Needs. Manually increment each of the six values in the revenue
column by $1,000.00 until the lowest ending balance in cell F12 is greater than zero. The value of cell
F12 should equal $5,000.00 All six values in column C must be incremented the same number of times.
Update the worksheet header and save the workbook. Print the worksheet. Submit the assignment as
specii ed by your instructor.
Instructions Part 3: In this part of the exercise, you will change the monthly costs until the lowest
ending balance is greater than zero, indicating that the company does not require i nancing in its i rst
six months of operation. Open the workbook created in Part 1 and then save the workbook as Lab 2 – 1
Part 3 Electry Auto Start-Up Financing Needs. Manually decrement each of the six values in the costs
column by $1,000.00 until the lowest ending balance in cell F12 is greater than zero. Decrement all
six values in column C the same number of times. Your worksheet is correct when the lowest ending
balance in cell F12 is $5,000.00. Update the worksheet header and save the workbook. Print the
worksheet. Submit the assignment as specii ed by your instructor.
Search JabSto ::




Custom Search