Chapter One
Chapter Two
Chapter Three
Chapter Four
Miscellaneous
100
Another name for a worksheet.
What is a spreadsheet?
100
A graphic representation of data in a worksheet that shows comparisons, patterns, and trends.
What is a chart?
100
A temporary storage area for text and graphics?
What is clipboard?
100
An Excel function that determines the largest value in a selected range of values.
What is MAX?
100
If a workbook contains grouped worksheets, this displays on the title bar.
What is [group]?
200
The column letter and row number that identify a cell.
What is a cell address?
200
A commnand with which you can display text on multiple lines within a cell.
What is text wrap?
200
The labels along the lower border of the workbook window that identify each worksheet.
What is sheet tabs?
200
Conditions that you specify.
What is criteria?
200
This command ensures that header rows and columns remain visible when a worksheet is scrolled.
What is freeze panes?
300
The small black square in the lower right hand corner of the active cell.
What is a fill handle?
300
The box that identifies the patterns or colors assigned to the data series in a chart.
What is a legend?
300
In a chart, the legend can be located here.
What is the top of the chart?
300
A column in an Excel table that uses a single formula that adjusts for each row.
What is a calculated column?
300
Changes made in a detail worksheet will automatically recaluculate and display on this sheet.
What is summary?
400
=SUM(B4:B7)
What is a function?
400
A cell reference that refers to a cell by its fixed position in a worksheet and that does not change when the formula is copied.
What is absolute cell reference?
400
When pasting a range of cells, this cell needs to be selected in the paste area.
What is top left cell?
400
After sorting, filtering, and totaling an Excel table, an Excel table can be converted into this.
What is a range?
400
A green triangle in a formula.
What is an error indicator?
500
Page headers and footers can be changed in this view.
What is Page Layout view?
500
A chart placed on a worksheet with the source data.
What is an embedded chart?
500
A chart type that is useful when you want to compare values across categories.
What is a clustered bar chart?
500
This word describes a function that is updated each time a workbook is opened.
What is volatile?
500
These symbols are inserted into logical funcions to determine whether a condition is true or false.
What is comparison indicators?
M
e
n
u