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