click below
click below
Normal Size Small Size show me how
Unit 1 Spreadsheet
Question | Answer |
---|---|
grid of rows and columns that can store and manipulate data | spreadsheet |
vertical and identifies by letters | columns |
horizontal and identified by numbers | rows |
intersection of these rows and columns | cells |
entry point of a spreadsheet | highlight |
lines in spreadsheets that form cells | grids |
allows you quick and easy access | ribbon |
cell that is currently available for use access also the highlighted cell | active cell |
an area on the spreadsheet that identifies the location of the active cell contains address of active cell | cell reference block or name block |
a line in a spreadsheet that you can make changes to data in a cell | edit line |
is the line in a spreadsheet where you can enter data into a cell | entry line |
the line in a spreadsheet where you can enter a formula in a cell | formula bar |
a group of cells that can be manipulated together | range |
data that appear in form of numbers | values |
data that appear in alphabetic for | labels |
mathematical expressions that use values in a spreadsheet in calculations | formulas |
a reference to a cell in a formula that will adjust when it is copied from one cell to another | relative cell reference |
reference to a cell in a formula that will not adjust when it is copied from one cell to another ($) | absolute cell reference |
are special formulas that do not use operators to calculate a result | functions |
(+-*/) are symbols that indicate what math function will be performed | math operators |
Operands are numbers or cell references used in a formula ex b12 | operands |