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
🗑
|
||||
| The first step in creating an effective worksheet is to make sure you __________. | show 🗑
|
||||
| Which of the following calculations multiplies 23 by 0.01? | show 🗑
|
||||
| show | Text
🗑
|
||||
| show | 26
🗑
|
||||
| show | AutoCorrect
🗑
|
||||
| The adjusted cell references in a copied and pasted formula are called ______ cell references. | show 🗑
|
||||
| show | paste
🗑
|
||||
| Which of the following Option button gives options for filling cells following a fill operations? | show 🗑
|
||||
| The range of cells receiving the content of copied cells is called the ________. | show 🗑
|
||||
| show | Insert
🗑
|
||||
| show | Auto Fill Options
🗑
|
||||
| The _______________ function determines the lowest number in a range. | show 🗑
|
||||
| You can apply the Bold font style by pressing the _______ keyboard shortcut keys, | show 🗑
|
||||
| show | Formula
🗑
|
||||
| show | (HOME tab/ Styles group)
🗑
|
||||
| You can use the ________ to check which cells are referenced in the formula assigned to the active cell. | show 🗑
|
||||
| What effect does the Comma Style format have on the selected cells? | show 🗑
|
||||
| show | Accounting Number format
🗑
|
||||
| How many chart types does Excel offer? | show 🗑
|
||||
| show | 0
🗑
|
||||
| show | automatically updated
🗑
|
||||
| A _____ is a text and graphics that print at the bottom of every page. | show 🗑
|
||||
| You use _____ to view an XPS file | show 🗑
|
||||
| show | Page Layout
🗑
|
||||
| Which of the following key toggles between Insert Mode and Overtype mode? | show 🗑
|
||||
| show | ESC
🗑
|
||||
| show | HOME
🗑
|
||||
| Which of the following keys moves the insertion point to the end of the data in the cell? | show 🗑
|
||||
| show | undo
🗑
|
||||
| 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 🗑
|
||||
| A(n) ___________ conveys a visual representation of data. | show 🗑
|
||||
| A formula in a cell that contains a reference back to itself is called a(n) _____________. | show 🗑
|
||||
| The easiest way to select a cell is to move the block _________ pointer to the cell and then click. | show 🗑
|
||||
| IN the order of operations, the last operation Excel performs is __________. | show 🗑
|
||||
| As you type, Excel displays the entry ( and the Cancel box and Enter box) in the ______________. | show 🗑
|
||||
| show | fill handle
🗑
|
||||
| Excel's ____________- function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total. | show 🗑
|
||||
| show | warmer
🗑
|
||||
| The automatically adjusted cell reference in a pasted formula is called a (n) | show 🗑
|
||||
| show | best fit
🗑
|
||||
| __________________ indicates how characters are emphasized. | show 🗑
|
||||
| show | Page Layout
🗑
|
||||
| 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