Accountancy 2258

34 terms by lillypad91 

Ready to study?
Start with Flashcards

Create a new folder

Advertisement Upgrade to remove ads

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

cell

an element of an Excel worksheet that is created by the intersection of a row and column

gridlines

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

ribbon

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

tabs

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

groups

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

gallery

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

orientation

button located in the Alignment group on the Home tab that rotates data so it is presented diagonally or vertically in a cell

number

number formatting option that displays a numerical value with two numbers after the decimal place

accounting

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)

currency

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set