Computer studies analysis of questions and answers

Give any two types of data entries that may be input into a worksheet cell.

22/12/2020

0 Comments

Types of data entries that may be input into a worksheet cell

Number
Text
Formula
Function
Date and Time

0 Comments

Name any two types of graphs that are supported by spreadsheets

21/12/2020

0 Comments

Types of graphs that are supported by spreadsheets

Column
Line
Pie
Bar
Area
XY (Scatter)
Stock
Surface
Doughnut
Bubble
Radar

0 Comments

Worksheet cells are referenced using the column letter and row number e.g. D2 is cell in column D and row 2.

21/12/2020

0 Comments

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)

It contains the data items representing transport for the month of February?

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.

= sum (B6: E6)

0 Comments

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.

18/4/2019

0 Comments

Previously: state advantages and disadvantages of laser printers

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

next: functions of a computer ...

0 Comments

ADVANTAGES OF ELECTRONIC SPREADSHEETS OVER TYPEWRITERS

1/4/2019

0 Comments

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?

Electronic spreadsheets have inbuilt formula and functions that enhances accuracy and efficiency. Typewrites don't
Electronic spreadsheets produces neat work because all editing is done on the screen before the final copy is printed.
Electronic spreadsheets have inbuilt formatting features such as:
1. change color
2. bolding
3. underline
4. italics
5. font size etc.
Electronic spreadsheets special editing features such as:
1. alignment
2. spacing
3. spelling and grammar checkers
4. page layout
5. background appearance etc.
Electronic spreadsheets allow users to work with graphics and images to represent data.
Electronic spreadsheets can be transmitted from one place to another quickly and electronically
Electronic spreadsheets have inbuilt security and privacy measures to protect data
Electronic spreadsheets can be reprogrammed to meet certain demands and standards of an organization.
Electronic spreadsheets can be imported or exported between machines. This allows the user to share sheets in multiple software packages of the same type or different types
Electronic spreadsheets have special pre-edited sheets called templates that makes user's work easier.
Electronic spreadsheets are empowered with database features that lets the user search, sort and manipulate data easily. such as:
1. find and select
2. sorting
3. filtering
4. automatic recalculations (forecasting)
Electronic spreadsheets allow users to insert comments such as users instructions and help
Electronic spreadsheets allow users to create, save, retrieve and print worksheets

Images courtesy of Pinterest

0 Comments

What is a cell in relation to Spreadsheets?

6/11/2018

0 Comments

Briefly explain the following terms: Cell, Range, Label, Value, Function

Expected Response

A cell is an editable area of a spreadsheet where a column meets a row. Editable in this case means where the user can enter text.
Contents in a cell can either be values, labels or formula/function

a Value is a figure which can be mathematically manipulated
labels are not mathematically manipulated
Formula/Functions are instructions used to manipulate values and return a feedback
- However a function is in-built while a formula is user defined.
A group of two or more cells make up a range.

Atika School Provides Computer studies questions and answers for KCSE preparations and Computer Science for CBC.

Give any two types of data entries that may be input into a worksheet cell.

Types of data entries that may be input into a worksheet cell

Name any two types of graphs that are supported by spreadsheets

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.

A spreadsheet has the following entries.

Expected response

ADVANTAGES OF ELECTRONIC SPREADSHEETS OVER TYPEWRITERS

WHAT ARE ELECTRONIC SPREADSHEETS?

WHAT ARE TYPEWRITERS?

WHAT ARE THE MERITS OF SPREADSHEETS OVER TYPEWRITERS?

What is a cell in relation to Spreadsheets?

Briefly explain the following terms: Cell, Range, Label, Value, Function

Expected Response

State two advantages of electronic spreadsheets over manual worksheets

Categories

Archives

Atika School Provides Computer studies questions and answers for KCSE preparations and Computer Science for CBC.

Give any two types of data entries that may be input into a worksheet cell.

Types of data entries that may be input into a worksheet cell

Name any two types of graphs that are supported by spreadsheets

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.

A spreadsheet has the following entries. ​

Expected response

ADVANTAGES OF ELECTRONIC SPREADSHEETS OVER TYPEWRITERS

WHAT ARE ELECTRONIC SPREADSHEETS?

WHAT ARE TYPEWRITERS?

WHAT ARE THE MERITS OF SPREADSHEETS OVER TYPEWRITERS?

What is a cell in relation to Spreadsheets?

Briefly explain the following terms: Cell, Range, Label, Value, Function

Expected Response

State two advantages of electronic spreadsheets over manual worksheets

Categories

Archives

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.