columns (vi) Formatting the text : To bold : Control+B; To italicise : Control+I To underline : Control+U (vii) Paragraph alignment : To align text left : Control+L To align text right : Control+R To align text centre : Control+E To align text justify : Control+J (viii) Line spacing : Single line spacing : Control+ Double line spacing : Control+ . line spacing : Control+ (ix) Page lay out : Margin (normal, narrow, wide, etc.) Orientation (Portrait, Landscape) Size (A4, A5, etc) Columns ( , , , etc.) (x) Page number : Insert Page Number (top of the page, bottom of the page, etc.) . . (a) MS Word Practical Illustration Type the given below passage in MS-Word and format as directed.
Fra Luca Bartolomeo de Pacioli was an Italian mathematician ( – ). He is referred to as The Father of Accounting and Book keeping in Europe and he was the first person to publish a work on the double-entry system of book keeping. Accountancy Solution Procedure (i) Select and bold the name Fra Luca Bartolomeo de Pacioli. (ii) Add single quote before The Father and after Book keeping.
‘The Father of Accounting and Bookkeeping’ (iii) Select and italicise the word Europe. Europe (iv) Select and underline the word double-entry. double-entry (v) Select the full text and change the font style to Arial and font size to Output: Fra Luca Bartolomeo de Pacioli was an Italian mathematician ( – ). He is referred to as ‘The Father of Accounting and Book keeping’ in Europe and he was the first person to publish a work on the double-entry system of book keeping.
. . MS-Excel i) Functions a. Statistical functions There are several statistical functions such that are inbuilt in MS Excel.
The following are explained. AVERAGE Returns the average =AVERAGE(cell1, cell2…) MAX Returns the largest value =MAX(number1,number2) MIN Returns the lowest value =MIN(number1,number2…) COUNT Counts the number of cells that contain numbers =COUNT(value1,value2…) COUNTA Counts the number of cells that are not empty. =COUNTA(range) COUNTIF Counts the number of cells that meet the given condition. =COUNTIF(range,criteria) b.