Advertisement
Guest User

anna

a guest
Sep 2nd, 2012
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Present every point in Screenshot manner . like explaining everything to a N00b . Do every single step in Microsoft Excel and Copy that screenshot in Word so it looks like A complete Screenshot working of the project in Microsoft word [With Microsoft Excel Screenshots]
  2.  
  3. Project below
  4. Display the completed workbook Lastname_Firstname_1C_GPS_Sales on the screen in MS EXCEL 2 sessions 1. Enter data or change data in a given cell. 2. Create a formula and use the SUM function. 3. Format cells with Merge & Center and cell styles. 4. Insert a column chart into the worksheet. 5. Create Spark lines for a range of cells. 6. Display the Print Preview and Document Properties. 7. Save your work to a file (using Save or Save-As). • Navigate a workbook • Enter values and labels • Change column width and row height • Use formulas • Edit a worksheet • Change alignment and number format • Change fonts, borders, and shading • Add headers and footers • Understand and plan a chart • Create a chart • Move and resize a chart and chart objects • Apply chart layouts and styles • Customize chart objects • Enhance a chart • Create a pie chart • Add text and print charts • Preview and print a worksheet
  5.  
  6. Display the completed workbook Lastname_Firstname_2C_Sauces_Inventory on the screen. 2 sessions 1. Create formulas using the SUM, AVERAGE, MEDIAN, MIN, and MAX functions. 2. Apply cell styles, increase or decrease decimal places. 3. Apply conditional formatting. 4. Create formulas using the COUNTIF or IF functions. 5. Create formulas using Date and Time functions. 6. Freeze or unfreeze panes. 7. Create sort, and filter an Excel table
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement