This site is 100% ad supported. Please add an exception to adblock for this site.

Excel 2003: Creating a Worksheet and Embedded Chart

Terms

undefined, object
copy deck
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 + `

Deck Info

36

permalink