#### Words of Wisdom:

"For when we die, it is not the end, but the beginning for some one else" - DEBJIT

# A Dream

1. Lucid Dreaming
waves, muscle tone and eye movements) were recorded. As soon as they became lucid in a dream, they moved their eyes in large sweeping motions left-right-left-right...
2. Frederick Douglass' Dream For Equality
Frederick Douglass' Dream for Equality Abolition stopped Frederick Douglass dead in his tracks and forced him to reinvent himself. He learned the hard central...
3. Following a Dream Toward Freedom
Following A Dream Toward Freedom Freedom has always come very easily for me. I've always had it and I've never been without it. But as I sit here thinking I...
Date Submitted:
07/14/2010 01:36 PM
Flesch-Kincaid Score:
71
Words:
1037
Flag

-------------------------------------------------

-------------------------------------------------

-------------------------------------------------
Shelly Cashman Excel Chapter 2: Lab 1 (Scenario 2)
Cafe Cabinetry
Sales Analysis Worksheet
Skills
Use Save As
Apply a theme to a worksheet
Modify column width
Modify row height
Edit text in cells
Edit numbers in cells
Enter formulas
Create a formula using the Insert Function button
Create formulas using the SUM function
Create formulas using the AVERAGE function
Create formulas using the MAX function
Create formulas using the MIN function
Center cell content
Merge cells and center their content
Set cell color
Apply styles
Change the font color
Change font size
Apply bold and italics
Format cells before entering data
Apply accounting and percent number formats
Apply date and comma number formats
Modify worksheet names
Project overview
You are an assistant in the sales department of Cafe Cabinetry, a manufacturer of custom-made cabinets for residential and commercial buildings. The sales manager asks you to create a sales analysis worksheet that displays the net sales amount and quota met for each sales region. She also asks you to calculate the percentage of sales quota met overall. The completed worksheet should look similar to the one shown in Figure 2-1.
FIGURE 2-1

STUDENT start FILE
Instructions
Open the file SC_Excel_2b_FirstLastName_1.xlsx and save the file as SC_Excel_2b_FirstLastName_2.xlsx before you move to the next step. Verify that your name appears in cell B4 of the Documentation sheet. (Note: Do not edit the Documentation sheet. If your name does not appear in cell B4, please download a new copy of the start file from the SAM Web site.)
Apply the Apex theme to the workbook by using the Themes button on the...