Excel Module 1 & 2
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| show | worksheet
🗑
|
||||
| show | indirect
🗑
|
||||
| show | understand what is required
🗑
|
||||
| show | =23%
🗑
|
||||
| ______ is/are used to place worksheet, column, and row titles on a worksheet. | show 🗑
|
||||
| When Excel follows the order of operations, the formula, 8*3+2, equals_______. | show 🗑
|
||||
| The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. | show 🗑
|
||||
| show | relative
🗑
|
||||
| show | paste
🗑
|
||||
| Which of the following Option button gives options for filling cells following a fill operations? | show 🗑
|
||||
| show | destination area
🗑
|
||||
| The _______ Options button lists formatting options following an insertion of cells, rows, or columns. | show 🗑
|
||||
| show | Auto Fill Options
🗑
|
||||
| The _______________ function determines the lowest number in a range. | show 🗑
|
||||
| show | CTRL + B
🗑
|
||||
| The __________________ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign. | show 🗑
|
||||
| Which of the following is the Ribbon path to the cell Styles button? | show 🗑
|
||||
| show | Range Finder
🗑
|
||||
| show | Displays cell contents with two decimal places and commas as thousands seperators
🗑
|
||||
| The _____________ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. | show 🗑
|
||||
| show | 15
🗑
|
||||
| show | 0
🗑
|
||||
| show | automatically updated
🗑
|
||||
| show | footer
🗑
|
||||
| show | XPS viewer
🗑
|
||||
| _________ view allows you to create or modify a worksheet while viewing how it will look in printed format. | show 🗑
|
||||
| Which of the following key toggles between Insert Mode and Overtype mode? | show 🗑
|
||||
| To erase an entire entry in a cell and then recenter the data from the begininning, press the ____ key. | show 🗑
|
||||
| Which of the following keys moves the insertion point to the beginning of data in a cell? | show 🗑
|
||||
| show | END
🗑
|
||||
| The _______ button allows you to erase recent cell entries. | show 🗑
|
||||
| Excel remembers the last _______ actions you have completed. | show 🗑
|
||||
| Press _____ to select the entire worksheet. | show 🗑
|
||||
| When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ______________. | show 🗑
|
||||
| show | chart
🗑
|
||||
| show | circular reference
🗑
|
||||
| show | plus sign
🗑
|
||||
| show | subtraction/ addition
🗑
|
||||
| As you type, Excel displays the entry ( and the Cancel box and Enter box) in the ______________. | show 🗑
|
||||
| The __________ is a small black square in the lower-right corner of the active cell or active range. | show 🗑
|
||||
| show | SUM
🗑
|
||||
| show | warmer
🗑
|
||||
| show | relative reference
🗑
|
||||
| __________ means that the width of a column will be increase or decreased so the widest entry will fit in the column. | show 🗑
|
||||
| show | font style
🗑
|
||||
| You can click the Page Layout button on the status bar to switch to ___________view. | show 🗑
|
||||
| You can click the Page Layout button on the status bar to switch to _________ view. | show 🗑
|
||||
| show | Page Layout
🗑
|
||||
| show | Green Computing
🗑
|
||||
| While typing ______ in a cell, you can press the ___________ key to erase all the characters back to including the incorrect character you just typed. | show 🗑
|
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:
gracie.prince07
Popular Computers sets