Final for Introduction to Spreadsheets Concepts Exam
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| To remove a style from a cell or cells, select the appropriate cell(s) | then return the Cell Style to Normal.
🗑
|
||||
| The styles you define in a workbook are available | only in that workbook
🗑
|
||||
| You can name a range by selecting the cells and then typing a name into | the Name box
🗑
|
||||
| To move an inserted image in small increments, hold down the _____ key while pressing one of the arrow keys. | Ctrl
🗑
|
||||
| A chart is a picture of numeric data and is sometimes referred to as a | graph
🗑
|
||||
| Split lines display in a worksheet as | thick, light gray lines
🗑
|
||||
| Excel's split window feature is useful for displaying | different areas of the worksheet on the screen when the whole worksheet will not fit.
🗑
|
||||
| Which of the following methods can be used for deleting a workbook? | Display the Open dialog box, right-click the workbook, and then click Delete at the shortcut menu.
🗑
|
||||
| What does the Compress Pictures button do? | It shrinks the size of the image file to save space on your storage medium.
🗑
|
||||
| Excel uses a PMT function to calculate | payment for a loan based on constant payments and a constant interest rate.
🗑
|
||||
| To copy a worksheet from one workbook to another, begin by opening | both the source and the destination workbooks.
🗑
|
||||
| How can you use a graphic to hyperlink to a file or web page? | Insert the graphic, select it, and then define the hyperlink.
🗑
|
||||
| A template worksheet form is | a form preformatted for specific uses (balance sheet, sales invoice, etc.) that you can use when creating a new workbook.
🗑
|
||||
| You can rename a folder by | clicking the Organize button in the Open dialog box and then clicking Rename.
🗑
|
||||
| What happens when you double-click a symbol in the Symbol dialog box? | The symbol is inserted into the worksheet.
🗑
|
||||
| To maintain the proportions of an image while resizing it with the sizing handles, hold down the _____ key while dragging the sizing handle. | Shift
🗑
|
||||
| When you apply a transform shape to WordArt text, the WordArt border displays with a small, | purple, square shape
🗑
|
||||
| When using the Screenshot feature, what will display if you do not have another file or program open? | the Windows desktop
🗑
|
||||
| Instead of using the sheet tab shortcut menu, you can copy a worksheet by | holding down the Ctrl key while dragging the worksheet tab from one location to another.
🗑
|
||||
| You can use _____ to collect and paste multiple items. | the Clipboard task pane
🗑
|
||||
| What is used to separate the condition and action in an IF function? | commas (,)
🗑
|
||||
| When using the PMT formula, the Functions Argument palette includes all of the following options except | Logical_test.
🗑
|
||||
| A chart created in an existing worksheet can be moved by selecting the chart and | positioning the mouse pointer on a border until it becomes a four-headed arrow, and then clicking and dragging the chart to the desired location.
🗑
|
||||
| A variety of formatting changes can be made to a chart or chart elements with options on the CHART TOOLS FORMAT tab. Which of the following is not one of them? | changing the data range
🗑
|
||||
| When you split a worksheet window, each section is referred to as a | pane
🗑
|
||||
| If you have rows or columns of data that you do not want to chart, Chapter 7 suggests that you _____ them. | hide
🗑
|
||||
| Let Excel determine a chart type for selected data in a worksheet by clicking this button in the Charts group on the INSERT tab. | Recommended Charts
🗑
|
||||
| This type of chart shows proportions and relationships of the parts to the whole. | pie
🗑
|
||||
| When you create a chart, the chart is inserted in this location by default. | worksheet containing data or same worksheet as selected cells
🗑
|
||||
| Size a chart by dragging one of these on the selected chart border. | sizing handle
🗑
|
||||
| When a chart is selected, three buttons display at the right side of the chart border: the Chart Elements button, the Chart Styles button, and this button. | Chart Filters
🗑
|
||||
| Select a chart in a worksheet, display the Print backstage area, and the first gallery in the Settings category is automatically changed to this option. | Print Selected Chart
🗑
|
||||
| The Switch Row/Column button is location in this group on the CHART TOOLS DESIGN tab. | Data
🗑
|
||||
| Click this option at the Move Chart dialog box to move the chart to a separate sheet. | New sheet
🗑
|
||||
| Insert a shape in a chart and this tab is active. | DRAWING TOOLS FORMAT tab
🗑
|
||||
| Select a chart (not a chart element), click the Format Selection button in the Current Selection group on the CHART TOOLS FORMAT tab, and this task pane displays at the right side of the screen. | Format Chart Area
🗑
|
||||
| This function finds the payment for a loan based on constant payments and a constant interest rate. | PMT
🗑
|
||||
| Suppose cell B2 contains the total sales amount. Write a formula that inserts the word BONUS in cell C2 if the sales amount is greater than $49,999 and inserts the words NO BONUS if the sales amount is not greater than $49,999. | =IF(B2>49999,"BONUS","NO BONUS")
🗑
|
||||
| The Symbol button is located on this tab. | INSERT
🗑
|
||||
| The Font option is available at the Symbol dialog box with this tab selected. | Symbols
🗑
|
||||
| Insert a picture, clip art image, screenshot, shape, or SmartArt graphic with buttons in this group on the INSERT tab. | Illustrations
🗑
|
||||
| Display the Insert Pictures window by clicking this button on the INSERT tab. | Pictures
🗑
|
||||
| When you insert an image, such as a picture or clip art, in a worksheet, this tab is active. | PICTURE TOOLS FORMAT
🗑
|
||||
| Maintain the proportions of an image by holding down this key while dragging a sizing handle. | Shift
🗑
|
||||
| To move an image, position the mouse pointer on the image border until the mouse pointer displays with this attached and then drag the image to the desired location. | four-headed arrow
🗑
|
||||
| To capture a portion of a screen, click the Screenshot button and then click this option at the drop-down list. | Screen Clipping
🗑
|
||||
| To copy a shape, hold down this key while dragging the shape. | Ctrl
🗑
|
||||
| When you draw a text box in a worksheet and then release the mouse button, this tab is active. | DRAWING TOOLS FORMAT
🗑
|
||||
| This term refers to a lightened image that displays behind data in a file. | watermark
🗑
|
||||
| Click the SmartArt button in the Illustrations group on the INSERT tab and this dialog box displays. | Choose a SmartArt Graphic
🗑
|
||||
| In addition to the Organize button, where else can you rename a folder? | at the shortcut menu in the Open dialog box
🗑
|
||||
| Excel allows you to link data | between worksheets in the same or different workbooks.
🗑
|
||||
| In a column chart created by Excel, the horizontal axis runs along the _____ of the chart. | bottom
🗑
|
||||
| Which tab would you use to apply a WordArt style to one of your chart elements? | CHART TOOLS FORMAT
🗑
|
||||
| How do you display the Clipboard task pane? | Click the Clipboard task pane launcher in the Clipboard group on the HOME tab.
🗑
|
||||
| Excel's _____ calculates the future value of an investment. | FV function
🗑
|
||||
| With default settings, a new workbook contains _____ worksheet(s). | 1
🗑
|
||||
| To restore the default layout and color to a SmartArt graphic, click the _____ button. | Reset Graphic
🗑
|
||||
| The term APR stands for | annual percentage rate.
🗑
|
||||
| Which of the following is not an acceptable way to write a formula to calculate the average for a group of cells? | =AVERAGE(Annual Salary)
🗑
|
||||
| A folder name can contain up to _____ characters. | 255
🗑
|
||||
| To unpin a workbook from the Recent Workbooks list, begin by | right-clicking the workbook name.
🗑
|
||||
| A lightened image that displays behind data in a file is called a | watermark
🗑
|
||||
| The _____ and _____ buttons in the upper right corner of the active workbook can be used to change the size of the window. | Maximize; Minimize
🗑
|
||||
| A range of cells cannot be | split into separate windows
🗑
|
||||
| By default, a workbook contains this number of worksheets. | one
🗑
|
||||
| Click this button to insert a new worksheet in a workbook. | New Sheet
🗑
|
||||
| To select nonadjacent worksheet tabs, click the first tab, hold down this key, and then click any other tabs you want selected. | Ctrl
🗑
|
||||
| To select adjacent worksheet tabs, click the first tab, hold down this key, and then click the last tab. | Shift
🗑
|
||||
| The Cut, Copy, and Paste buttons are located in this group on the HOME tab. | Clipboard
🗑
|
||||
| This button displays in the lower right corner of pasted cells. | Paste Options
🗑
|
||||
| Use this task pane to copy and paste multiple items. | Clipboard
🗑
|
||||
| Click this option at the worksheet tab shortcut menu to apply a color to a worksheet tab. | Tab Color
🗑
|
||||
| To print all of the worksheets in a workbook, display the Print backstage area, click the first gallery in the Settings category, and then click this option at the drop-down list. | Print Entire Workbook
🗑
|
||||
| The Split button is located on this tab. | VIEW
🗑
|
||||
| Display the Arrange Windows dialog box by clicking this button in the Window group on the VIEW tab. | Arrange All
🗑
|
||||
| Click this button to make the active workbook expand to fill the screen. | Maximize
🗑
|
||||
| Click this button to reduce the active workbook to a layer behind the Excel button on the Taskbar. | Minimize
🗑
|
||||
| When linking data between worksheets, the worksheet containing the original data is called this. | source
🗑
|
||||
| Select nonadjacent worksheet tabs by clicking the first tab, holding down this key, and then clicking any other desired tabs. | Ctrl
🗑
|
||||
| What happens if you delete the Normal style? | You cannot delete the Normal style.
🗑
|
||||
| To include text in an IF function, you must | insert quotation marks around the text.
🗑
|
||||
| With a chart selected, pressing the Delete key will | deleted only the chart.
🗑
|
||||
| The left side of a column chart created by Excel is referred to as the | vertical axis.
🗑
|
||||
| You can use the IF function to create a logical test that performs if the answer will be _____ or _____. | true; false
🗑
|
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:
ibenoit95
Popular Computers sets