34 terms

Accountancy 2258

microsoft excel
a spreadsheet software program that is widely used for personal, educational, and business purposes
excel workbook
an Excel file containing one or more related worksheets
excel worksheet
a single spreadsheet in an Excel workbook that can be used to display various types of data and/or graphics
an element of an Excel worksheet that is created by the intersection of a row and column
light blue lines on an Excel worksheet that show users the boundaries for each cell
cell address
indicates where each cell is located by identifying the column and row that intersect to create the cell
active cell
the cell that is currently selected on an Excel worksheet. The active cell has a dark black border around it
name box
displays the cell address of the active cell or the name of a selected cell or range of cells that has been named
range of cells
a group of two or more adjacent cells
quick access toolbar
a toolbar located in the upper-left corner of Excel that provides you with buttons for the Excel commands that are most frequently used
the area above an Excel worksheet that contains all of the Excel commands, which allow users to perform tasks as they work with data in Excel
used to organize the commands by category on the Ribbon. The default tabs displayed on the Ribbon in Excel are: File, Home, Insert, Page Layout, Formulas, Data, Review, and View
used to classify similar commands that perform related tasks on each tab. The name of each group is displayed across the bottom of the group
live preview
a special Excel feature that allows the user to move the mouse pointer over an option and see the effect it would have on the worksheet before selecting that option
used for some Excel commands to display small graphic visuals that show the effect each option would have on the worksheet
dialog box launcher
a button located on the Ribbon that opens up a dialog box when clicked on
dialog box
a window that contains a set of options for one or more Excel commands
excel help
provides the user with assistance on how to work in Excel and how to use Excel features and functions
enhanced screen tips
provide the name of each command, what shortcut key, if any, can be used to automatically activate the command, and a description of what that command does
shortcut keys
allow the user to activate a command using specified keys on the keyboard rather than pressing the command button on the Ribbon or a toolbar
formula bar
displays the data the user has entered into the active cell
mini toolbar
pops up when you right-click on a cell in an Excel worksheet and contains the command buttons for several commonly used formatting commands to reduce mouse movement
shortcut menu
pops up when you right-click on a cell in an Excel worksheet and displays a list of several other commonly used commands that aren't shown in the Mini Toolbar
status bar
is located at the very bottom of the Excel workbook, indicates what mode you are in, provides summary information about selected cells containing data, allows you to change the view of your worksheet, and provides zoom options
zoom level
is located on the right side of the Status Bar, displays the current magnification percent, and can be clicked on to make changes to the magnification percent
zoom slider
allows the user to change how much of the worksheet is viewed on the screen and how small or large the data appears
name manager
allows you to manage all of the names you create in a workbook. With the Name Manager, you can create additional names, edit names, and delete names
format cells dialog box
dialog box containing all of the options available for formatting cells in an Excel worksheet
button located in the Alignment group on the Home tab that rotates data so it is presented diagonally or vertically in a cell
number formatting option that displays a numerical value with two numbers after the decimal place
number formatting option used for monetary values to line up the currency symbols and decimal points, with the currency symbols displayed on the far left side of each cell (separate from the monetary value)
number formatting option used for monetary values to line up the currency symbols and decimal points, with the currency symbols displayed just to the left of the monetary value in each cell
format painter
copies the formatting from one cell and applies that formatting to a specified cell or range of cells
clear content, clear format, clear all
self explanatory