Excels Lessons 2 & 3
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| What is the process of using the mouse to move or copy cells called? | show 🗑
|
||||
| show | Clear
🗑
|
||||
| Jon wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose? | show 🗑
|
||||
| show | Auto complete
🗑
|
||||
| Jennifer needs to identify the values in column B fora a sales report. Which type of entry should she us in the column header? | show 🗑
|
||||
| What is the name of the list of frequently used excel commands available when a user right-clicks an item in a worksheet? | show 🗑
|
||||
| show | range
🗑
|
||||
| show | range
🗑
|
||||
| show | Backspace key
🗑
|
||||
| show | Fill series
🗑
|
||||
| Alicia need to move the data in cell B5 to cell E5. Which command would she select? | show 🗑
|
||||
| David wants to key the numbers 1 to 1,000 in column A of his spreadsheet. What command should he use to complete this task? | show 🗑
|
||||
| In an Microsoft Excel worksheet, how you change the width of a column so that the widest entry will fit? | show 🗑
|
||||
| To help organize and identify Microsoft files by providing details about the files, which of the following would you use? | show 🗑
|
||||
| In Microsoft excel worksheet, which feature makes an exact replica of the cell data and format while keeping the original cell intact? | show 🗑
|
||||
| Joan is creating a table that will include demographic information about her employees. Which header in her table considered? | show 🗑
|
||||
| Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve data for future use? | show 🗑
|
||||
| show | Labels
🗑
|
||||
| show | Cut
🗑
|
||||
| What is the name of the small black square in the lower right corner of the heavy border of an active cell that repeats a cell's value in the adjacent cells? | show 🗑
|
||||
| Ji would like to print only the worksheet he is currently working on. what print option should he choose? | show 🗑
|
||||
| show | save as
🗑
|
||||
| John's workbooks includes 3 worksheets. Which option should he choose to print them? | show 🗑
|
||||
| Which is a special workbook a user and the use as a pattern to create new similar workbooks or worksheets? | show 🗑
|
||||
| What are contains the command used to customize the print options in Microsoft excel? | 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:
herrera97