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 + `