WorksheetsFundamentals of Computing Excel Vocabulary
Total questions: 24
Worksheet time: 15mins
Identifies the active worksheet in the workbook.
Title Bar
Sheet Tab
Workbook
Cell Reference Box
The point at which a column or row meet in a spreadsheet.
Active Cell
Connection
Cell
Box
Displays the application and current worksheet name.
Rows
Sheet Tab
Label
Title Bar
Contains the drop-down menu commands
Provides easy access to frequently used commands
Formatting Toolbar
Chart
Cell Reference Box
Scroll
Identifies the active cell by the letter of the column and the number of the row that it intersects.
Page Layout View
Cell Reference Box
Active Cell
Sorting
Displays the contents of the active cell and is used to create or edit text or values.
Value
Rows
Worksheet
Formula Bar
Highlighted with a thick border; stores information that is entered while it is active.
Portrait
Active Cell
Cell Reference
Name Box
Indicates various items of information such as scroll lock, number lock, or caps lock when active.
Menu Bar
Function
Columns
Status Bar
A function used to add values in rows or columns
Title Bar
Auto Sum
A point to point distance in a worksheet ~ A2:D5
Cell Range
Scroll Bar
An equation that calculates a new value from values currently in a worksheet.
(a)
The area on a spreadsheet that identifies the cell reference of the active cell.
Active Cell
Name Box
Numerical text in a spreadsheet
(a)
A toll used to drag the cell contents to fill the appropriate range.
Cell Reference Box
Border
Auto Fill
Cell Wraparound
A frame around selected text or objects
(a)
Divides the worksheet into pages
Page Layout View
Workbook
Information entered into the computer to be processed
(a)
In a spreadsheet, built-in formulas that are shortcuts for common calculations such as sum and average.
Function
Auto Sum
Alphabetical text in a spreadsheet
(a)
Arranging data according to some particular order, such as alphabetical or numbering.
Label
Sorting
Formula
Formatting Toolbar
Used to indicate the start of a formula
Number
Equal Sign
A page or worksheet rotated to it is wider than it is long
Portrait
Landscape
Horizontal
Vertical
A page or worksheet rotated to it is longer than it is wide
Portrait
Landscape
Horizontal
Vertical
