Computerised Accounting – 12 Practicals
Practical 1: Count Functions in Spreadsheet Aim To count the number of cells containing numbers, any value, and values above a given limit using COUNT, COUNTA and COUNTIF functions. Data Enter the following data in cells A1 to H2: A B C D E F G H 390 651 856 765 9899 192 1032 STOCK 349 298 995 684 567 CASH 1500 TDRS Procedure Open LibreOffice Calc: Applications → Office → LibreOffice Calc . Enter the data in cells A1:H2. In cell B4, enter the formula to count numbers: =COUNT(A1:H2) In cell B5, enter the formula to count any value: =COUNTA(A1:H2) In cell B6, enter the formula to count values above 1000: =COUNTIF(A1:H2,">1000") Result Numbers only: 12 Any value: 15 Values above 1000: 3 (9899, 1032, 1500) Practical 2: Maximum, Minimum and Average Functions Aim To find the highest, lowest and average score of students using MAX, MIN and AVERAGE functions. ...