accounting 306( Micro app for accounting)
chang2014
excelhomework.docxA.
1. Open and rename the workbook file.
a. Press Ctrl+O to display the Open area.
b. Locate the folder where your files are located.
c. Open the workbook file WearEverShoes-1 . xlsx .
d. Press F12 and locate the folder where your files are saved.
e. Save the workbook as [your initials] Excel 1-3 .
2. Click the Themes button [Page Layout tab, Themes group] and choose Ion from the gallery.
3. Increase column width.
a. Select A4:I12.
b. Click the Format button [Home tab, Cells group].
c. Select AutoFit Column Width.
4. Apply Cell Styles.
a. Select A1, click the More button [Home tab, Styles group], and select Title in the Titles and
Headings category.
b. Select A3, click the More button, and select Heading 2 in the Titles and Headings category.
c. Select A4:A12, press Ctrl, and select B4:I4.
d. Click the More button and select 40%- Accent 1 in the Themed Cell Styles category.
e. Select B5:I12.
f. Click the More button and select 20%- Accent 2 in the Themed Cell Styles category.
5. Apply Merge & Center to the title and subtitle of your worksheet.
a. Select A1:I1 and click Merge & Center [Home tab, Alignment group].
b. Select A3:I3 and click Merge & Center.
6. Apply formatting.
a. Select the cell range A4:A12, press Ctrl, and select B4:I4.
b. Click the Font size drop-down list [Home tab, Font group] and select 12 pt.
c. Click the Font type drop-down list [Home tab, Font group] and select Trebuchet MS.
d. Select A4:I4 and click the Center button [Home tab, Alignment group].
e. Select I5:I12 and click the Center button [Home tab, Alignment group].
f. Select E5:E12 and click the Increase Indent button [Home tab, Alignment group].
7. Use the Fill Handle to copy a formula.
a. Click H5.
b. Point to the Fill Handle in the lower right corner and drag the fill pointer to H12.
8. Apply numeric formatting and adjust column width.
a. Select F5:H12.
b. Click Comma Style [Home tab, Number group].
B.
1. Open the workbook file BlueLakeSport-1 .xlsx .
2. Save the presentation as [your initials] Excel 1-4 .
3. Apply the Slice theme to the worksheet.
4. Edit worksheet data.
a. Edit the title in A1 so that the word “Sports” contains an apostrophe and appears as follows: Sport’s.
b. Edit the value in cell B6 to 5102.
5. Merge and center the title in cell A1 across the cell range A1:H1, and merge and center the date in
cell A2 across the cell range A2:H2.
6. Delete row 8.
7. Use the Fill Handle to complete a series.
a. Select B4.
b. Use Fill Handle to add headings for columns C:H.
8. Apply Cell Styles to the labels in the spreadsheet.
a. Apply the Title Style to A1.
b. Apply the Heading 1 style to the subtitle in A2.
c. Apply the 20%- Accent 1 themed cell style to B4:H4 and A4:A8.
d. Apply the 20%- Accent 3 themed cell style to B5:H8.
e. Select A3:H3, and apply the Heading 1 style.
9. Format cell contents.
a. Increase the font size of A4:H8 to 12 pt.
b. Select A5:A7 and click the Increase Indent button.
c. Apply the Comma format to cells B5:H8.
10. Use AutoSum and the Fill Handle to calculate daily totals.
a. Use AutoSum to create a Sum formula for B8.
b. Use the Fill Handle to copy the formula in B8 to cells C8:H8.
C.
D.
E.
F.
G.
H.
