Strand 2 } Productivity software Sub-strand 2.1: Introduction to Word Processing Sub-strand 2.2: Introduction to Presentation Sub-strand 2.3: Introduction to Electronic Spreadsheetoa — pee : Sub-strand 2.1: | all d Processin; Coe ee software ction to Wort Introd B7.2.1.1.1. Importance of word processin: Pvvora processing, ‘Word Processing s the process of ereating program that provides for input, ed additional features such as the use of Pi processing software is Microsoft Word, Microsoft Word allow users and move text. ccontenstaner B7.2.1.1 Demonstrate how to use Con * Demonstrate how to find and replace content and undo edited ching, Examples of Word processing programs Demonstrate how to spell check, content translation, language saya, The best-known ‘word processing program is Microsoft Word, but there are ‘others, such as Corel WordPerfect, OpenOffice Writer, Apple Pages, Google Does, Zoho Writer, ‘AbiWord, LibreOffice Writer, NotePad, WPS office and WordPad. iments, A word processor isa computer fo ften with some res, tables and charts. One of the popular word ct, delete Microsoft Word (Es “ave and print documents you need a word processing ing right now was also created using a word &27 Teaching strategy The focus of this lesson is skill developm: computer laboratory. Learners should be i functions of the various commands, The facilitator should show projected = * saving and print MS-Word interface with the aid of a computer, projector or pictures. Gut ¢ moving and deleting text within a document. which requires hands-on Ee iced to the MS Word inteast- Word process ing. explore tools for editing in MS word. Demonstrate how to use find and rp content translations and language settings in MS Word. on - editing tables. inserting elements from other software, such as illustrati Correcting spelling and grammar, as illustrations or photographs. WB snensan wortinerac en you open Microsoft Word 2016 for the first A sn you open Mito t time, the Start Seren will appea igure below. From here, you will be able to ieee : il create anew di es ek eee soso te mae = pleat Screen se ft Word interface as inthe figure be a low.‘Quick Access Toolbar Boge os reunion of tami members, ria {i Uno, quate and micunGarstanaene are Sees = ‘Eronomlcaty binge moe! of me citzens together which Neles them to inate evelopment projects and’ to canibite’franialy Coors Base Srerant Suture heritage of the people ix Ueuy mariteatec duc View buttons Zoom contol MS Word window interface a copy of your document using Sa save the document for the file. The Save as comman made to a document as a di the document, when you sw Entering text MS Word document c objects. We can enter How to type text in a word documen 1. Start MS Word. By default, a new document will open. res chart, pict! alogue box as shown below: 58pointing You can also us _|CTRL+A. ‘apply any format to text in word document, you need 1 below shows various ways of selecting text using the mouse an Word ‘The Backspace and Delete keys are used to remove or delete text from a word document, ‘The table below shows various ways of deleting text in a word document. the Backspace key. iext using the backspace key, move the insertion poi ‘want to delete and press the backspace key from your keyboar text to the left ofthe insertion point. to after se Ctrl + Backspace to delete a whole word. To do this, move the Her the word you want to delete and press Ctrl + backspace key from ete the whole word to the left ofthe insertion point,| amonlon testes recolour ane iran pat oth cut, ce eer Smaarasre | | aa ty Ga a nam eit | = Parts off computer seta els eon of tanty member, lathes and ve ones, A Insertion point {hein guste end minders rected xt by selecting the text and pressing Backspace or Delete key. 2. Move your cursor where you want the texts to go, and then paste it in by pressi shi ‘move text in our document. The following are some of the methods we can used tot " fa Festivals In Ghana ie E Ghanaian festivals are a colourful and vibrant part of the culture. Each Method 1: Cut & Paste the Selected Texts E You festa and curbars are held vaio pate of te coun ‘way is to cut and paste the selected texts in our document 5 Gelert te hertage ‘eeuha ne yar stale ad ctr re ein various pars of ie |: ine cnt ft Tenien, deveopmant purposes and Te stengtien Importanc of Festvals Historically makes the people know more about their history, maa rsuanserraa See eae Eetgutuaancatnnaesseeen Socal Ie eres as usin of amity mem Tote, oan Fenty mens, raves and ov ones. A ings ere seed, 63 enablera wmenmaencnctenmaceens Eee er] =<]eer eS Using overt Overtype option Overtype is a Turn on Overtype mode Using options + Tose Insert key to control Overtype mode, select the Use Inset ey overtype check box. + To keep Overtype mode enabled always, select the Use overtype mode check box. ie es 7 x = [fae 4, Click OK Using the Status bar ext to the selection. 2, Click "Overtype” to add k next to the sel enable Overtype Mode or "Overtype” 10 turn the ¢ current typing mode. 3 feature of tmporance of Festa a Site ponte know mor about he socity enon of fay mabe a toe Sarat amended” _ i Herm ge ane ts any of the methods discussed above. ‘elebrations” it deletes “Festivals” sar aclu an vantprol cute. 20h ‘dubars ar ald invaous pr tha couny eA gos ‘When overtype mode is active and you type a le the insertion point. Ghanaian otal ar a clout and vibrant par of year fesvals and durbars are hold i varous pats letter to the right of 67_— Insert option is Fir \d Replace in word yrocessing? Te etaec alos : hange words or sentences that have been us In contrast to overtype is the Fr it Find and replace isa tool used to locate and < throughout the aie Jocument. We can find and replace a word when by using the Fi and Replace options. 1. Click the Find option on the Home tab in the Editing group. See figure below. This will open the navigation pang. (Cagireevssmoum 2. Type the word you want to find inthe search box. For example, type “People”. You «will find thatthe specified word is highlighted in the document. When insert mode is active and you type a letter, it moves the letter to the right fs, insertion point, a7 the arrow next to the Find opti . cin Se on ig group and This feature is known as Find and Replace, The Find and Replace options #*' on the Home tab in the Editing group.have learnt how to use these options: Now that we Let use the document on “Fe: Ghana” logue box ‘and Go To as seen the dialogue, Paciecleac expel btee at fecal ham gn cov ane ih es perl te er a psecon Festa a oa Diener eemnaur tahoe | Sitcanrce soe: Importance of Festivals Historical Imokes te people know more abut tei istry. I anes run tami ments relatives, Sue Sunaina we seae | Kang moet oft ans oper | sich 1 bina mf cons Woot wtih tes een ee ised when we want to move to a specific location in a word dos cument, you type 200i" Supposing we want to find the word “People” in this steps. in 1. Click in the Find i and Rep! 2. In the Find What textbox, type the word you want to fi bee le. camene See aerrsen Teese! —_<0--) 5 —— i SN‘Besar nol sma ‘earn cnc aoe, mgoance of Fesuas tony Saceaerecene eee Ceo eo ex HS ee at sas apa ge ose bande [ites GRASS row mre aout histo. ‘When all the words are replaced, word displays these not Mie Wet X ]| micros Wort @ wrremanesarang ne cca areas ‘mre tices: x Ce 7. Click Yes and then OK.Wile Find and Replace dialogue bos, if we click on the Replace An jy, Word simply re instances replace: Word displays the messages as shown below: Mize Wd X | rics or @ rece ‘Alldone. We made omen sensnenranns || O snc Ges) Get oe oy WWMbe,’| How to run the spelling and grammar checker the Review tab on the ribbon. Pr oon ‘group, click on Spelling & Grammar. You ide of the window. Click Yes and then OK. B7.2.1.1.3. How to spell check, content transla When you are typing a document in Microsoft Word, you will notice underlined with wavy red or green lines. Campute speling error There is three ICT tools here \ ‘ord error the user's duty to check and be sure of the spi suggestions given by MS Word. 1g before accepting id grammar check ords in the computer suggestions to correct the spelling or grammatical error. The spe is a flexible tool that automates the task of proofreading, 14 in that the word is wrong ry of the computer. Th orDmiuitiptec ice Questions |. Which of the f lowing software is a word Processing software? A. MS PowerPoint B. MS Windows : C.MS Excel D. MS Word 2. Commands for editing and formatting text are found on A. Home tab B.Inserttah —_C. Design tah, *. The page colour and page border commands are found on A. Home tab B. Insert tab, Design tab +. Which of the following keys deletes text A. Backspace key Which of the following keys A. Backspace key to the left of the ins B, Delete key B.Deletekey —_C. Insert key QWrncory - (a) What is a ribbon in MS Word application? () List all the tabs on the MS Word Ribbon. (c) Mention three tools in the following tabs (Home (ii) Insert (ii) Insert (iv) Layout (d) Mention three ways of. selecting text in MS Word. . (a) Explain how you will delete tex (i) Backspace (ii) Delete (b) Explain two ways of moving text in MS Word, using the following keys. . (a) Explain the overtype option in MS Word? (b) Explain the insert option in MS Word? (c) Differentiate between overtype and insert options in MS Word. . (a) Explain the functions of the following commands. (i) Undo (ii) redo (b) Differentiate between undo and redo commands Sub-strand 2.2: Introduction to presentation Z @ Content standard @ renchn strategy Hand-on practical activity in the computer laboratory lesson. Show projected examples of MS-PowerPoint interface with the aid of « projector {ePictures to leamers and let them explore MS-PowerPoint themes and templates. Jeamers to explore the use of the Proofi € group under the Review tab in MS-PowerPoint. Let learners demonstrate the use of the Language, Spelling & Grammar, ‘Thesaurus and other buttons in MS-PowerPoint under the Review tab, Let leamen explore the use of Special characters section under the Inse i recommend for teaching this teamets presenta prepared project or exercise using the editing group of te ribbons Beaieal Tht i edge in MS PowerPoint officee Sound 5 Fs Presentation software usually has an in-built library of sounds which can be used in the presentation. These include a variety of music (usually classical) and a number Saati sounds such as clapping, drum rolls, cheers, bells and many more. If you cannot find the exact sound that you need in the library, it is easy to import your own sound clips. It is also possible to record directly using the presentation software. This can enable a voice over to be added to the slides. Sounds in a presentation can be used t + make an impact + grab the audiences’ attention + add more detail about a point being made + create the right atmosphere for the presentation Video Presentation software allows users to insert video into presentations. It is sometimes better to use a video to show something happening rather than trying to explain it in words. The video can be started automatically or stopped manually with a mouse click when presenting. Some of the problems of using videos in presentations are: + they may make the presentation file size large and thus take up a lot of storage space + presentations containing videos are not easily emailed due to their large file size * you may need a specific player installed on your computer - without it, you may not be able to watch the video + if you move the presentation or video to another folder, the link to the video on the slide might be lost e Animation The animation is the movement of objects or text within the presentation. Presentation software allows users to animate text and objects that they insert in their presentation. For example, bullet points, images, objects and charts can be set to come in individually from the right, drop down from above with a bouncy effect, spin around a number of times before setting on the page and so one. ete. © Slides Slides that can contain any mixture of text, images, video, animations, links and sound, © Slide master Slide master this allows the style (font, font size, background etc) to be set once and then used throughout the presentation.© Slide transitions mn software comes ”, ‘dissolve’ and man th an effe s are used 10 move fp can also be used in conjung effects as they just cause unnecessary dig current slide and any notes as Soci ide on another screen or fe or fomay age, an objec, cha ryperlinks, When Y can opened, or file or they can direct you to a web page on the internet. * Buttons Presentation software can be used to create bot mn. A good presentation package are used to navigate from one part of \¢ previous slide, the next is often accompanied by cking mis makes the control feel more interactive. Buttons can also be used for other thi: jarting and stopping an automatic present h performs some action upon pre Benefits of Presentation Software + Engagement: Gone are the days when viewers would get bored wit tion software, you can bring your presen animations, images and interactive videos. software available in the markets es that you can customize to meet your needs.” easy to create professional presentations. Presentation software allow for better at share your presentations with your team and bs" of creating them from scratch, * Ease of use: Most of the presentat hundreds of free dashboard designs make e Enhanced collaborat jongst teams. You c itinst 86 aig a variety of sl wu to create presentation 1m software allows YO ‘adjust and modify i ‘nformation on YOUr specific a specific audience ‘Microsoft PowerPoint Microsoft PowerPoi software are called s consist of images, Vid organize your presentation. WH rnc ponent inertaces ‘When you open PowerPoint for the first isthe most popula Pr called side show ns nd. PowerPoint offers templates ( jo he jes. The visual presen ‘animation, and sow ime, the Start Screen appear. ie i the ; ; irs below. From here, you will be able to create a new Receentes rceee ee ee ee SS ee select Blank Presentation to access the PowerPoint interface as in the figt Quick Access Toolbar Title bar slides — Pane PowerPoint window interface 87fonts, and visual effects that you ap sional look. [ PY to weme w gives your presentation a pleasant appearance with | ale bs 1 ery of themes, n you add graphics (tables, theme colors that are compatible + Dark-colored te is strong for ease of reading. click the More button: apes, and so on) to your slides, " Pe slide elements, dk, 2, To see the fl gl background (and vice vers), sy riatons n The i 1¢ figure below shows four different themes applied to the same slide: iit ge How to use Theme for your presentation. “PowerPoint offers several preset themes. They are on the Design tab of the Ribbon left side. 1. Open a slide. On the Design tab, point at a Theme thumbnail to get @ pet E how it would affect the look of your . | What is a PowerPoint template? | seme plus some content fora specific purpose such asa sales prese ition, ora classroom lesson. A template has design elements that work together (colors, fons, backgrounds, effects) and contents that are arranged intext boxes find hundreds of different types of free templates for PowerPoint that you ‘your presentation online. For instance, you can download free template for ions from Templates.Office.com. You can download so many templates 89aa 3. Select the template to see a preview of it, then click Create. ‘Geometric color block The template is applied to the blank presentation. Note: Your computer must be connected to the Internet for you to use the templates. Basing the Proofing and Language group under the Review tab Just like we learned in Microsoft Word, PowerPoint also allow you to correct spelling and grammatical errors in your presentation. You can also use the Thesaurus tool and set the language for your presentation under the Review tab. The Proofing group contains the Spelling and Thesaurus tools. The Language group contains the Translate and Language settings. Bovine the Spelling tool in Microsoft PowerPoint As you type in PowerPoint, you will notice that wrongly spelt words are underlined with wavy red line. Note that a red wavy line does not necessaril: ly mean that the word is wrongly spelt. What it actually means is that the word is not in the dictionary of the computer. 1. Click on the Review tab on the ribbon. 2. In the Proofing group, click on Spelling. You will view the spelling pane at the right side of the window as shown below. o1owe! {for which you want a synon ‘ou will view the Thesaurus pane on the ym, say “Introduction”. «Proofing group, click on Thesaurus. Y' right side of your document as shown: i t SECTETE { th i INTRODU ‘COMPUTING 2. i word “Introduction” will be replaced by the selected word. Altematively, you can right-click mee right-click the word and select from a list of its synonyms as shown presentation. oy bes,you may need fo insert some special py ql 2.8, " etc, that are ily avail PowerPoint allows ssert ate not ely avallabe of oat ‘you to insert those symbols easl peso PowerPoint ribbon and click on ‘Symbol taleat TS Anserp Steps for inserting symbols in MS PowerPoint 1. Place your cursor 2. Go to Insert > Symbol. PowerPoint Symbol Options 4. When you find the in your PowerPoint bei tobe symbol you "You sa 204 vant, double-ch Th ide. the symbol and click inse Sat ‘Alternative method for insertin «5, Select Close to exit the Symbol dialogue box: 1g symbols stain text. For example, ‘® symbol by typing (1) Easy Shortcut for Symb | ‘These are certain symbols that ean be easily inserted by typing ce you ean insert © symbol by ‘yPine (© ‘rw symbol by typing (tm), etc. ‘Alt Codes for Symbols aaa certain Alt codes that help you insert symbols eal symbol (¢) by holding down ‘ALT” key and typing Should have Number keys on). You can find a comprehensiv. this website https//www.alt-codes.net/ For example, you can insert a 5° in the numbers pad (you ist of codes you can use inWHAT IS AN INPUT DEVICE? + An input device isa peripheral used to provide data and cont signals to a com a 3 3 z 5 3 = g z it from the Animation wh, ri Light”, Font Size 44 for heading. Apply Formatting Style to the heading Text Box. Use the Font “Calibri Light”, Font Size 28 for the points. KEYBOARD eee *Aleybourdis an input vce ‘ort aes Keyboard Rea cnres, Use “Two content” layout Use WordArt for the Label Select the picture and app Use the Font “Calibri Li Apply Formatting Style { - Use the Font “Calibri Li Mouse its 5 ero content” layout, insert your picture in the right column. oe ” 3. Use WordArt for the Label “Joystick imation tab. e in ion to it from the Animation tal ure and apply “Zoom” animation to it iz a ay Font “Calibri eh Font Size 44 for heading. 5. Apply Formatting Style to the heading Text Box. : 6. Use the Font “Calibri Light", Font Size 28 for the points. JOYSTICK ‘move the cursor postion on ‘8montor screen, Joystick t Slide 6 4. Use “Two content” layout, insert your picture in the right column, 2. Use WordArt for the Label “Scanner” 3. Select the picture and apply “Zoom” 4. Use the Font “C 5. Apply Formatting S 6. Use the Font I animation to it from the Animation tab. Light”, Font Size 44 for he: g Style to the heading Text Box. Calibri Light”, Font Size 28 for the points,*Ascanners,use light sensing {optic equipment to translate images tert, ‘rawings, photos, andthe ke into the dal form, Section header” layout, insert wank you” as the heading, your picture in the right column n the all the slides from the Transit itions tab, | Bsummary ’h PowerPoint slide show can consist of images, Video, animation, and sour. The tbs on the PowerPoint ribbon are File, Home, Insert, Design, Transitions, ‘Animations, Slideshow, Review and View. « Athome is a predefined set of colors, fonts, and visual effects that you apply to your ides for a unified, professional look. ‘A template isa theme plus some content for a specific purpose such as a sales presentation, a business plan, ora classroom lesson. We can check and correct the spelling of words in PowerPoint. We can change language of a PowerPoint slides. ‘We can translate PowerPoint slides into different languages. BD nowiedge-based assessment @yutipte choice Questions 1, Which of the following tools is a presentation package? A.MS Word B.MSExcel C.MS findows D. MS PowerPoint. 2. The pages in a presentation software are called A.document B. flame C.slide —_D. graphics 3. Predefined set of colour and fonts that provide a unified look for a presentation is known as, A.slides B.theme —C. ribbon. tabs 4. To apply themes to our slide show, we use Avreview B.home — C. design _D. slide show 5. The language settings is found on which of the following tabs? A.Review B.Home C. Design. Slide showmathematical formulas andthe da mn ofa row and a column in a spreadsheet. Users can pa, (0 make headings and sto (usually numb are bigger than others, an colour or size of texv font, the same way font/text is changed in a word pro ‘even put pictures in the worksheets, make multiple pages, and paper. Examples of electronic Spreadsh Lotus1-2-3, OpenOffice, makes a spreadsheet sot Spread sheet applications Importance of spreadsheet application | and tracking budgets, ting project costs, * It is used for creating other types of financial reports, | | 102 { enable users to organize, ; 1 of Excel and locations where you ha worksheet, and worksheets as part of window Mi ‘oft Office Excel provides ‘manage, and share information e: it work are cells, rows, and columns ; verde ‘The figure below shows Microsoft Excel App! von ane Microsoft Excel interface fying cell names in a spreadsheet appl Every cell in a worksheet has a unique address or location known as the cell reference. A cell reference identifies the location of a cell or group of cells in the spreadsheet. umber (1, 2, 3, ...) For example, a cell reference A means that the cell is at Column A and Row 1 and K12 ‘means Column K and Row 12. When you click on a cell, the cell reference is displayed 103Step 2. Press the TAB key or the RIGHT ARROW. type MATHS SCORE io fee ; if Step 3. Press the TAB key or the RIGHT ARR( ; ince type ENGLISH SCORE. ‘OW key or simply click i 108 104 in BE 1 notice that the content in ell C2 (ENGLISH SC\ 2 (MATHS SCORE). The show the content in cel B ng the cell size Step 1. Move your pointer to the line dividing Step 2, Click and drag or double-click to adjust the size of col text in BI. 8 (ep) Cc Oe vats Besarieoe @ ‘Use the steps you have leamed so far co complete Enter the following data. Sh AS ee Mss D RANE MATHS SCORE ENGLISH SCORE SCENCE SCORE "Kon HeneRY 75 6 s 3 /ARASERWAA ss % 0 4 AMALINDA @ 8 7” “5 AseIDU 70 es 9 € tlom Wisoomt ® z a _YARO DAVID 37 “6 ey (stows a = aSelecting data Excel F scar steps to select data in excel. c= c ° 4 Jane enous SCORE scence SCORE | 2 |KOFI HENERY. - & 2. | = 8 is used to select cell or range of cells in Excel, | Falun ® n To select a cell, click on the cell. For example, click on cell B3 to select ae = - 6 |txom wisoo 7 |raro Da 8 2 “box 3 3 0 entire row. ‘ow, click on the role number. For example to click on row 3 to select the jotice that the name of the selected The date in the selected cell ie. B3) will appear in the nase Seen he Sele MATHS ‘SCORE ENGLISH SCORE SCIENCE SCORE 75 65 ick and drag on the cells. For example, click on cdl drag to cell C4 to select the range of cells. “eens 2 ‘Move cells by drag and dropping a sare s that you want to move. For example cell A1 to D8 [xv # | wae 8B D1 JSCIENCE SCORE _ 65 50 n 2 * Selecting entire column, ; * To select entire column, click on the column header, For example to click (8%, Point othe border ofthe selection. The point will become a move pointer is to select the column,When the pointer becomes a move poin this example, move the selected cell: Select a cell where you want to move the data. For example A2 108 ted cells or you can delete the cells. or delete cells in Excel. ‘contents without removing the cell from rout of surrounding cells. Use the following ‘contents of selected cells. eee MATUSSCORE_ENGUSHSCORE_SCENCE SCORE Ca 6 so o oy n Hine — — ramisscone onusiscone scence cont fone [ae] s ‘ asernn om = SS [AMANDA (0 get rid of more than just the contents of a cell selection, like cell yw these steps: yntaining the content you want to clear. the Clear button (the one with the eraser) in the Eaiting group on the Home i liClear Formats del Te] | EBcondtins Format = > | EBrermstextie~ i censypes~ © Clear All gets rid of all formatting, comments, and entries in yp, * Clear Hyperlinks removes the active hyperlinks in the cell selec ion, Use Excel's Delete commands to completely cl .ct column B and select Delete | Benet» Biomater | Erode = Geary | Brome Bila ~~ paint tana SS a ‘ leo nce aa | ¥ * Deleting cells, rows, or columns Del formatting. When you delete a cell (or an entire row or column), Excel has tos position of entries in the surrounding cells to plug up any gaps caused by the dt To delete the actual cell selection rather than just clear the cell contents, follow is steps: 1. Select the cells, rows, or columns you want to delet 2. Click the drop-down button attached to the Delete but Home tab. 3. Delete Cells on the drop-down menu. ‘The Delete dialogue box opens, showing these options for filling in the gaps column B which contained data on MATHS SCORES be deleted and the ENGLISH SCORE which was in column C will shift to Column Cells Up moves entries up from neighboring rows bel co Entire Row removes all the rows in the current cell selection ‘¢ Column deletes all the columns in the current cel ste‘worksheet and displays the data _Lexaetly as you type it in, 413Currency 12,500.50 F 1e general number f 2 512200-90 type a number ¥ ‘Accounting £ 12,500.50 ~~ | 8/5/2010, 26-Mar > Percentage Date You can format your cell date, 10, 5-May, 12.00 Time You can format your cells to display 12.5% For example, 0.5is translate you enter the number} and then format the cll |__| dates and text are displayed change and control how your numbers, 4 as a percentage itis : ; 00%. Fraction | This format di displayed ee as actual fractions. S Scientific | oe ipl the ji2sE02 ion £ Text This format cells are treated as text | Account, jms [even when a number sin the eel. The | Index Nambet as entered. Test.__—~ Special mats are useful i If stand database values ne | Mu ae Zip Cole gi Social Securit Custom [A custom number format allows you to | Format 0.00 fa numbers. The mut Ts the format entered. ee ‘Number format This gives you control over the option of displaying basic punctua decimal places and negative numbers: 's the data exat dollar, comma cl are left aligned @ umber format Is you want and type the data fhe general number forma 1 is applied. number of decimal places displayed as well as the ion, comma's and parentheses. The default is 2 ‘are displayed in black preceded by a minus How to apply the number format 1. Enter the data for the Age as shown below.the Number format, afua Amina k on the Home tab and locate the Number group. . Click on the arrow close to the General format and select Number. oI Mcrae Q, sa 123 _ No specific format Currency S119 & i ® ‘nm BE $11.00 FER) Short Date wnvriseo You will notice that the numbers have You can change the number of decimal 1, On the Home tab, click on the arrow close to the Number group. es by using the following steps. |e) | s-%° | as | numer ‘This will display the dialogue box below. Altematively, click on the arrow close to the General format and select More Number Format... 2 Select Number from the category and reduce the Decimal place to zero 3.Click OK rent from the General format< eral format but with three differences: You can number of decimal places. Allows you to use a comma separator Broups of three digits. Negative numbers can be displayed in red and or egative sign, 17Wong the date format 1. Type Date of Birth in cell C1. 2. Select cell range C2:C5 A 8 2 1 3 |va0 & x 4 |afua 2 5 |amina 3 3. Click on the arrow close to the General format and select More Number Format... 4. Click on Date in the category. 5. Select the type of date you want to use and click OKmat you want to change. Tt iifRemember that you can change the tne format once you have entered F How to chai at. 1. Select the format you want to change. oa 32, Thursday, February 25, a tae - ei ss leExcel aligns numbers to the bottom-right of cells and text to the However, you can easily change the defaul keyboard shortcuts, Format Ci 1g Your own custom elect the cell(s) you want to realign, goo . and choose the desired option: ‘Text orientation Wrap Text alignment —| = = = |9%z| [2 Wap tet Hovzonsl [ESS] (FESS) [Eegeacener alignment | | | | | | Vertical | | | | Alignment 5 Text indent Merge & Center Vertic : Ifyou'd gn ick one of the following icons: «Top Align = - aligns the contents to the top of the cell. 124 By com ‘Align Left = - aligns the contents al + Center I - puts the contents in the ‘Align Right [ - aligns the contents along the right edge of the cell. ical and horizontal alignments, you can arrange the cell contents in different ways, for example: ‘Align to upper-left Align to bottom-right igns the contents to the bottom of the cell (the default ( stical alignment does not have any visual effect unless Center in the middle Change text orientation (rotate text) Click the Orientation button on the Home tab, in the Alignment group, to rot ally or sideways. These options come in especi text up or down and write ve handy for labeling narrow columns: a] | Bweptee t [By ge Camano = Ange cloevse —_— slele| 1B vere Tet » fem [Ed tome terup Te) reduces 4E Rotate Tet Down & [producta Indent text in a cell In Microsoft Excel, the Tab key di 125 3 indent text in Microsoft Word; it just moves the pointer to the next ct it does, say, in To change the — |the Orientation button. o ‘To move text further to the right, click the Inerease Indent icon. If yoy too far right, click the Decrease Indent icon to move the text back to ty ; lt the Alignment = So | Buvcptee ‘lick open the ee | | SE =/ES Bvepacen > Format els dialog | Alignment mn to the most used alignment options available on the ribbon, the For [Now et us take a closer Took atthe most important ones- Text alignment options “Apart from aligning text horizontally and vert you to justify and di contents as well as current data. Testatgnment oteantat these options allow ‘an entire cell with the er onde center ‘a [Basa - eet aaa secon How to fil cell with the current contents fon to repeat the current cell content for the width of the cel wu can quickly create a border element by typing a period in one cel ll under Horizontal alignment, and then copying the cell across several edge and last word with the right edge of the c zAee| at any angle, clockwise or counterclockwise. Simply type the desired number from 27entation pointer. 90 to -90 in the Degrees box or dra this case, wo will atten —— - BI. Los Step 2-On the Home tab, locate a ith hidden or excess tex' ck on Wrap Text to apply it to the selected the number | ne | [Oe peorees Changing text direction ‘The bot -most section of the Alignment tab, named Right-to-left, cont but you can change | WD coansing tot ctor «om co Step 1. Click and drag to select the headings INAME NUMBER OF FRIENDS AGE kort lama Ivaw Inu IMENSAH KWAME loroat B 2 xe eisteleiieivisieimiaia & ‘Applying Wrap Text to a cell ‘You can use Wrap Text to fit text in the size of the cell, 128 129Step 2. Inthe Font group onthe Home Tab, Click on the font colour ang cy ke | ht green colour. Step 3. Click and drag to select the rest of the text in the table. 130| Ail apply all border lines to the table ‘this wi ° Step 2. In th i Step 2. Inthe Font group on the Home Tab, click on the Borders icon and seky insert from the pop-up menu insert new row 1 and push the table to row 2. 12 133 i