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