A spreadsheet Package is an application package that enables you to carry out numerical work easily and flexibly.
What is a Spreadsheet ?
100
1.label (text)
2.value (number)
3.formule
What is the three types of information the cell contains ?
100
A function is a predefined formula in Excel that can automaticallly calculate results , perform worksheet actions or assist with decision making based on the information provided in your worksheet .
What is a function ?
100
=worksheetname! cellrefrence
What is the formula to refer to a cell in another worksheet?
100
Select the data values you want to place in it .
What is the first step in creating a chart ?
200
It enables you to store numerical data and also formuale.
What does a spreadsheet enable you to store ?
200
A label can be used as a title or heading to describe an aspect of the worksheet .
What can a label be used as ?
200
answer : =
What does the SUM function start with ?
200
To sort means to arrange in order .
What does sorting mean ?
200
The data selected to create the chart.
What is the data range ?
300
1. Click start , then all programs.
What is the first step in starting excel ?
300
Value is the piece of data that can be used in a calculation.
Define value.
300
There are five functions .
1.SUM function
2.MAX function
3.MIN fuction
4.COUNT function
5.COUNTIF function
How many functions are there and list them ?
300
Ascending or Descending order.
Whatorder does a typical spreadsheet package enable you to sort data into ?
300
the vertical and horizontal line in which data is plotted.
What is the axes?
400
1. Displays name of program
2.Name of current workbook if it has been saved.
What are two functions of the title bar ?
400
+ , - , @ , =
What is the symbols a formula must start with to identify it as a formula?
400
Error messages will appear when you use incorrect synatax or try to do something that prevents Excel from calculating the formula.
What will error messages appear ?
400
1.Select a cell in the column you wish to sort.
2.Pull down data menu and select sort .
Give the first two steps to store data by multiple criteria.
400
It is called series .
What is the row or cloumn headings that make up the range of values from the worksheet that is used to create the graph called ?
500
1. Display a number of shortcut buttons and boxes for performing common Excel operations.
What does standard / formatting toolbars do ?
500
A range can be represented by the address of the first cell and last cell in a group of continuous cells.
What is a range represented by ?
500
eg. #VALUE!
This occurs when the wrong type of operand or argument is used.
Give an example of an error message and say what it is saying .