Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
36 Cards in this Set
- Front
- Back
A powerful speadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web and acces real-time data from Web sites is know as _________.
|
MICROSOFT EXCEL
|
|
The _______ _______ is a separate window displayed on the right side of the screen that enables users to cary out some Excel tasks more efficiently
|
TASK PANE
|
|
A ___________ contains buttons, boxes, and menus that allow you to perform tasks quickly.
|
TOOLBAR
|
|
Excel opens a new workbook with _____ sheets?
|
THREE
|
|
Each worksheet has a sheet name that appears on the _______ _______ at the bottom of the workbook.
|
SHEET TAB
|
|
A column ______ above each column identifies the column.
|
LETTER
|
|
A row ________ on the left side of the grid identifies each row.
|
NUMBER
|
|
A __________ is the basic unit of a worksheet into which you enter data.
|
CELL
|
|
The ______ ______ is identified in a worksheet by a heavy border that surrounds the cell.
|
ACTIVE CELL
|
|
The horizontal and vertical lines on the worksheet itself are called _________.
|
GRIDLINES
|
|
The ______ ______ appears below the Standard and Formatting toolbars. As you type, Excel displays the entry here.
|
FORMULA BAR
|
|
Excel displays the active cell reference in the _____ ______ on the left side of the formula bar.
|
NAME BOX
|
|
The _____ _____ displays a brief descripton of the command selected (highlighted) on the menu, the function of the button the mouse pointer is pointing to or the mode of Excel.
|
STATUS BAR
|
|
The _________ _________, located in the middle of the status bar, can be used in place of a calcular or formula to view the sum, average, or other types of totals of a group of numbers in the worksheet.
|
AUTOCALCULATE AREA
|
|
In Excel, any set of characters containing a letter, hyphen, or space is considered ______.
|
TEXT
|
|
The _______ ______ is a blinking vertical line that indicates where the next typed character will appear.
|
INSERTION POINT
|
|
Text is _______ aligned in a cell.
|
LEFT
|
|
Numbers are ______ aligned in a cell.
|
RIGHT
|
|
To enter a number as text, start the entry with an ________.
|
APOSTROPHE
|
|
Excel's _______ ______ adds all of the numbers in a range.
|
SUM FUNCTION
|
|
A ________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
|
RANGE
|
|
Double-clicking the _______ button on the standard toolbar automatically inserts the SUM function into the cell and adds up the corresponding column or row of values.
|
AUTOSUM
|
|
When copied, a _________ cell reference adjusts to its new location in the spreadsheet.
|
RELATIVE
|
|
The _______ ______ is the small black square located in the lower right corner of he heavy border around the active cell.
|
FILL HANDLE
|
|
To determine muliple totals at the same time, ________ the range and then click the Autosum button on the standard toolbar.
|
SELECT
|
|
You ________ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
|
FORMAT
|
|
The _____ type defines the appearance and shape of the letters, numbers, and special characers.
|
FONT
|
|
Click the _______ ______ _______ button on the formatting toolbar to center text across a selected range of cells.
|
MERGE AND CENTER
|
|
An ________ is a built-in collection of formats such as font style, font color, borders, and alignment, which you can apply to a range of cells.
|
AUTOFORMAT
|
|
You use the _______ command on the ______menu to apply an autoformat to a selected range of cells
|
Autoformat
Format |
|
An _______ chart is drawn on the same worksheet as the data.
|
EMBEDDED
|
|
Excel automatically selects the entries in the topmost row of the chart range as the titles for the __________ axis.
|
CATEGORY
|
|
Excel derives the chart scale based upon the values in the worksheet and then displays the scale along the ________ axis.
|
VALUE
|
|
In a chart, the small boX to the right of the chart contains the _______, which identifies the colors assigned to each bar in the chart.
|
LEGEND
|
|
The default chart type is the _____ ______ chart.
|
2-D COLUMN
|
|
To display formulas in a worksheet press _____ + _____.
|
CTRL + `
|