Microsoft Office
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| 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
🗑
|
||||
| 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
🗑
|
||||
| When linking data between worksheets, the worksheet containing the original data is called this | source
🗑
|
||||
| At the Open dialog box, hold down this key while selecting nonadjacent workbooks | Ctrl
🗑
|
||||
| The most recently opened workbook names display in this list, which displays when the Recent Workbooks option is selected at the Open backstage area | Recent Workbooks
🗑
|
||||
| Do this to a workbook name you want to remain at the top of the Recent Workbooks list at the Open backstage area | pin it
🗑
|
||||
| A style you create displays in this section of the Cell Styles button drop-down gallery | Custom
🗑
|
||||
| Copy styles from one workbook to another with options at this dialog box | Merge Styles
🗑
|
||||
| To link a workbook to another workbook, click this button in the Link to section of the Insert Hyperlink dialog box | Existing File or Web Page
🗑
|
||||
| Templates display at this backstage area | New
🗑
|
||||
| This type of chart shows proportions and relationships of the parts to the whole | pie
🗑
|
||||
| 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
🗑
|
||||
| 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 amountWrite 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
🗑
|
||||
| Click the SmartArt button in the Illustrations group on the INSERT tab and this dialog box displays | Choose a SmartArt Graphic
🗑
|
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:
shmaguy
Popular Computers sets