Spreadsheet Vocab 1
#### error. What is the problem of this error?
•Problem: The column is not wide enough to display all the characters in a cell
What is a chart?
a visual display of data in a spreadsheet, also known as a graph
What is an active cell?
The cell ready for data entry.
How many data types are there in spreadsheets?
The three types of data you can enter into a cell are data, labels and formulas.
What is a label?
Text, symbol, date, or number not used in calculations.
# Div/0! Error. What is the problem of this error?
Problem: Excel displays this error when a number is divided either by zero (0) or an empty cell.
What is a spreadsheet?
a program that allows you to use rows and columns of data to manage, predict, and present information.
What is sort?
To arrange data in a column in a particular order (ascending/descending)
What is cell reference/address?
•A cell reference refers to a cell or a range of cells on a worksheet, A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet and can be used in a formula so that Microsoft Office Excel can find values or data that you want formula to calculate.
What is a formula?
Equations with symbols for mathematical operations, usually begins with equal signs. Ex =B6+B7
What is the difference between formula and function?
•Formulas: Are equations that perform calculations on values
•Functions: Are predefined as formulas that perform calculations by using specific values in a certain order
What is value?
A number entered into a spreadsheet cell that will be used for calculations.
Relative & Absolute references in spreadsheet?
Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.
What is spreadsheet is used for?
Name one disadvantage of spreadsheet?
Cannot create report and queries in a Spreadsheets.
What is a cell?
Intersection of row and a column and identified by a cell reference
Name one advantage of spreadsheet?
Advantage-Widely available
What is a column?
Identified by letters that appear at the top of the spreadsheet. (Vertical)
#NUM! error. What is the problem of this error?
Problem: The formula or function contains invalid numeric values
Fix using $, %, symbols with the number can result in this error, so avoid using this.