BITM TEST 1
values key points
-number -can be used in a calculation or be the result of a calculation
LABEL key points
-text -displays descriptive information
worksheet design steps
1. determine the purpose 2.decide what outputs are required to achieve the purpose of the worksheet 3.decide what input values are required
steps to enter and format the data
4. enter labels, values, and formulas 5.format the numeric values in the worksheet 6.format the descriptive titles and labels
steps to complete the workbook
7.check the spelling in the workbook 8.save and share the completed workbook
time is stored as a value TRUE OR FALSE
TRUE
range
a collection of chosen cells
GO TO is
a feature for navigating a specific cell
row heading are listed in what order and what are they ?
a number used to identify a row in a worksheet and are listed in sequential order on the left side
input area
a range of cells containing values for variables used in formulas
name box
a rectangular area that displays the address or name of there active cell
fill handle
a small green square in the bottom right corner of the active cell
Each element has
a special function that is used to perform each task
worksheet
a spreadsheet that usually contains descriptive labels, numeric values , formulas, functions and charts
cell reference
a unique identifier for a cell which is formed by combining the cell's column letter and row number
the worksheet currently displayed is called
active sheet
values
are numbers that represents a quantity or a measurable amount
how does excel treat phone numbers?
as text entries
the intersection of a column and a row is a
cell
each cell has a
cell address a unique identifier starting with its column letter and then its row number
why are cell reference useful ?
in formulas or navigation
how do you identify an active cell?
indicated by a dark green boarder
insert function fx
insert function command changes from gray to green when you position the pointer over it
workbook
is a collection of one or more related worksheets contained within a single file
Spreadsheet
is an electronic file that contains a grid of columns and rows to organize and to display results of calculations enabling interpretation of quantitative date for decision making
text
is any combo of letter, number, symbols and spacers not used in calculations
why is the GO TO helpful?
it is helpful when that cell is not visible onscreen or is many columns or rows away
flash fill can be used to
separate data in one column or combine data from multiple columns
formula bar
the contents of the active cell or the formula used to calculate the results of the active cell
output area
the range of cells in the worksheet that contain formulas dependent on the values in the input area
TRUE OR FALSE storing multiple worksheets within one workbook helps organize related data together in one file
true
flash fill
uses data from other columns to determine a pattern as you type and fills in results in the remaining row based on that pattern
Are column headings listed in alphabetical order ?
yes