Question | Answer |
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 |