Term
|
Definition
Keeping a cell reference constant when copying a formula.
Absolute information does NOT change when copied. |
|
|
Term
|
Definition
| a spreadsheet function that indicates the average of a group of numbers in a range. |
|
|
Term
|
Definition
the cell in which you are currently working
it has a black border to show that it is being used |
|
|
Term
|
Definition
A value needed to calculate a function.
For example: the function COUNT needs cell references as the arguments: = COUNT (A2:D6) |
|
|
Term
|
Definition
| represents different quantities by using bars |
|
|
Term
|
Definition
the point where a column and row intersect
The letter of the column (vertical) comes first then the row (horizontal) number
Example C10 |
|
|
Term
| Cell Address/Cell Reference |
|
Definition
the location of a cell as identified by the column letter and row number
Example D15 |
|
|
Term
|
Definition
occurs when a formula in a spreadsheet refers to itself.
No result is possible and a warning appears. |
|
|
Term
|
Definition
Vertical sections of a spreadsheet
Identified by a letter |
|
|
Term
|
Definition
| a spreadsheet function that counts the number of cells in a range that contains data |
|
|
Term
|
Definition
statement that performs a calculation with either a
+ - * or / |
|
|
Term
|
Definition
| the bar where data entered from the keyboard is displayed as it is entered into the cell |
|
|
Term
|
Definition
built-in formulas used with a range to perform calculations
follow the PEMDAS guidelines |
|
|
Term
|
Definition
| a logical function (formula) that allows the user to set up a condition to test data |
|
|
Term
|
Definition
Alphabetical text in a spreadsheet
can have a combination of numbers with it as long as it is NOT used in a calculation--used for identification only |
|
|
Term
|
Definition
| a paper orientation that is wider than it is tall |
|
|
Term
|
Definition
| a type of graph that shows changes in data over a period of time |
|
|
Term
|
Definition
a spreadsheet function that indicates the highest value in a range
|
|
|
Term
|
Definition
| a spreadsheet function that indicates the lowest value in a range |
|
|
Term
|
Definition
A symbol that represents a mathematical funtion.
Examples: greater than, less than, greater than, or equal to |
|
|
Term
|
Definition
| a type of graph that divides the total into the parts of a circle |
|
|
Term
|
Definition
| A paper orientation that is taller than it is wide. |
|
|
Term
|
Definition
A group of cells closely related
It has a beginning cell address; separated by a colon (:) and an ending cell address
Example: E1:E14 or A1:G1 |
|
|
Term
|
Definition
Adjusts the cell references in a formula while retaining the mathematical processes.
It changes as it is copied. |
|
|
Term
|
Definition
Horizontal sections of a spreadsheet
Identified by a number
|
|
|
Term
|
Definition
A row and column arrangement of data used to enter, calculate, manipulate, and analyze numbers.
They are used to prepare budgets, financial statements, and inventory management.
They are also used to make forecasts. |
|
|
Term
|
Definition
| A function used to add numbers in a range |
|
|
Term
|
Definition
| a number entered into a spreadsheet used for calculations |
|
|
Term
|
Definition
| A spreadsheet tool used to play out different situations to determine outcomes. |
|
|
Term
| What question can be asked of a spreadsheet years after it is created? |
|
Definition
|
|
Term
| A business use of spreadsheet is |
|
Definition
| keeping track of company payroll |
|
|
Term
| Personal use of a spreadsheet is |
|
Definition
| predicting entertainment expenses |
|
|
Term
| Spreadsheet software is used to |
|
Definition
| answer "What-if" scenarios |
|
|
Term
| A major use of spreadsheet is answering |
|
Definition
|
|
Term
| An advantage of spreadsheets is its speed of |
|
Definition
|
|
Term
| To create a chart of business expenses, one would use |
|
Definition
|
|
Term
| An advantage of spreadsheet software is that it can |
|
Definition
| answer "What-if" questions |
|
|
Term
| The fastest way to calculate your current grade average and average after making up missing assignments is |
|
Definition
|
|
Term
| For inventory data and tracking purchasing trends, use |
|
Definition
|
|
Term
| For recording data over a two-week period of time, and then creating a graph, use |
|
Definition
|
|
Term
| To compute or calcuate company payroll, use |
|
Definition
|
|
Term
| an application software program that is made up of rows and columns that form cells is |
|
Definition
|
|
Term
| A school secretary could keep up with a record of student fees by using a |
|
Definition
|
|
Term
| To determine the average of a student's work, use |
|
Definition
|
|
Term
| A major advantage of spreadsheet software is its ability to |
|
Definition
| answer "What-if" questions |
|
|
Term
| The cell reference for an active cell is displayed |
|
Definition
| in the address box of a spreadsheet application software program |
|
|
Term
| The toolbar that displays the contents of the active cell is |
|
Definition
|
|
Term
The toolbar that has icons that are frequently used for formatting the appearance of a spreadsheet is
|
|
Definition
|
|
Term
| The toolbar that has icons for commands that are used frequently is |
|
Definition
|
|
Term
The first cell on a worksheet or spreadsheet is location in column A and row 1. The cell reference is |
|
Definition
|
|
Term
| The point at which a column and row meet is called a |
|
Definition
|
|
Term
Cells containing numeric information that can be used for calculations is called
|
|
Definition
|
|
Term
| Cells that contain alphabetic information or numbers, not used in calculations, are called |
|
Definition
|
|
Term
| A cell that is highlighted or outlined with a black border is referred to as an |
|
Definition
|
|
Term
| The column letter and row number make up the |
|
Definition
|
|
Term
| The horizontal portion of a spreadsheet identified by a number is called a |
|
Definition
|
|
Term
| The vertical portion of a spreadsheet that is identified by a letter is called a |
|
Definition
|
|
Term
| The cell in which you are currently working is known as an |
|
Definition
|
|
Term
| The shortcut formula for common calculations in a spreadsheet is called a |
|
Definition
|
|
Term
| A statement that performs a calcuation ( + - * or /) in a spreadsheet is called a |
|
Definition
|
|
Term
| Numerical data entered into a spreadsheet is called a |
|
Definition
|
|
Term
| Alphabetical tex entered into a spreadsheet is called a |
|
Definition
|
|
Term
| The intersection of a column and row is called a |
|
Definition
|
|
Term
| A shortcut formula for common calculations is called a |
|
Definition
|
|
Term
| A mathematical operation that is built into a spreadsheet program to perform shortcut calculations is called a |
|
Definition
|
|
Term
| Cells that need to remain the same when copied are called |
|
Definition
|
|
Term
| Cells that automatically change when copied are called |
|
Definition
|
|
Term
| To see the results of a formula, you press |
|
Definition
|
|
Term
| When keying a formula in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text? |
|
Definition
|
|
Term
| This function rounds a number to a specified number of digits |
|
Definition
|
|
Term
| This function rounds a number to a specified number of digits |
|
Definition
|
|
Term
Which function specifies a logical test to perform then performs one action if the test result is true and another if it is not true?
|
|
Definition
|
|
Term
| Which funtion will count the number of cells in a range? |
|
Definition
|
|
Term
| Which function would be used to indicate the smallest value in a range of spreadsheet cells? |
|
Definition
|
|
Term
| Which function would be used to indicate the largest value in a range of spreadsheet cells? |
|
Definition
|
|
Term
| Which function would be used to add a range of cells in a spreadsheet? |
|
Definition
|
|
Term
| What should you do to save revisions that you have made to an existing spreadsheet? |
|
Definition
| Save the revised spreadsheet |
|
|
Term
| In spreadsheets, the asteris and diagonal stand for what mathematical symbols? |
|
Definition
* is multiplication
/ is division |
|
|
Term
| The MOST appropriate time to establish a file name and save the spreadsheetfor the first time is |
|
Definition
| When you begin the spreadsheet |
|
|
Term
|
Definition
compare groups of similar data
displays bars side by side
used to show amounts of money spent on groceries in a certain month
used to compare individual values to each other
|
|
|
Term
|
Definition
show changes over a period of time
used to track and compare measurements, such as temperatures, and show trends and comparisons
used to display football statistics to compare the performance of the team from year to year
|
|
|
Term
|
Definition
show data as part of a whole
shows percentages
compare values that represent parts of a whole |
|
|
Term
|
Definition
small lines that mark a unit of measurement |
|
|
Term
|
Definition
small black square that surround a chart when selected |
|
|
Term
|
Definition
the horizontal (bottom) edge of the plot area |
|
|
Term
|
Definition
the vertical (left) edge of the plot area |
|
|
Term
| What is the first step in creating a chart of graph? |
|
Definition
Select the data you wish to plot |
|
|
Term
|
Definition
A series of dialog boxes used to provide steps in creating a chart |
|
|
Term
| The three most common types of charts used to illustrate spreadsheet data are: |
|
Definition
|
|
Term
|
Definition
is a way of presenting and comparing data in graphic format
|
|
|
