SpringLeaf Designs: Formatting, Formulae, and Charts
PROJECT DESCRIPTION
Christy Chen works at SpringLeaf Designs, a Seattle-based company that makes jewelry and accessories out of recycled materials. Christy has created a workbook to analyze costs and profits by product line. She has also compiled sales forecasts for the next five years. She has asked you to complete the data entry and analysis and to format the worksheets so they have a consistent and professional look.
GETTING STARTED
Download the following file from the SAM website:
IL_Excel2013_CS_P1a_FirstLastName_1.xlsx
Open the file you just downloaded and save it with the name:
IL_Excel2013_CS_P1a_FirstLastName_2.xlsx
Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.
With the file IL_Excel2013_CS_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. Switch to the Sheet1 worksheet. Make the following formatting changes:
a. Merge and center the range F3:I3. Apply the Heading 2 cell style to the merged cell and change the fill color to Blue, Accent 5, Lighter 60% (9th column, 3rd row in the Theme Colors palette). Replicate these formatting steps for range C3:E3.
b. Make the fill color of the range B19:I19 White, Background 1, Darker 35% (1st column, 5th row in the Theme Colors palette).
c. Add a Thick Box Border around the range B2:I19.
d. Add a Left Border to the ranges C3:C19 and F3:F19.
2. Make the following formatting changes to the range C4:I4
a. Change the font to Verdana.
b. Change the font color to Blue-Gray, Text 2 (4th Column, 1st row in the Theme Colors palette).
c. Change the font size to 10 pt.
d. Apply Bold formatting.
e. Center align cell contents.
f. Apply text wrapping.
3. Apply Bold formatting to the ranges B19:C19 and E21:E23.
4.
Christy Chen works at SpringLeaf Designs, a Seattle-based company that makes jewelry and accessories out of recycled materials. Christy has created a workbook to analyze costs and profits by product line. She has also compiled sales forecasts for the next five years. She has asked you to complete the data entry and analysis and to format the worksheets so they have a consistent and professional look.
GETTING STARTED
Download the following file from the SAM website:
IL_Excel2013_CS_P1a_FirstLastName_1.xlsx
Open the file you just downloaded and save it with the name:
IL_Excel2013_CS_P1a_FirstLastName_2.xlsx
Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.
With the file IL_Excel2013_CS_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. Switch to the Sheet1 worksheet. Make the following formatting changes:
a. Merge and center the range F3:I3. Apply the Heading 2 cell style to the merged cell and change the fill color to Blue, Accent 5, Lighter 60% (9th column, 3rd row in the Theme Colors palette). Replicate these formatting steps for range C3:E3.
b. Make the fill color of the range B19:I19 White, Background 1, Darker 35% (1st column, 5th row in the Theme Colors palette).
c. Add a Thick Box Border around the range B2:I19.
d. Add a Left Border to the ranges C3:C19 and F3:F19.
2. Make the following formatting changes to the range C4:I4
a. Change the font to Verdana.
b. Change the font color to Blue-Gray, Text 2 (4th Column, 1st row in the Theme Colors palette).
c. Change the font size to 10 pt.
d. Apply Bold formatting.
e. Center align cell contents.
f. Apply text wrapping.
3. Apply Bold formatting to the ranges B19:C19 and E21:E23.
4.