Scribd Logo
Upload

Welcome to Scribd!

  • 23 views

    MS Excel January Exam 2022 PDF

    Uploaded by

    the hubcomps
    The document provides instructions for a Microsoft Excel exam. It outlines that the exam will have both practical and theory sections worth 50 marks each. For the theory section, it lists 12 questions testing knowledge of Excel concepts like spreadsheets, functions, formatting, and real-life applications. For the practical section, it provides two case studies/datasets and tasks the candidate to perform various data analysis and visualization steps like sorting, filtering, graphs, and comments. Candidates are instructed to show work, calculations, follow formatting guidelines, and save work in the provided flash drive.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    MS Excel January Exam 2022 PDF

    Uploaded by

    the hubcomps
    23 views6 pages
    The document provides instructions for a Microsoft Excel exam. It outlines that the exam will have both practical and theory sections worth 50 marks each. For the theory section, it lists 12 questions testing knowledge of Excel concepts like spreadsheets, functions, formatting, and real-life applications. For the practical section, it provides two case studies/datasets and tasks the candidate to perform various data analysis and visualization steps like sorting, filtering, graphs, and comments. Candidates are instructed to show work, calculations, follow formatting guidelines, and save work in the provided flash drive.

    Original Title

    MS EXCEL JANUARY EXAM 2022.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for a Microsoft Excel exam. It outlines that the exam will have both practical and theory sections worth 50 marks each. For the theory section, it lists 12 questions testing knowledge of Excel concepts like spreadsheets, functions, formatting, and real-life applications. For the practical section, it provides two case studies/datasets and tasks the candidate to perform various data analysis and visualization steps like sorting, filtering, graphs, and comments. Candidates are instructed to show work, calculations, follow formatting guidelines, and save work in the provided flash drive.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    23 views6 pages

    MS Excel January Exam 2022 PDF

    Uploaded by

    the hubcomps
    The document provides instructions for a Microsoft Excel exam. It outlines that the exam will have both practical and theory sections worth 50 marks each. For the theory section, it lists 12 questions testing knowledge of Excel concepts like spreadsheets, functions, formatting, and real-life applications. For the practical section, it provides two case studies/datasets and tasks the candidate to perform various data analysis and visualization steps like sorting, filtering, graphs, and comments. Candidates are instructed to show work, calculations, follow formatting guidelines, and save work in the provided flash drive.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 6

    MICROSOFT EXCEL

    (SPREADSHEET 2021 EXAM series)


    TIME ALLOWED 2hrs
    THE COMPUTER SOCIETY OF KENYA
    EXAMINATION BOARD
    P.O. BOX 70180
    NAIROBI.
    TEL: 3871836/48 FAX: 3871822
    EMAIL: [email protected]
    http://www.cskonline.org
    INSTRUCTIONS TO CANDIDATES.
    1). The paper contains both practical and theory questions.

    2). All the theory questions must be answered in the order in which they are.

    3). Practical work must be saved in your flash disk as per the instructions given.

    4). Good and neat handwriting will earn you more marks.

    5). After you finish your examination, put your answer sheet and question sheet together.

    6). Pay attention to marks per question in relation to time. All marks indicated are out of 100.

    STUDENT NAME:………………………………………………………………………

    COLLEGE:………………………………………………………………………………

    STUDENT NUMBER:………………………………………………………………….
    SECTION ONE: THEORY (50MARKS)

    1. Explain clearly what is Ms. Excel? (2mks)

    2. What is a spreadsheet? (2mks)

    3. Explain any three components of spreadsheet? (6mks)

    4. What is the main difference between a Spreadsheet and aDatabase? (4mks)


    5. Discuss the following terms:-

    a) Function and logic/IF Function

    b) Formula bar and a sheet tab

    c) Cell reference and Active cell

    d) Filter and sort 8mks


    6. State and explain four relevance of real life application of spreadsheets? (8mks)
    7. State the procedure of resizing cells and columns (4mks)
    8. Explain how you insert columns and rows? 4mks
    9. What is the difference between freeze cell and hide cells (2mks)
    10. What is cell merging? How do you merge a given cell(s) (4mks)
    11. What is a comment? How do you insert a comment in a given spreadsheet? 4mks
    12. Explain how a spreadsheet would help in personal budgetingand financing? 2mks
    SECTION TWO: PRACTICAL (50MKS)

    ANSWER ALL QUESTIONS

    1. The Following is an analysis performance of KCPE results ofMugoiro Primary school.


    Tabulate the results in the spreadsheet and use it to answer the following questions.
    Candidate’s name ENG KISW MATHS SCIENCE SS/CRE
    Paul Mulwa 74 64 77 52 73
    Sabina Njoki 69 58 65 69 59
    Aniffer Ali 66 68 93 75 85
    Benard Kasuku 71 59 44 67 69
    Anatasticia Kibe 56 63 53 45 58
    Moses Mautama 77 84 74 76 67
    Cyperian Ndumbi 77 47 85 49 55
    Paul Otieno 77 62 56 56 78
    Irene Mwakideu 87 39 90 74 66
    Finius Alpha 65 45 56 60 81
    Angeline Ann 50 90 91 87 70

    Questions

    1. Prepare the above result analysis and sort it accordingly inascending order
    2. Find, sum, product, minimum, maximum, average andstandard deviation.
    3. Merge nearing cells with same marks
    4. Do a bar graph representation of names versus scienceperformance and copy in a
    new sheet renaming it as PERMORMANCE.
    5. Do analysis of Kiswahili, maths and English in differentgraphical representation
    6. Edit the column as follows; font name Elephant, size 14,color purple
    7. Insert three rows above your spreadsheet and title yourspreadsheet Mugoiro KCPE
    Analysis 2021
    8. Filter all names starting with ‘A’ and ‘I’ and rename theworksheet as improved
    9. Insert a comment on MOSES and say ‘exceedingexpectation’ (25mks)

    2. You are the accounting officer of Davies and Shirtlift Company in Kenya. The company
    is due to make payment for salaries and wages to the firm employees for various months
    plus accrued interest. Study the WORKSHEET belowkeenly and then answer the
    proceeding questions.

    NAME OF HOURS NUMBER BASIC ALLOWANCE OVER TAX DEDU NET


    EMPLOYEE WORKED OF DAYS PAY TIME PAY
    PETER 12 14
    ARNORLD 6 28
    ERIC 9 45
    JOSHUA 7 60
    SIMON 8 23
    GIDEON 5 46
    MAXWELL 11 33
    DANIEL 13 51
    VINCENT 14 34
    DILLAN 15 66
    FRANCIS 10 19
    NICOLAS 16 44
    SHADRACK 7 11
    KEVIN 9 9
    TASK

    Prepare the spreadsheet and enter the above information


    Calculate:-
    a) Basic pay give basic pay=hrs wrked*num of days Allowance
    given that allowance is 10% of basic plus 200Overtime is
    calculated as 2.5% of allowance less 50
    b) Tax is 16% of basic pay plus allowance plus overtime less 100
    Deductions is calculated 10% of tax less 200
    c) Net pay is calculated as 90% of basic pay plus allowance plus overtime less ¼ of(tax+dedu)

    You might also like