Spell-Check

1. Spell-Check • Dictionaries are a common feature of suites of office products such as Microsoft Office 2007 • Useful but can not replace your brain – Spell-checking is not Artificially Intelligent • Eye halve a spelling check her;It came with my pea sea.It plane lee marks four my revueMiss steaks aye kin knot sea. Butt now bee cause my spellingIs checked with such grate flare,Their are know faults with in my cite,Of nun eye am a wear!

2. Spell-check • To Spell-check a worksheet select Spelling from the Proofing group of the Review tab on the Ribbon • Note other options

3. Inserting Text Boxes • Text can be inserted into a worksheet within a text box. • Choose Text Box from the Text group of the Insert tab on the Ribbon • Creating Text Boxes allows you to add text passages of any size and appearance without the constraints of a cell in the worksheet. • A Text Box is an independent object which you can use to reference data without affecting the data.

4. Adding Comments • A comment is a note that can be attached to a cell. • They are hidden from view until the mouse pointer is over a cell that contains one. • Useful for documenting information and making notes. • Choose New Comment from the Comments group of the Review tab on the Ribbon and type your comment into the block that appears

5. Joining Cells • Joining the contents of two or more cells together is called concatenation and uses the & operator • =A1&A2 would give a result of • =A1 & A2 would give a result of • =A1&“ ”&A2 would give a result of • =A1& “, ”& A2 would give a result of JohannesburgGauteng JohannesburgGauteng Johannesburg Gauteng Johannesburg, Gauteng

6. Print Preview (1) • Accessible from the Office button  Print  Print Preview

7. Print Preview (2) Change to A4

8. Print Preview (3)

9. Print Preview (4)

10. Print Preview (5)

11. Printing • Use the Print Option in the Office button menu, or the print button on the Print group of the Print Preview tab

12. Printing • Select the correct Printer, Print range, Selection etc. • If you want to print only a part of the spreadsheet, highlight that area first and choose Selection from the Print What area

13. Simple Calculations • Excel can be used as a simple calculator by typing numbers in directly • Every calculation in a spreadsheet must start with an = sign

14. Section 4 –Manipulating Data: Formulas • Doing simple calculations on a spreadsheet directly does not take advantage of Excel’s ability to adjust the results of calculations to changing values. • Thus we use cell references, e.g.

15. Seeing your Formulas • The results of the formulas are worked out as soon as you press enter and you only see the answer. To view formulas rather than results, press the Crtl key and the tilde key on your keyboard at the same time • Doing this again will redisplay results • Printing will print what you see on the screen so if you are asked to hand in a formula-printout you need to print from formula view Tilde + Ctrl

16. Order of operation ( ) Brackets : , Reference operators – Negation (as in -1) % Percent ^ Exponentiation * / Multiplication and division + – Addition and subtraction & Connects two strings of text (concatenation) = < > <= >= <> ComparisonLeft to Right order of decreasing importance

17. What’s the answer? = (21 / 3) * 5 + 6 / 6 / 5 = 7 * 5 + 6 / 6 / 5 = 35 + 6 / 6 / 5 = 35 + 1/ 5 = 35 + 0.2 =35.2

18. Editing Formulas • Once you have entered a formula, if you need to correct the entry clicking on the cell and typing will overwrite the previous content (as with any data). • To just correct a formula in a cell either: • highlight the cell as normal but make the correction in the formula bar, or • double click on the cell to change to editing mode • If you make a mistake, remember that you can undo it using the undo button on the Quick Access toolbar

19. Powers and Roots • To raise a number to a power (e.g. 2 to the power of 4) use the ^ symbol • To work out a square root use the SQRT function • To work out other roots (for example the cube root of 216 ), raise the number to one over the root you want

20. AutoSum • To calculate a total of a column of numbers quickly, highlight the numbers to be added including the cell directly below the column, and click the AutoSum button • The AutoSum button is on the Formula tab of the Ribbon, in the Function Library group

21. Copying formulas (1) • Formulas should use cell references • Such formulas can be copied to other locations where the cell references will be translated (i.e. they will be adjusted) relative to their new positions • This is called relative addressing • Can copy using copy and paste or using AutoFill (when copying across a row or down a column)

22. Copying formulas (2) • Relative addressing can be very useful, for example, when calculating totals for a series of months, as it allows you to just copy formulas across

23. So, what happens here? =(B2+C1)*B4

24. How to work it out • Cell references will change when you copy a formula. What they end up as depends on where you paste the formula to! • To work it out: • First consider horizontal movement (across) • Do column arithmetic • E.g. if you move across (to the right) 2 cells from column A, A + 2 is C (think ABC) • E.g. if you move across (to the left) 2 cells from column D, D - 2 is B (think DCB) • Then consider vertical movement (up or down) • Do row arithmetic • E.g. if you move down 2 cells from row 3, 3 + 2 is 5 • E.g. if you move up 2 cells from row 8, 8 - 2 is 6 - (Subtract) + (Add) - (Subtract) + (Add)