Management Functions
Management Structures
Leadership Qualities
Leadership Styles
Vocabulary
100
In an Excel worksheet, columns are referenced with ____, while rows are referenced with _____.
What are letters and numbers?
100
Excel’s Accounting number format adds ____ to the value in the cell.
What is a dollar sign and two decimal places, and a comma if needed.
100
When you change the color of the fill in a cell, you are changing this.
What is the background?
100
The Themes group is located in the ____ tab.
What is page layout?
100
The keyboard shortcut for cutting the selection and placing it on the Clipboard is this.
What is Ctl + X?
200
By default, Excel aligns values ____________.
What is to the right?
200
This tab allows you to change the page orientation from Portrait to Landscape
What is the page layout tab?
200
By default, Excel aligns date entries at the ____ of the column.
What is right edge?
200
____ view allows you to see your worksheet along with the print settings.
What is page layout?
200
Column, line, pie, bar, area, and scatter are types of Excel _______.
What are charts?
300
All formulas in Excel begin with this.
What is an equal sign?
300
Inserted rows are placed ____ the selected row(s) and inserted columns are placed to the ____ of the selected column(s).
What is above and left?
300
A ____ is used to display only certain records within a table that meet the specified criteria.
What is a filter?
300
A ____ is a user-created pop-up box containing text.
What is a comment?
300
A new Excel workbook initially contains this many sheets.
What is three?
400
Excel features built-in, preprogrammed formulas called these.
What are functions.
400
When copying or moving cells, if data already exists in the destination cells, Excel will do this.
What is replace the contents?
400
Holding down this key while dragging a sheet tab will create a copy of the worksheet in the new position.
What is the ctrl button?
400
Excel contains worksheets that are preformatted and contain text and formulas designed for specific uses. These worksheets are called ________.
What are templates?
400
When you click the Insert Worksheet button, the new worksheet is placed here.
What is at the end.
500
These are the five skills needed by managers.
What are problem solving, time-management, communication, task-oriented, human relations.
500
Excel’s PMT function returns a payment amount for a loan based on a fixed interst rate, fixed amount of time, and this.
What is amount/principal.
500
This type of Excel chart is used to depict trends and change over time intervals.
What is the line chart?
500
The first step in creating an Excel chart is to do this.
What is select the range of cells for the data?
500
Without pointing to it, how can you tell if a cell contains a comment?
What is a red triangle in the upper right corner?
M
e
n
u