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

29/12/2020

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

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 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

ANALYSIS OF KCSE COMPUTER STUDIES TOPICAL QUESTIONS & REVISION KITS