|
(a) A company has decided to computerize their operations. They have decided to purchase packages instead of developing their own programs. Give three advantages and two disadvantages of this approach.
Advantages
0 Comments
(a) Distinguish between labels and formulae with respect to spreadsheet (2mks)
(b) Consider the entries in the cells below
(c) State the values displayed in cell C14 (2mks)
Error (#value) NB: the = sign is missing in cells C10 and C11
Explain data series, axis and legends as used in spreadsheet charts. Data, Axis and Legend29/12/2020 Explain data series, axis and legends as used in spreadsheet charts. Data, Axis and Legend
Data Series
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:
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
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
The Formula = k20 + p $18 was typed in cell L21 and then copied to cell M24 of a spreadsheet. Write the formula as it appears in cell M24 (2mks)
List any four tasks that an electronic spreadsheet should be able to perform other than calculations27/12/2020 (a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.
(b) Explain what is meant by automatic recalculation as used in a spreadsheet.
Feature of electronic spreadsheet system which runs anytime a cell is updated, causing all formulas, functions and macros which depend on that cell to automatically update their computations
The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet. Enter the formulae, as they would appear when copied to the cell M20 of the same spreadsheet.  The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet Expected Response
Andrew, Jane, David and Zablon had tea, sausages and bananas for breakfast. They took one sausage, two sausages, three sausages and one sausage respectively. In addition, they took a cup of tea and two bananas. Tea, sausages and bananas cost Kshs 10, 15 and 5 respectively.
By naming columns A, B, C … and rows 1, 2, 3 …………….
(a) Construct a worksheet showing the above information (7mks)
Types of data entries that may be input into a worksheet cell
Types of graphs that are supported by spreadsheets
Worksheet cells are referenced using the column letter and row number e.g. D2 is cell in column D and row 2.
a) Write down the data type that is stored in cell C5 (1mk)
b) What cell contains the data items representing transport for the month of February?
c) Write down the formula that may be used to compute the total in cell f6.
A spreadsheet has the following entries.  Provide a formula for cell c5 that can be copied onto cell d5 and the range c6...d10 to give a uniform increase of 10% of the previous years value for each item. Expected response WHAT ARE ELECTRONIC SPREADSHEETS? An electronic spreadsheet is a software with worksheets made of cells that can save, edit. format and manipulate numeric values automatically. WHAT ARE TYPEWRITERS? A typewriter is an analogous machine with keys for producing characters, numerals and symbols on a piece of paper. WHAT ARE THE MERITS OF SPREADSHEETS OVER TYPEWRITERS?
Images courtesy of Pinterest
Briefly explain the following terms: Cell, Range, Label, Value, FunctionExpected Response
 |
Categories
All
Archives
December 2024
|
RSS Feed