spread sheet operations
chart
graph
functions
references
100
A Sort is used to arrange data in alphabetical or chronological order
what is sort used for?
100
A Graph is a feature of a chart used to plot data.
what is a graph?
100
on a spreadsheet.
where do we use graphs?
100
SUM
what is the function that adds 2 numbers?
100
relative cell reference
Adjusts the cell references in a formula while retaining the mathematical processes?
200
-the days of the week -Months of the year -numerical numbers
What is a example of fill series?
200
A Chart is the total package that includes: -titles -values
what is a chart a total of?
200
graphs are used in business.
what is a graph used in?
200
count.
what is the function that counts your numbers?
200
cell address/cell reference.
he location of a cell as identified by the column letter and row number?
300
Primary sort – indicates the primary sort range of data
What does primary sort indicate?
300
y-axis and x-axis.
what are the grid lines called?
300
A pictorial representation of data.
what does graph represent?
300
5
how many functions are there?
300
circular reference
Occurs when a formula in a spreadsheet refers to itself. No result is possible and a warning appears?
400
Secondary sort – indicates the next sort range of date.
what does secondary sort indicate?
400
contribution of individual employee sales to the total sales.
what is a example of a chart?
400
MAX
The highest number? Function?
400
absolute cell reference
Keeping a cell reference constant when copying a formula?
500
the Fill Handle is used to create the continuation of a data series.
what is a fill handle used for?
500
For spreadsheets
What do we use charts for?
500
29,700
If there is 3 bars one equals 100 another equals 200 but the total is 30,000 what is the 3rd bar equal?
500
MIN
The lowest number, function?
500
For spreadsheets
what are references used for?
M
e
n
u