Busy. Please wait.
or

show password
Forgot Password?

Don't have an account?  Sign up 
or

Username is available taken
show password

why


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Remove ads
Don't know
Know
remaining cards
Save
0:01
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
Retries:
restart all cards




share
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

Excel Unit 2

Microsoft Office

QuestionAnswer
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
Created by: shmaguy