Excel Chapter 5 – Flashcards
Unlock all answers in this set
Unlock answersquestion
3-D range
answer
a range that spans two or more worksheets in a workbooks such as 'Westgate Mall: Reston Plaza '! C6 is called a 3-D range.
question
3-D reference
answer
the reference to this range is a 3-D reference.
question
arranged
answer
the located workbooks then are opened and arranged so that each one appears in its own window.
question
auto fill series
answer
(1,1,1 ETC)
question
consolidation
answer
the process of summarizing data gathered form multiple worksheets on one worksheet is called consolidation.
question
custom format codes
answer
allow you to specify how a cell entry assigned a format will appear.
question
date series
answer
(Jan, Feb, Mar, etc.)
question
dependent workbook
answer
If you open the Williams Consolidated Expenditures workbook by itself, also called the dependent workbook...
question
drilling an entry
answer
to speed data entry, Excel allows you to enter a number once and copy it through worksheets so that it is entered in the same cell on all the selected worksheet.
question
growth series
answer
multiplies values by a constant factor.
question
linear series
answer
(1,2,3, etc. or 2,4,6)
question
link
answer
reference to a cell or range of cells in another workbook.
question
page breaks
answer
on formulas that potentially can result in more decimal places than the applied format displays in a given cells.
question
page setup
answer
which defines the appearance and format of a printed worksheet.
question
ROUND function
answer
used to round numbers to a specified number of decimal places.
question
source workbooks
answer
the linked workbooks are called he source workbooks.
question
style
answer
group of format specifications that are assigned to a style name
question
worksheet reference
answer
to reference cells in other worksheets in workbook, you use the worksheet name, which serves as the worksheet reference, and the cell reference.
