Excel Worksheet
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| A ______ displays between columns to indicate page breaks and what will be printed on a page | show 🗑
|
||||
| the Keyboard shortcut for the insert function is | show 🗑
|
||||
| A ____ chart is useful for illustrating comparisons among related numbers. | show 🗑
|
||||
| show | Sheet Tabs
🗑
|
||||
| show | conditional
🗑
|
||||
| To create a pie chart you must select ________ range of data | show 🗑
|
||||
| ______ is used to copy the formatting of one cell to other cell | show 🗑
|
||||
| Bold, Italic, and underline are ____________, which means that you can click the button one time to turn the formatting on and click it again to turn it off. | show 🗑
|
||||
| From the page setup group, click the ___________ button to select the row headings that will repeat at the top of each page. | show 🗑
|
||||
| show | moving border
🗑
|
||||
| show | green triangle in the upper left corner of the cell
🗑
|
||||
| show | Page Layout view
🗑
|
||||
| Use the _____ dialog box to insert a footer on a chart sheet | show 🗑
|
||||
| In a line chart _________ is displayed along the bottom axis | show 🗑
|
||||
| show | font
🗑
|
||||
| show | three
🗑
|
||||
| Pressing ___ pastes the text and removes it from the Office Clipboard | show 🗑
|
||||
| In the Print dialog box under print what, select ___ to print all sheets in a workbook, | show 🗑
|
||||
| The command that enables you to select one or more rows or columns and lock them into place is called: | show 🗑
|
||||
| From the Clipboard group, click the _______ button to copy the format of one cell to another. | show 🗑
|
||||
| show | text orientation
🗑
|
||||
| show | Financial
🗑
|
||||
| to change the name of a sheet tab, _________ on the tab and type in the new name then press enter. | show 🗑
|
||||
| show | [f1]
🗑
|
||||
| __________ is a method to find a specific value for a cell by adjusting the value of one other cell. | show 🗑
|
||||
| Sorting and Filtering arrows display _________ on an Excel Table | show 🗑
|
||||
| show | statistical functions
🗑
|
||||
| show | Next page
🗑
|
||||
| show | [ctrl]+ [c]
🗑
|
||||
| show | the save in Arrow
🗑
|
||||
| A workbook sheet that contains only a chart is called a: | show 🗑
|
||||
| show | Select All Sheets
🗑
|
||||
| show | Formatting
🗑
|
||||
| show | arguments
🗑
|
||||
| show | cell
🗑
|
||||
| show | Alignment
🗑
|
||||
| If you want text to appear on multiple lines within a single cell, you can enter a | show 🗑
|
||||
| show | Save As
🗑
|
||||
| the keyboard shortcut to view print preview is | show 🗑
|
||||
| show | Wrap Text
🗑
|
||||
| to reopen a workbook once Excel is opened, you can check the _____ for the Office menu to see if the file is there and click on it. | show 🗑
|
||||
| the function key used in Excel to repeat the last action when inserting columns and rows is: | show 🗑
|
||||
| when you start the excel program. a new blank ___ displays | show 🗑
|
||||
| a __ displays trends over time | show 🗑
|
||||
| a __ is a portion of a worksheet window bounded by and separated from outer portions by vertical or horizontal bars. | show 🗑
|
||||
| show | = equal
🗑
|
||||
| show | functions
🗑
|
||||
| show | future value
🗑
|
||||
| show | Formula Auto Complete
🗑
|
||||
| Formula results that are updated each time a workbook is opened are said to be | show 🗑
|
||||
| in preforming calculations, _____ are processed first | show 🗑
|
||||
| show | min
🗑
|
||||
| show | Office Clipboard
🗑
|
||||
| By default, text in Excel is: | show 🗑
|
||||
| show | operators
🗑
|
||||
| show | above
🗑
|
||||
| the _ of a data bar represents the value in a cell | show 🗑
|
||||
| to analyze a group of related data, you can convert a range of cells to a | show 🗑
|
||||
| from anywhere in the worksheet, you can press __ to move to cell A1 | show 🗑
|
||||
| under date category, if type 3/14 is selected ____ will display in the cell | show 🗑
|
||||
| to center the contents of the worksheet horizontally on the paper click on the ______ tab from the page setup dialog box | show 🗑
|
||||
| show | ctrl + v
🗑
|
||||
| show | Esc
🗑
|
||||
| The Worksheet that contains the totals from other worksheets is called an | show 🗑
|
||||
| If information within a table has been sorted alphabetically A-Z a _____ arrow will display | show 🗑
|
||||
| show | ctrl + `
🗑
|
||||
| _____ charts show the relationship of each part of data in reference to the whole. | 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:
lucia1031