click below
click below
Normal Size Small Size show me how
spreadsheet 1
vocab
Question | Answer |
---|---|
a grid of rows and columns that can store and manipulate data | spreadsheet |
Spreadsheets are divided into _____ and ______ | rows and columns |
Data is stored in the intersection of these rows and columns | cells |
the entry point of a spreadsheet | highlight |
a cell that is currently available for use | active cell |
an area on the spreadsheet that identifies the location of the active cell | cell reference block (name box) |
the line in a spreadsheet where you can make changes to data in a cell | edit line |
the line in a spreadsheet where you can enter data in a cell | entry line |
the line in a spreadsheet where you can enter a formula in a cell | formula bar |
a block of continuous cells that can be manipulated together | range |
vertical and are identified by letters | columns |
horizontal and are identified by numbers | rows |
three types of data | values, labels, formulas |
data that appear in the form of numbers | values |
data that appear in alphabetic form | labels |
mathematical expressions that use values in a spreadsheet in calculations | formulas |
a reference to a cell in a formula that will not adjust when it is copied from one cell to another | absolute cell reference |
specials formulas that do not use operators to calculate a result | functions |
(+-*/) are symbols that indicate what math function will be performed | math operators |
numbers or cell references used in a formula | operands |
list the order of operations | PEMDAS- parentheses, exponents, multiply, divide. add, subtract |