NEW
Font size
WorksheetsMicrosoft Excel Review
Total questions: 31
Worksheet time: 22mins
The cell in the worksheet in which you can type data.
Active Cell
Formula
Landscape
Range
The intersection of a column and a row in a table or worksheet.
Workbook
Column
Sheet Tab
Cell
A unique identifier for a cell, which is formed by coming the cells's column letter and row numbers.
IF Function
Cell Reference
Pivot Table
AutoSum
A vertical stack of cells in a table or worksheet.
Sheet Tab
Row
Column
Range
An equation that calculates a new value from values currently in a worksheet.
Formula
Active Cell
Row
Spreadsheet
The box that displays a formula when the cell of a worksheet contains a calculated value.
Portrait Orientation
Formula Bar
Fill Handle
Cell Reference
A page or worksheet rotated so it is wider than it is long.
Landscape Orientation
Portrait Orientation
Spreadsheet
Workbook
A spreadsheet program used to store inventory. Payments, grades, etc
Microsoft Word 2016
Publisher
Microsoft Excel 2016
Google Docs
A page or worksheet rotated so it is longer than it is wide. (Default page orientation)
Range
Landscape
Spreadsheet
Portrait
A group of selected cells.
Absolute Cell Reference
Range
Formula Bar
Cells
The horizontal placement of cells in a table or worksheet.
Column
Row
Sheet
Cell Reference
The worksheet identifier that appears at the bottom of the workbook window
Sheet Tab
Workbook
Border
Number Format
A grid of rows and columns in which you enter text, numbers, and the results of calculations.
Absolute Cell Reference
Cell Style
Theme
Spreadsheet
The file used to store worksheets; usually a collection of related worksheets.
Range
AutoSum
Workbook
Chart
A computerized spreadsheet in Excel.
Worksheet
Workbook
Style
Theme
A line around the edges of a cell.
Cell Reference
Fill Handle
Cut
Border
A collection of formatting characteristics you apply to a cell or range of data.
Cell Style
Font
Workbook
AutoSum
The design of text.
Font
Cell
Range
Merge
To combine multiple cells into one cell.
Absolute Cell Reference
Theme
Merge
Pivot Table
Formatting option that changes the way numbers/data look in a cell.
Copy
Merge
Formula
Number Format
A set of formatting options that have been named and saved.
Worksheet
Style
Cut
Range
A preset collection of design elements, including fonts, colors, and other effects.
Theme
Copy
Merge
IF Function
To place a copy of selected text on the Clipboard or the Office Clipboard.
Paste
Copy
Cut
Formula
To remove selected text and place it on the Clipboard or the Office Clipboard.
Copy
Paste
Fill
Cut
The small square in the lower-right corner of the active cell or range that you drag over the cells you want to fill.
Fill Handle
Sheet Tab
Cell
Formula
A cell reference that does not change when copied or moved to a new cell. Uses the $ symbol. Between the column letter & row number
Cell Reference
Auto Sum
Absolute Cell Reference
Merge
A button on the Ribbon that inserts the Sum function to add long columns or rows of numbers.
Average
IF Function
Formula Bar
AutoSum
An equation that calculates a new value from values currently in a worksheet.
Formula
Chart
Table
Range
A visual representation of worksheet data
Spreadsheet
Chart
Copy
Fill Handle
Allows you to summarize complex data. It makes large collections of data easier to analyze.
Pivot Table
IF Function
Columns
Cell Reference
A logical function that asks Excel to perform one of two different calculations based on whether your data matches a logical test.
Formula
AutoSum
IF Function
NOW()
