ATIKA SCHOOL
  • Home
    • Atika School Advanced Search
    • News and Opinions
    • Echo
    • Academic Environment
    • How its Done
    • SITEMAP
    • About Us? >
      • About Us
      • Learn more about us
  • TUTORIALS
    • SECONDARY >
      • SCIENCES >
        • FOCUS MATHEMATICS TUTORIALS AND EXAMS FREE
        • KCSE BIOLOGY NOTES
        • FREE KCSE CHEMISTRY NOTES
        • KCSE PHYSICS NOTES, AUDIOVISUALS AND MORE
      • LANGUAGES >
        • ENGLISH >
          • English KCSE Set Books
          • ENGLISH GRAMMAR #KCSE
        • CHOZI LA HERI - MWONGOZO
        • KIGOGO - MWONGOZO
        • KCSE Kiswahili
      • TECHNICALS >
        • KCSE BUSINESS STUDIES NOTES
        • kcse Computer Studies Notes
        • KCSE AGRICULTURE NOTES, SYLLABUS, QUESTIONS, ANSWERS, SCHEMES OF WORK AND OTHERS
      • HUMANITIES >
        • KCSE History Notes Form 1 to 4
        • FREE KCSE CRE NOTES
        • KCSE GEOGRAPHY NOTES
        • IRE NOTES, AUDIOVISUAL, QUESTIONS AND ANSWERS
    • MASOMO VIDEOS
    • PRIMARY >
      • NOTES >
        • KISWAHILI
        • SOCIAL STUDIES >
          • STANDARD 4: SOCIAL STUDIES
        • SCIENCE
        • ENGLISH >
          • KCPE and Primary Level Compositions
        • MATHEMATICS >
          • KCPE Mathematics Notes
      • EXAMINATIONS >
        • DecaTurbo Online Series Examinations
        • TOP INSHA AND COMPOSITION QUESTIONS
        • CBC Kiswahili
        • FOCUS A365 SERIES K.C.P.E EXAMINATIONS FOR PRIMARY
        • Standard 8 (std) English Topical Questions
      • SYLLABUS >
        • Primary Mathematics Syllabus
  • CURRICULUM
    • NEW CURRICULUM DESIGNS >
      • PRIMARY >
        • PRE PRIMARY ONE CURRICULUM WITH SYLLABUS
        • PRE PRIMARY TWO CURRICULUM WITH SYLLABUS
      • SECONDARY >
        • KNEC KCSE SYLLABUS AND COURSE OUTLINES
      • COLLEGE >
        • Regulations for the TIVET Craft and Diploma Business Examinations
  • PRODUCTS
    • All Categories
    • FREE DOCUMENTS
    • PRIMARY CBC BASED RESOURCES
    • PRIMARY 8-4-4 BASED RESOURCES >
      • STANDARD 8 RESOURCES
    • COLLEGE & VARSITY RESOURCES
    • HIGH SCHOOL RESOURCES
    • FREE NOVELS >
      • COURSE BOOKS
      • KCSE KISWAHILI SETBOOKS
    • Backed Up Files and Archives
  • EXAMINATIONS
    • PRIMARY EXAMS >
      • Assignments and Random Exams
      • 8-4-4 >
        • STANDARD 8 PAST PAPERS 8-4-4 BASED
      • CBC
    • TOP SCHOOLS EXAMINATIONS LATEST >
      • Assignments and Random Exams
    • KCPE >
      • KCPE PAST PAPERS AND ANSWERS
    • KCSE >
      • KCSE BY SUBJECT >
        • KCSE PAST PAPERS BY SUBJECT
        • Free KCSE Past Papers Mathematics
        • Free KCSE Biology Questions and Answers
      • KCSE BY YEAR >
        • KNEC KCSE PAST PAPERS, MARKING SCHEMES, QUESTIONS & ANSWERS
    • QUESTIONS & ANSWERS >
      • SECONDARY >
        • LANGUAGES >
          • ENGLISH POETRY QUESTIONS WITH ANSWERS FOR K.C.S.E CANDIDATES
        • TECHNICALS >
          • COMPUTER STUDIES >
            • COMPUTER STUDIES Q & A
            • kcse computer studies paper 2 AND 3 Questions & Answers
          • BUSINESS STUDIES QUESTIONS & ANSWERS
          • KCSE AGRICULTURE TOPICAL QUESTIONS
          • KCSE HOME SCIENCE DIRECT QUESTIONS AND ANSWERS
        • SCIENCES >
          • KCSE Mathematics Topical Questions
          • KCSE Biology Topical Questions and Answers
          • CHEMISTRY TOPICAL QUESTIONS AND ANSWERS
          • KCSE Physics Topical Questions
          • KCSE physics Practical Sample Quiz
        • HUMANITIES >
          • ISLAMIC RELIGIOUS EDUCATION (IRE) QUESTIONS AND ANSWERS
          • C.R.E (CRE) QUESTION AND ANSWERS
          • KCSE History Topical Questions and Answers
          • GEOGRAPHY TOPICAL QUESTIONS AND ANSWERS
      • PRIMARY >
        • Standard 4-8 Mathematics Topical Questions from Mocks and KCPE
        • Std 6 Mathematics Notes
  • HIGH INSTITUTIONS
    • EXAMINATIONS >
      • College and Varsity Past Papers online >
        • College and Varsity Past Papers online
    • TUTORIALS
  • PRICING
  • BLOGS
    • Contact
    • Help & Support
    • MPESA FORM
  • Search Free Documents (PDF)

ANALYSIS OF KCSE COMPUTER STUDIES TOPICAL QUESTIONS & REVISION KITS

This site is a creation of all possible KCSE computer studies questions and answers
Picture

Follow us now to receive the latest updates @schoolatika

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

29/12/2020

0 Comments

 


Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

​b) State one way in which a user may reverse the last action taken in a spreadsheet package. 
c) The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, . and A, B, C. respectively
Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting
Use the following expressions to answer the questions that follow:
  •  Basic pay = hours worked x pay per hour
  • Allowances are allocated at 10% of basic pay
  • Gross pay = basic pay + allowances
  • Tax deductions are calculated at 20% of gross pay
  •  Net pay = Gross pay – tax deductions.
Write formulae using cell references for the following cells;
i) D2 
ii) E4 
iii) F10 
iv) G7 
v) H5 
d) i) State three ways of moving round the page in a Desktop Publishing window. 
ii) State two ways on how information & Communication Technology (ICT) can be used to reduce the spread of HIV/AIDS
EXPECTED RESPONSES
(a) Distinguish  between  the following sets  of terms as used  in  spreadsheets
(i) Worksheet and workbook
  • Worksheet – The working area in an electronic spreadsheet on which a 
  • user enters the spreadsheet data.
  • Workbook – A spreadsheet file. A workbook can obtain several worksheets
(ii) Filtering and sorting
  • Data filtering is a way of organizing spreadsheet data for ease of analysis. Often spreadsheet filters are used to “hide” rows of data that do not meet certain specified criteria. This allows you to analyze (e.g. count, observe etc) only certain “Filtering” groups of data.
  • Data sorting: Is a way of arranging record according to one of the fields in either ascending or descending order.
(b) State one way in which a user may reverse the last action taken in a spreadsheet package
Use the undo command (ctrl + z)
(c)The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, and A, B, C respectively
Use the following expressions to answer the questions that follow: Basic pay = hours worked x pay per hour Allowances are allocated at 10% of basic pay Gross pay = basic pay + allowances Tax deductions are calculated at 20% of gross pay Net pay = Gross pay – tax deductions. Write formulae using cell references for the following cells; i) D2 ii) E4 iii) F10 iv) G7 v) H5 d) i) State three ways of moving round the page in a Desktop Publishing window. ii) State two ways on how information & Communication Technology (ICT) can be used to reduce the spread of HIV/AIDS
Use the following expressions to answer the questions that follow
  • Basic pay- Hours worked x  pay per hour
  • Allowances  are allowed at 10% of basic pay
  • Gross pay- Basic pay + allowances
  • Tax  deductions are calculated  at 20% of gross  pay
  • Net pay-= gross  pay – tax deductions
Write formulae using cell references for the following cells
  • (i)D2  = B2 * C2
  • (ii)E4 = 10% * D4 or 10% * (B4 * C4)
  • (iii)F10 = D10 + E10
  • (iv)G7 = 20% * F7
  • (v)H5 = H5 – G5
(d) (i) State three ways  of  moving round the page in  desktop  publishing  window 
  • Use cursor keys
  • use mouse scroller
  • Use scroll buttons (horizontal and vertical)
(ii)State two ways on how information & communication technology (ICT) can be used to reduce the spread of HIV/ AIDS
  • Through  advertisements on the Internet
  • Through creation of posters
  • Through discussion  groups  on the internet

​​Related Searches on Impact of ICT on society, Form 4 Level

Read More

0 Comments



Leave a Reply.

    Categories

    All
    1998
    1999
    2000
    2001
    2002
    2003
    2004
    2005
    2006
    2007
    2008
    2009
    2010
    2011
    2012
    2013
    2014
    2015
    2016
    2017
    2018
    2019
    2020
    Applications Areas Of Ict
    Areas-where-computers-are-used
    Basic-computer-set-up-and-cabling
    Career Opportunities In Ict
    Classification Of Computers
    Classification-of-computers
    Computer-files
    Computer Systems
    Dashboard
    Database
    Data Communication
    Data-integrity
    Data Processing
    Data Representation In A Computer
    Data Security And Controls
    Definition And Development Of Algorithm
    Definition-of-a-computer
    Desktop Publisher
    Development-of-computers
    Dtp
    Editing-and-formatting-a-word-document
    Electronic-data-processing-modes
    Elementary Programming Principles
    Errors-in-data-processing
    Evolution-of-computer-systems
    File-management-using-an-operating-system
    File-organization-methods
    Form 1
    Form 2
    Form 3
    Form 4
    Hands On Skills
    Hardware
    Impact Of Ict On Society
    Information
    Input Devices
    Internet And Email
    Introduction To Networking And Data Communication
    Intro To Computers
    Levels-of-programming-languages
    Midterm-exams
    Mind-blowing-q-a
    Mocks
    Network-topology
    Operating Systems
    Output Devices
    Paper 1
    Parts-of-a-computer
    Processing-devices
    Processors
    Program-construction
    Program-control-structures
    Program-design
    Program-development
    Program-documentation
    Registers
    Revision-kits
    Secondary-storage-media
    Section A
    Section B
    Software
    Spreadsheets
    Stages Of System Development
    Storage Devices
    Symbolic-representation
    System-design
    System Development
    System-documentation
    Term-1
    The Computer Laboratory
    The-computer-laboratory
    The-cpu
    Types-of-networks
    User Interface
    Uses-of-computers
    Word Processors
    Worksheet-formatting

    Archives

    January 2025
    January 2021
    December 2020
    October 2020
    April 2020
    February 2020
    October 2019
    August 2019
    July 2019
    April 2019
    March 2019
    November 2018
    August 2018
    July 2018
    December 2017
    November 2017
    October 2017
    July 2017
    August 2016
    June 2016
    January 2016
    December 2015
    November 2015

    RSS Feed

atika school app
Download our Android App

Primary Resources
  • K.C.P.E Past Papers
  • ​Pri - Primary 1 Level
  • Pri  - Primary 2 Level
  • Grade 1
  • Grade 2
  • Grade 3
  • Grade 4
  • Standard 5
  • Standard 6
  • Standard 7
  • Standard 8
  • English
  • Kiswahili
  • Social Studies
  • Science
  • Mathematics
  • Kenya Sign Language
  • I.R.E
  • ​H.R.E
  • Notes
  • Termly Questions
  • Mocks
  • K.C.P.E Past Papers
College Resources
  • E.C.D.E
  • P.T.E
  • D.T.E
  • Technical Diploma
  • Technical Certificate
  • Business Diploma
  • Business Certificate
  • Higher Diploma
  • K.A.S.N.E.B Resources
  • K.M.T.C Resources
  • Varsity Resources
Secondary Resources
  • K.C.S.E Past Papers
  • Form 1
  • Form 2
  • Form 3
  • Form 4
  • Term 1
  • Term 2
  • Term 3
  • English
  • Geography
  • History
  • C.R.E
  • I.R.E
  • ​H.R.E
  • Home Science
  • Computer Studies
  • Business Studies
  • Agriculture
  • Chemistry
  • Biology
  • Physics
  • Mathematics ALT A
  • Mathematics ALT B
  • Kiswahili
  • French
  • Germany
  • Arabic
  • Aviation
  • Art & Design
  • Drawing & Design
  • Building & Construction
  • Metal Works
  • Wood Work
  • Music
  • Kenya Sign Language
  • Electricity
Other Useful Links
  • Academic Environment
  • How its Done
  • News and Opinions
  • Manyam Franchise Support
  • About
  • SITEMAP
  • FOCUS A365 SERIES
  • Membership Details (KCPE/KCSE)
  • Secondary Mocks
  • SYLLABUS
Contact Us

    Send Us a Message

    Max file size: 20MB
Submit
Manyam Franchise
P.O Box 1189 - 40200 Kisii
Tel: 0728 450 424
Tel: 0738 619 279
Tel: 0763 450 425
E-mail - sales@manyamfranchise.com
Photos used under Creative Commons from wwarby, JoshMacDonald, Visual Content, wuestenigel, Homini:), Wonderlane, Mike Licht, NotionsCapital.com, The Official CTBTO Photostream, picsaf.com, OER Africa, Jemimus, andronicusmax, Christoph Scholz, cyanocorax, matsuyuki, Mark Hodson Photos, cathyse97, tompagenet, ToGa Wanderings, crstnksslr, machernucha, panpot, ePublicist
  • Home
    • Atika School Advanced Search
    • News and Opinions
    • Echo
    • Academic Environment
    • How its Done
    • SITEMAP
    • About Us? >
      • About Us
      • Learn more about us
  • TUTORIALS
    • SECONDARY >
      • SCIENCES >
        • FOCUS MATHEMATICS TUTORIALS AND EXAMS FREE
        • KCSE BIOLOGY NOTES
        • FREE KCSE CHEMISTRY NOTES
        • KCSE PHYSICS NOTES, AUDIOVISUALS AND MORE
      • LANGUAGES >
        • ENGLISH >
          • English KCSE Set Books
          • ENGLISH GRAMMAR #KCSE
        • CHOZI LA HERI - MWONGOZO
        • KIGOGO - MWONGOZO
        • KCSE Kiswahili
      • TECHNICALS >
        • KCSE BUSINESS STUDIES NOTES
        • kcse Computer Studies Notes
        • KCSE AGRICULTURE NOTES, SYLLABUS, QUESTIONS, ANSWERS, SCHEMES OF WORK AND OTHERS
      • HUMANITIES >
        • KCSE History Notes Form 1 to 4
        • FREE KCSE CRE NOTES
        • KCSE GEOGRAPHY NOTES
        • IRE NOTES, AUDIOVISUAL, QUESTIONS AND ANSWERS
    • MASOMO VIDEOS
    • PRIMARY >
      • NOTES >
        • KISWAHILI
        • SOCIAL STUDIES >
          • STANDARD 4: SOCIAL STUDIES
        • SCIENCE
        • ENGLISH >
          • KCPE and Primary Level Compositions
        • MATHEMATICS >
          • KCPE Mathematics Notes
      • EXAMINATIONS >
        • DecaTurbo Online Series Examinations
        • TOP INSHA AND COMPOSITION QUESTIONS
        • CBC Kiswahili
        • FOCUS A365 SERIES K.C.P.E EXAMINATIONS FOR PRIMARY
        • Standard 8 (std) English Topical Questions
      • SYLLABUS >
        • Primary Mathematics Syllabus
  • CURRICULUM
    • NEW CURRICULUM DESIGNS >
      • PRIMARY >
        • PRE PRIMARY ONE CURRICULUM WITH SYLLABUS
        • PRE PRIMARY TWO CURRICULUM WITH SYLLABUS
      • SECONDARY >
        • KNEC KCSE SYLLABUS AND COURSE OUTLINES
      • COLLEGE >
        • Regulations for the TIVET Craft and Diploma Business Examinations
  • PRODUCTS
    • All Categories
    • FREE DOCUMENTS
    • PRIMARY CBC BASED RESOURCES
    • PRIMARY 8-4-4 BASED RESOURCES >
      • STANDARD 8 RESOURCES
    • COLLEGE & VARSITY RESOURCES
    • HIGH SCHOOL RESOURCES
    • FREE NOVELS >
      • COURSE BOOKS
      • KCSE KISWAHILI SETBOOKS
    • Backed Up Files and Archives
  • EXAMINATIONS
    • PRIMARY EXAMS >
      • Assignments and Random Exams
      • 8-4-4 >
        • STANDARD 8 PAST PAPERS 8-4-4 BASED
      • CBC
    • TOP SCHOOLS EXAMINATIONS LATEST >
      • Assignments and Random Exams
    • KCPE >
      • KCPE PAST PAPERS AND ANSWERS
    • KCSE >
      • KCSE BY SUBJECT >
        • KCSE PAST PAPERS BY SUBJECT
        • Free KCSE Past Papers Mathematics
        • Free KCSE Biology Questions and Answers
      • KCSE BY YEAR >
        • KNEC KCSE PAST PAPERS, MARKING SCHEMES, QUESTIONS & ANSWERS
    • QUESTIONS & ANSWERS >
      • SECONDARY >
        • LANGUAGES >
          • ENGLISH POETRY QUESTIONS WITH ANSWERS FOR K.C.S.E CANDIDATES
        • TECHNICALS >
          • COMPUTER STUDIES >
            • COMPUTER STUDIES Q & A
            • kcse computer studies paper 2 AND 3 Questions & Answers
          • BUSINESS STUDIES QUESTIONS & ANSWERS
          • KCSE AGRICULTURE TOPICAL QUESTIONS
          • KCSE HOME SCIENCE DIRECT QUESTIONS AND ANSWERS
        • SCIENCES >
          • KCSE Mathematics Topical Questions
          • KCSE Biology Topical Questions and Answers
          • CHEMISTRY TOPICAL QUESTIONS AND ANSWERS
          • KCSE Physics Topical Questions
          • KCSE physics Practical Sample Quiz
        • HUMANITIES >
          • ISLAMIC RELIGIOUS EDUCATION (IRE) QUESTIONS AND ANSWERS
          • C.R.E (CRE) QUESTION AND ANSWERS
          • KCSE History Topical Questions and Answers
          • GEOGRAPHY TOPICAL QUESTIONS AND ANSWERS
      • PRIMARY >
        • Standard 4-8 Mathematics Topical Questions from Mocks and KCPE
        • Std 6 Mathematics Notes
  • HIGH INSTITUTIONS
    • EXAMINATIONS >
      • College and Varsity Past Papers online >
        • College and Varsity Past Papers online
    • TUTORIALS
  • PRICING
  • BLOGS
    • Contact
    • Help & Support
    • MPESA FORM
  • Search Free Documents (PDF)