CH 1: Introduction to Excel
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Accounting Number Format | show 🗑
|
||||
| Active cell | show 🗑
|
||||
| Alignment | show 🗑
|
||||
| show | A feature that searches for and automatically displays any other label in that colums that matches the letters you typed.
🗑
|
||||
| show | A feature that enables you to copy the contents of a cell or a range of cells to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.
🗑
|
||||
| Border | show 🗑
|
||||
| show | The intersection of a column and row in a worksheet.
🗑
|
||||
| Cell address | show 🗑
|
||||
| show | The alphabetical letters above the columns in a worksheet.
🗑
|
||||
| Column width | show 🗑
|
||||
| Comma Style | show 🗑
|
||||
| Fill color | show 🗑
|
||||
| Fill handle | show 🗑
|
||||
| Formula | show 🗑
|
||||
| Formula bar | show 🗑
|
||||
| Horizontal alignment | show 🗑
|
||||
| Indent | show 🗑
|
||||
| show | A range of cells in a worksheet used to store and change the variables used in calculations.
🗑
|
||||
| show | An identifier that displays the address or the range name of the current cell in an Excel worksheet.
🗑
|
||||
| Nonadjacent range | show 🗑
|
||||
| Normal view | show 🗑
|
||||
| Number formats | show 🗑
|
||||
| show | A set of rules that determines the sequence by which operations are calculated in an expression.
🗑
|
||||
| Output area | show 🗑
|
||||
| Page Break Preview | show 🗑
|
||||
| Page Layout view | show 🗑
|
||||
| Paste Options button | show 🗑
|
||||
| Percent Style | show 🗑
|
||||
| Pointing | show 🗑
|
||||
| Range | show 🗑
|
||||
| show | The numbers to the left side of rows in a worksheet.
🗑
|
||||
| Row height | show 🗑
|
||||
| Semi-selection | show 🗑
|
||||
| show | A visual element that shows the name of a worksheet contained in the workbook.
🗑
|
||||
| show | Visual elements that help you navigate to the first, previous, next, or last sheet within a workbook.
🗑
|
||||
| Spreadsheet | show 🗑
|
||||
| show | The row at the bottom of the Excel window that displays instructions and other details about the status of a worksheet.
🗑
|
||||
| Text | show 🗑
|
||||
| Value | show 🗑
|
||||
| Vertical alignment | show 🗑
|
||||
| View controls | show 🗑
|
||||
| show | A collection of one or more related worksheets contained within a single file.
🗑
|
||||
| Worksheet | show 🗑
|
||||
| Wrap text | show 🗑
|
||||
| Zoom control | show 🗑
|
||||
| A spreadsheet that contains formulas, functions, values, text, and visual aids. | show 🗑
|
||||
| show | Workbook
🗑
|
||||
| a range of cells containing values for variables used in formulas. | show 🗑
|
||||
| show | Output area
🗑
|
||||
| Identifies the address of the current cell. | show 🗑
|
||||
| show | Formula Bar
🗑
|
||||
| show | Sheet tab
🗑
|
||||
| The intersection of a column and row. | show 🗑
|
||||
| show | Text
🗑
|
||||
| A number that represents a quantity or an amount. | show 🗑
|
||||
| Rules that control the sequence in which Excel performs arithmetic operations. | show 🗑
|
||||
| show | Auto Fill
🗑
|
||||
| show | Fill handle
🗑
|
||||
| show | Column width
🗑
|
||||
| show | Row height
🗑
|
||||
| show | Range
🗑
|
||||
| The position of data between the cell margins. | show 🗑
|
||||
| Formatting that enables a label to appear on multiple lines within the current cell. | show 🗑
|
||||
| The background color appearing behind data in a cell. | show 🗑
|
||||
| A combination of cell references, operators, values, and/or functions used to perform a calculation. | show 🗑
|
||||
| What is the first step in planning an effective worksheet? | show 🗑
|
||||
| What Excel interface item displays the address of the current cell? | show 🗑
|
||||
| show | 14
🗑
|
||||
| show | To display cell formulas.
🗑
|
||||
| Which of the following is a nonadjacent range? | show 🗑
|
||||
| show | Merge and center the data over all columns.
🗑
|
||||
| What characteristic is not applicable to the accounting number format? | show 🗑
|
||||
| You selected and copied worksheet data containing formulas. However, you wanted the pasted copy to contain the current formula results rather than formulas. What do you do? | show 🗑
|
||||
| show | Increase the left and right margins.
🗑
|
||||
| What should you do if you see a column of pound signs(###) instead of value or results of formulas? | show 🗑
|
||||
| spreadsheet program | show 🗑
|
||||
| show | always written first in a cell address
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
TroyIS2241
Popular Computers sets