1 / 18

EXCEL 2007

EXCEL 2007. Part 2. This Lesson. Enter formulas Select Cells Format Cell Contents Insert Borders Standard Error Values & How to Correct Format Numbers. Ribbon Groups Used – Home TAB. Border. Character Formatting. Comma Style. FoRmulas – arithmetic symbols. Focus on ‘sums’ + add

sakina
Download Presentation

EXCEL 2007

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. EXCEL 2007 Part 2

  2. This Lesson • Enter formulas • Select Cells • Format Cell Contents • Insert Borders • Standard Error Values & How to Correct • Format Numbers

  3. Ribbon Groups Used – Home TAB Border Character Formatting Comma Style

  4. FoRmulas – arithmetic symbols • Focus on ‘sums’ • + add • - subtract • * multiply • / divide • () brackets

  5. New Spreadsheet

  6. SELECTING CELLS • Whole Spreadsheet • Row/Column Headers • Click & Drag / Click & Shift • Click + Ctrl

  7. Simple Formattiing • Bold • Italic • Underline • Single • Double • Make the headings bold • Try it by selecting cells A1 – G1

  8. INSERTING A BORDER • Add borders to CellsA4, C4, E4 and G4 • Hint = Click + Ctrl • Change colour of border to RED

  9. FORMULAS • Entered using cell references • Always start with an equals sign (=) • =A2+A3 • =C2-C3 • =E2*E3 • =G2/G3

  10. FORMULAS • Delete all of the formulas • Now enter pointing the mouse • Type = • click on cell A2 • Type + • Then click on cell A3 • Now enter the remaining formulas using the point method

  11. FORMULAS – automatic recalculation • Change cell A2 to 75. What is the answer? • Change some of the other values.

  12. Standard error values • Delete the contents of cell C2. • What is the answer in cell C4? • Change the value of cell G3 to 0. • What is the answer in cell G4?

  13. Standard error values • #VALUE! • Indicates Excel cannot calculate the formula • Calculation on non-numeric value • #DIV/0! • Divide by 0 = infinity

  14. Standard error values • ##### • The cell contents cannot be displayed because the column is too narrow. • #NAME? • Excel does not recognise text in a formula. • #NUM! • Invalid numeric values are used in a formula. • #REF! • Cell referred to in a formula is deleted. • A space is a text (non-numeric) character even though it is invisible.

  15. FORMATTING NUMBERS • Numbers can be formatted various ways, e.g. using a comma to indicate thousands: • 1,532,000 is easier to read than 1532000 • Click cell A2 and drag across to cell G4. • Right click Format Cells dialogue box • Click the Number tab and select Number from the category list. • Click the check box for Use 1000 Separator (,). • Click ok • Try entering a number greater than 1000 to see how it is displayed.

  16. Helpful number formatting hints • You can also use the Comma Style button in the Number group on the Home ribbon. • You can also use the features in the Format Cells dialogue box to format numbers as currency or percentage. • You can use the Decimal places box to set how many decimal places numbers are displayed to.

  17. ASK YOURSELF • Do I know what an Excel formula is? • Do I know the basic arithmetic symbols used by Excel? • Can I enter a formula in a worksheet cell? • Do I know the different ways to select cells in a worksheet? • Can I apply simple formatting in a worksheet cell? • Can I add borders to a worksheet cell?

  18. ASK YOURSELF • Do I know what Excel’s standard error values mean? • Can I apply different formats to numbers and do I know what they mean? • You now know the following buttons: • Bold • Border • Italic • Underline • Comma Style

More Related