In each blank, try to type in the
word that is missing. If you've
typed in the correct word, the
blank will turn green.
If your not sure what answer should be entered, press the space bar and the next missing letter will be displayed. When you are all done, you should look back over all your answers and review the ones in red. These ones in red are the ones which you needed help on. Question: A ______ displays between columns to indicate page breaks and what will be printed on a pageAnswer: vertical dotted Question: the Keyboard shortcut for the insert isAnswer: [shift] + [f3] Question: A ____ chart is useful for illustrating comparisons among related numbers.Answer: Question: _____ identify each worksheet in a workbook and are located along the lower left edge of the workbook windowAnswer: Tabs Question: A _________ format changes the appearance of a cell range based on certain criteria.Answer: Question: To create a pie chart you must select ________ range of dataAnswer: Question: ______ is used to copy the formatting of one cell to other cellAnswer: Format Question: 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.Answer: buttons Question: From the page setup group, click the ___________ button to select the row headings that will repeat at the top of each page.Answer: titles Question: A ___________ surrounds the selected range to be copied.Answer: moving Question: A _________ will display to indicate a cell contains an error messageAnswer: green triangle in the left corner of the cell Question: Use __________ to prepare the spreadsheet for printingAnswer: Page view Question: Use the _____ dialog box to insert a footer on a chart sheetAnswer: Page Question: In a line chart _________ is displayed along the bottom axisAnswer: Question: Commonly used font formats are found on the _________ group on the ribbonAnswer: Question: the default setting in fow a new Excel workbook to contain ______ worksheetsAnswer: Question: Pressing ___ pastes the text and it from the Office ClipboardAnswer: Enter Question: In the Print dialog box under print what, select ___ to print all sheets in a ,Answer: Entire Question: The command that enables you to select one or more rows or columns and lock them into is called: Answer: Freeze Question: From the Clipboard group, click the _______ button to copy the format of one cell to another.Answer: Copy Question: From the Format Cells dialog box the Alignment Tab, click and drag the red diamond to change the:Answer: text Question: ____________ function preform common business calculations such as calculating a loan payment or calculating how much to save each month in order to buy something.Answer: Question: to change the name of a sheet tab, _________ on the tab and type in the new name then press enter.Answer: -click Question: Press _______ to access Microsoft HelpAnswer: [f1] Question: __________ is a method to find a specific value for a cell by adjusting the value of one other cell.Answer: Goal Question: Sorting and Filtering arrows display _________ on an Excel TableAnswer: in the row Question: Pre-Written formulas that analyze a of measurements are calledAnswer: statistical Question: From Preview group, click the _________ button to view each page page of the workbook.Answer: Next Question: the keyboard for the copy command is Answer: [ctrl]+ [c] Question: From the Save As dialog box, click _______ to see a list of available storage devices.Answer: the save in Question: A sheet that contains only a chart is called a:Answer: sheet Question: to group worksheet right-click on the tab and click:Answer: Select All Question: ______ is the process of changing the appearance of cells and the overall layout of the worksheetAnswer: Question: The _______ are the values that an excel function uses to perform calculations or operationsAnswer: Question: the intersection of a and row is called a:Answer: cell Question: from the format cells dialog box, click the _____ tab in order to wrap textAnswer: Question: If you want text to appear on multiple lines within a single cell, you can aAnswer: line break Question: you can create new folders to store files from the ____ dialog boxAnswer: Save Question: the keyboard shortcut to view print isAnswer: [ctrl] + [f2] Question: Use the ______ command to display text on two lines within a cellAnswer: Wrap Question: 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.Answer: documents Question: the function key used in Excel to the last action when inserting columns and rows is:Answer: [f4] Question: when you start the excel program. a new blank ___ Answer: Question: a __ displays trends over Answer: line Question: a __ is a portion of a worksheet window bounded by and separated from outer portions by vertical or bars.Answer: pane Question: all formulas begin with the ____ signAnswer: = Question: Excel's prewritten are calledAnswer: functions Question: the value at the end of the time for a loan is called the Answer: future Question: the ______ feature will provide a list of available functions if you type = and the first letter of a function in the formula barAnswer: Formula Auto Question: Formula results that are updated each time a workbook is opened are said to Answer: Question: in preforming calculations, _____ are processed firstAnswer: expressions parentheses Question: the _ function the middle valueAnswer: min Question: When calls are selected and the Copy or Cut command is performed on them, the data is on the: Answer: Clipboard Question: By , text in Excel is:Answer: Left Question: Symbols used to specify the to be preformed in a formula are called Answer: operators Question: New rows are inserted______ the selected row and existing rows shift accordinglyAnswer: Question: the _ of a data bar represents the value in a Answer: Question: to analyze a of related data, you can convert a range of cells to aAnswer: table Question: from anywhere in the worksheet, you can __ to move to cell A1Answer: [ctrl] + [home] Question: under date category, if type 3/14 is selected ____ will display in the cellAnswer: Only the and day Question: to center the contents of the worksheet horizontally on the paper click on the ______ tab from the page setup dialog boxAnswer: Question: the keyboard for the paste command is Answer: ctrl + Question: Press the ____ key to cancel a moving border and clear a selection from the Office Clipboard.Answer: Question: The Worksheet that contains the totals from other worksheets is anAnswer: summary Question: If information within a table has been sorted alphabetically A-Z a _____ arrow will displayAnswer: Question: Press ___ to the underlying formulaAnswer: ctrl + ` Question: _____ charts show the relationship of each part of data in reference to the whole.Answer: |
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