![Page 1: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/1.jpg)
VOCAB REVIEW
![Page 2: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/2.jpg)
letters at the top of the worksheet window that
identify the vertical information in a
worksheet
column headings
Click for the answer
Next Question
![Page 3: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/3.jpg)
small black square located in the lower-right corner of the heavy border around the active cell; used to
copy data into an adjacent cell
fill handle
Click for the answer
Next Question
![Page 4: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/4.jpg)
appears directly below the ribbon; displays a formula when the cell contains a calculated
value
formula bar
Click for the answer
Next Question
![Page 5: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/5.jpg)
grid of rows and columns where users enter,
calculate, manipulate, and analyze data such as
numbers or textworksheet
Click for the answer
Next Question
![Page 6: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/6.jpg)
worksheet cell reference that does not adjust to the
new cell location when copied or moved
absolute cell reference
Click for the answer
Next Question
![Page 7: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/7.jpg)
changing the value of only one cell referenced directly or indirectly to reach a specific goal for a value in another cell
goal seeking
Click for the answer
Next Question
![Page 8: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/8.jpg)
coordinates of the intersection of a column
and a row
cell reference
Click for the answer
Next Question
![Page 9: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/9.jpg)
equation that calculates a new value from values currently on a worksheet
formula
Click for the answer
Next Question
![Page 10: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/10.jpg)
area on the left side of the worksheet window that identifies the cell reference of the active
cell
name box
Click for the answer
Next Question
![Page 11: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/11.jpg)
numbers at the left side of the worksheet window
that identify the horizontal information in
a worksheetrow headings
Click for the answer
Next Question
![Page 12: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/12.jpg)
collection of related worksheets in Excel
workbook
Click for the answer
Next Question
![Page 13: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/13.jpg)
values that are used with a function
arguments
Click for the answer
Next Question
![Page 14: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/14.jpg)
range of data that will determine the values represented in a chart
data series
Click for the answer
Next Question
![Page 15: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/15.jpg)
chart drawn on the same worksheet as the data
embedded chart
Click for the answer
Next Question
![Page 16: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/16.jpg)
prewritten formula that is built into Excel
function
Click for the answer
Next Question
![Page 17: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/17.jpg)
printed across the width of the page
(page is longer than it is wide)
portrait orientation
Click for the answer
Next Question
![Page 18: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/18.jpg)
sums the numbers in the specified range then divides the sum by the number of non zero cells in the range
AVERAGE function
Click for the answer
Next Question
![Page 19: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/19.jpg)
displays the highest value in a range
MAX function
Click for the answer
Next Question
![Page 20: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/20.jpg)
entry point of a worksheet indicated by
a dark border
active cell
Click for the answer
Next Question
![Page 21: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/21.jpg)
displays the lowest value in a range
MIN function
Click for the answer
Next Question
![Page 22: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/22.jpg)
cell reference containing both
relative and absolute references
mixed cell reference
Click for the answer
Next Question
![Page 23: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/23.jpg)
printed across the length of the page (page is wider than it is long)
landscape orientation
Click for the answer
Next Question
![Page 24: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/24.jpg)
worksheet showing the results of the formulas
you have entered
values version
Click for the answer
Next Question
![Page 25: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/25.jpg)
worksheet cell reference that adjusts to a new location when
copied or moved
relative cell reference
Click for the answer
Next Question
![Page 26: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/26.jpg)
worksheet showing the formulas you have entered rather than the resulting values
formulas version
Click for the answer
Next Question
![Page 27: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/27.jpg)
a separate sheet in a workbook that contains only a chart
chart sheet
Click for the answer
Next Question
![Page 28: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/28.jpg)
program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish
organized data to the Web, and access real-time data from Web sites
Microsoft Office Excel
Click for the answer
Next Question
![Page 29: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/29.jpg)
assigns a value to a cell based on a logical test
IF function
Click for the answer
Next Question
![Page 30: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/30.jpg)
range of data that will determine the
headings for the values in a chart
category names
Click for the answer
Next Question
![Page 31: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/31.jpg)
displays number with dollar signs, comas,
and decimal points in the proper positions
accounting number format
Click for the answer
Next Question
![Page 32: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/32.jpg)
using Excel to scrutinize the impact of changing cell values that are referenced by a formula in another cell
What-if analysis
Click for the answer
Next Question
![Page 33: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/33.jpg)
displays commas and decimal points in their
proper positions
comma style format
Click for the answer
Next Question
![Page 34: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/34.jpg)
graphical representation of data
chart
Click for the answer
Next Question
![Page 35: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/35.jpg)
the basic unit of a worksheet; where you
enter data
cell
Click for the answer
Next Question
![Page 36: VOCAB REVIEW. letters at the top of the worksheet window that identify the vertical information in a worksheet column headings Click for the answer Next](https://reader035.vdocuments.us/reader035/viewer/2022062423/56649e4e5503460f94b4500e/html5/thumbnails/36.jpg)
displays the worksheet name
sheet tab
Click for the answer
Next Question