1 / 13

Module 10

Module 10. Bruce, Kahea, Salynn Spring 2012 ETEC 750b. Format Headings. Does the excel example format the heading appropriately? Yes? No? Is the heading bold? Yes? No? Is the heading’s font larger then the rest of the text? Yes? No? . Check again.

dwight
Download Presentation

Module 10

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Module 10 Bruce, Kahea, SalynnSpring 2012 ETEC 750b

  2. Format Headings • Does the excel example format the heading appropriately? • Yes? No? • Is the heading bold? • Yes? No? • Is the heading’s font larger then the rest of the text? • Yes? No? Check again Check again The heading is formatted appropriately. Check again The heading is bold. The heading is larger than the rest of the font. Click to Apply Heading

  3. Format Sub-Headings • Does the excel example format the sub-heading appropriately? • Yes? No? • Is the sub-heading bold? • Yes? No? • Is the sub-heading’s font larger then the rest of the text, but smaller than the title? • Yes? No? Check again Check again The sub-heading is not formatted correctly. Check again The sub-heading is not bold. The sub-heading’s font is not larger than the rest of the text, but is smaller than the title. Click to Apply Sub-Heading

  4. Center Alignment • Does the excel example center align appropriately? • Yes? No? Check again The words are centered across the cells in the row. Click to apply Center Alignment

  5. Auto Fit Rows and Columns • Does the excel example use Auto-fit rows and columns appropriately? • Yes? No? • Can you see all text in its entirety? • Yes? Yes? No? Check again Check again The columns are not auto-fit appropriately. I cannot see the word “Wednesday”. Click to Auto-Fit Rows & Columns

  6. Copy & Paste Cells • The manager of the site wanted to copy all sites and days sales from the first table below the table • Does the excel example Copy and Paste Cells appropriately? • Yes? No? • Can you see all sites and days ? • Yes? No? Check again The example does not copy the entire table. Check again You can see all days, but not all sites. Click to Copy & Paste Cells

  7. Copy & Paste Sheets • Does the excel copy and paste sheet “Week1” to sheet “Week2” appropriately? • Yes? No? Check again Sheet “Week 1” was successfully pasted into Sheet “Week 2” Click to Copy & Paste Sheets

  8. Format Currency • Are all numbers shown as currency? • Yes? No? Check again The numbers are not shown as currency. There are no dollar signs. Click to Format Currency

  9. Auto sum formula • Does the excel example add all rows? • Yes? No? • Can you see a sum formula in the cells when pressed? • Yes? No? • ? Check again Check again The rows have not been totaled, so the auto formula could not be used. There can be no formulas within the cells since it has not been totaled. Click to Create Auto Sum Formula

  10. copy formula • Does the excel example use copy formula ? • Yes? No? Check again There are no formulas to copy, because no cells have been added yet. Click to Copy Formula

  11. Format Sales Total • Does the excel example format the total to stand out from the text? • Yes? No? • Is the sales total bold to stand out from the rest of the text? • Yes? No? Check again Check again The sales total does not stand out. The total is not bold. Click to Format Sales Total

  12. Create a complex formula • Does the excel example use a formula other than sum two cells within the sheet • Yes? No? Check again There are no complex formulas used in this sheet. Click to Apply Sub-Heading

  13. Menu D A A D A A D D A D D D D A A D A D A D A D D A D A D D A A D A D A D A D A

More Related