Excel Worksheet
Help!
|
|
||||
|---|---|---|---|---|---|
| A ______ displays between columns to indicate page breaks and what will be printed on a page | vertical dotted line
🗑
|
||||
| the Keyboard shortcut for the insert function is | [shift] + [f3]
🗑
|
||||
| A ____ chart is useful for illustrating comparisons among related numbers. | column
🗑
|
||||
| _____ identify each worksheet in a workbook and are located along the lower left edge of the workbook window | Sheet Tabs
🗑
|
||||
| A _________ format changes the appearance of a cell range based on certain criteria. | conditional
🗑
|
||||
| To create a pie chart you must select ________ range of data | two
🗑
|
||||
| ______ is used to copy the formatting of one cell to other cell | Format Painter
🗑
|
||||
| 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. | toggle buttons
🗑
|
||||
| From the page setup group, click the ___________ button to select the row headings that will repeat at the top of each page. | Print titles
🗑
|
||||
| A ___________ surrounds the selected range to be copied. | moving border
🗑
|
||||
| A _________ will display to indicate a cell contains an error message | green triangle in the upper left corner of the cell
🗑
|
||||
| Use __________ to prepare the spreadsheet for printing | Page Layout view
🗑
|
||||
| Use the _____ dialog box to insert a footer on a chart sheet | Page Setup
🗑
|
||||
| In a line chart _________ is displayed along the bottom axis | time
🗑
|
||||
| Commonly used font formats are found on the _________ group on the ribbon | font
🗑
|
||||
| the default setting in fow a new Excel workbook to contain ______ worksheets | three
🗑
|
||||
| Pressing ___ pastes the text and removes it from the Office Clipboard | Enter
🗑
|
||||
| In the Print dialog box under print what, select ___ to print all sheets in a workbook, | Entire Workbook
🗑
|
||||
| The command that enables you to select one or more rows or columns and lock them into place is called: | Freeze Panes
🗑
|
||||
| From the Clipboard group, click the _______ button to copy the format of one cell to another. | Format Copy
🗑
|
||||
| From the Format Cells dialog box under the Alignment Tab, click and drag the red diamond to change the: | text orientation
🗑
|
||||
| ____________ function preform common business calculations such as calculating a loan payment or calculating how much to save each month in order to buy something. | Financial
🗑
|
||||
| to change the name of a sheet tab, _________ on the tab and type in the new name then press enter. | double-click
🗑
|
||||
| Press _______ to access Microsoft Help | [f1]
🗑
|
||||
| __________ is a method to find a specific value for a cell by adjusting the value of one other cell. | Goal Seek
🗑
|
||||
| Sorting and Filtering arrows display _________ on an Excel Table | in the header row
🗑
|
||||
| Pre-Written formulas that analyze a group of measurements are called | statistical functions
🗑
|
||||
| From Preview group, click the _________ button to view each page page of the workbook. | Next page
🗑
|
||||
| the keyboard shortcut for the copy command is | [ctrl]+ [c]
🗑
|
||||
| From the Save As dialog box, click _______ to see a list of available storage devices. | the save in Arrow
🗑
|
||||
| A workbook sheet that contains only a chart is called a: | chart sheet
🗑
|
||||
| to group worksheet right-click on the sheet tab and click: | Select All Sheets
🗑
|
||||
| ______ is the process of changing the appearance of cells and the overall layout of the worksheet | Formatting
🗑
|
||||
| The _______ are the values that an excel function uses to perform calculations or operations | arguments
🗑
|
||||
| the intersection of a column and row is called a: | cell
🗑
|
||||
| from the format cells dialog box, click the _____ tab in order to wrap text | Alignment
🗑
|
||||
| If you want text to appear on multiple lines within a single cell, you can enter a | manual line break
🗑
|
||||
| you can create new folders to store files from the ____ dialog box | Save As
🗑
|
||||
| the keyboard shortcut to view print preview is | [ctrl] + [f2]
🗑
|
||||
| Use the ______ command to display text on two lines within a cell | 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. | recent documents
🗑
|
||||
| the function key used in Excel to repeat the last action when inserting columns and rows is: | [f4]
🗑
|
||||
| when you start the excel program. a new blank ___ displays | workbook
🗑
|
||||
| a __ displays trends over time | line chart
🗑
|
||||
| a __ is a portion of a worksheet window bounded by and separated from outer portions by vertical or horizontal bars. | pane
🗑
|
||||
| all formulas begin with the ____ sign | = equal
🗑
|
||||
| Excel's prewritten formulas are called | functions
🗑
|
||||
| the value at the end of the time periods for a loan is called the | future value
🗑
|
||||
| the ______ feature will provide a list of available functions if you type = and the first letter of a function in the formula bar | Formula Auto Complete
🗑
|
||||
| Formula results that are updated each time a workbook is opened are said to be | volatile
🗑
|
||||
| in preforming calculations, _____ are processed first | expressions within parentheses
🗑
|
||||
| the _ function finds the middle value | min
🗑
|
||||
| When calls are selected and the Copy or Cut command is performed on them, the data is place on the: | Office Clipboard
🗑
|
||||
| By default, text in Excel is: | Left Aligned
🗑
|
||||
| Symbols used to specify the calculations to be preformed in a formula are called | operators
🗑
|
||||
| New rows are inserted______ the selected row and existing rows shift accordingly | above
🗑
|
||||
| the _ of a data bar represents the value in a cell | length
🗑
|
||||
| to analyze a group of related data, you can convert a range of cells to a | excel table
🗑
|
||||
| from anywhere in the worksheet, you can press __ to move to cell A1 | [ctrl] + [home]
🗑
|
||||
| under date category, if type 3/14 is selected ____ will display in the cell | Only the month and day
🗑
|
||||
| to center the contents of the worksheet horizontally on the paper click on the ______ tab from the page setup dialog box | Margins
🗑
|
||||
| the keyboard shortcut for the paste command is | ctrl + v
🗑
|
||||
| Press the ____ key to cancel a moving border and clear a selection from the Office Clipboard. | Esc
🗑
|
||||
| The Worksheet that contains the totals from other worksheets is called an | summary sheet
🗑
|
||||
| If information within a table has been sorted alphabetically A-Z a _____ arrow will display | down
🗑
|
||||
| Press ___ to display the underlying formula | ctrl + `
🗑
|
||||
| _____ charts show the relationship of each part of data in reference to the whole. | pie
🗑
|
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