NEW
Font size
WorksheetsNavigating Excel
Total questions: 20
Worksheet time: 10mins
Where data is entered, organized and calculated.
Worksheet
Formula Bar
Cell
Workbook
Displays the name or location of the active cell.
Name box
Formula bar
Column
Row
Where data and formulas are entered and edited, which then appears in the active cell.
Formula bar
Name box
Column
Cell
Vertical cells that are labeled by letters.
Columns
Rows
Sheet name tabs
Headers
Horizontal cells that are labeled by numbers.
Rows
Columns
Sheet name tabs
Cells
The intersection of a row and column, labeled by a letter and number.
Cell
Row
Column
Sheet name tab
Adjusts zooming in and out of a worksheet.
Zoom slider
Control key
Page view options
Status bar
Allows you to add and navigate through multiple worksheets.
Sheet tab control
Share control
View controls
Ribbon
Contains commonly used commands at the top of the application window.
Quick Access Toolbar
Ribbon
Program Windows Controls
Share Control
Groups of related tools organized within a set of tabs.
Ribbon
Drop-down menu
Toolbar
Quick Access Toolbar
Displays the ribbon's name and contains related groups of different tools and commands.
Tab
Group
Menu
Toolbar
Contains related features and tools organized within a ribbon's tab.
Group
Tab
Drop-down Menu
Icon
An interactive tool or picture that activates its feature when clicked.
Icon
Tab
Group
Dialog Box Launcher
Allows you to move, resize, and close the application window and customize the ribbon display options.
Program Window Controls
Quick Access Toolbar
Sheet Tab Control
Ribbon
Allows you to choose a command from a list of options.
Drop-down Menu
Tab
Group
Icon
Allows you to keep a portion of the worksheet visible while you scroll through the sheet.
Freeze Panes
Switch Windows
Custom View
New Window
Allows you to add rows and columns to your worksheet.
Insert Rows and Columns
Resize Rows and Columns
Insert Cells
Freeze Panes
Allows you to delete rows and columns from your worksheet.
Delete rows and columns
Freeze panes
Delete cells
Resize rows and columns
Allows you to widen or narrow the size of each row or column by clicking and dragging to a desired size.
Resize rows and columns manually
Resize rows and columns automatically
Freeze panes
Insert rows and columns
Allows you to widen or narrow the size of each row or column by double clicking to fit the contents automatically.
Resize rows and columns automatically
Resize rows and columns manually
Insert rows and columns
Freeze panes
