Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


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. Your email address is only used to allow you to reset your password. See 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.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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

NP Excel Unit 6

Managing multiple worksheets and workbooks in Excel

QuestionAnswer
A collection of two or more selected worksheets worksheet group
Reference to the same cell or range in multiple worksheets in the same workbook 3-D reference
Reference to cells or ranges in a worksheet from another workbook external reference
Dependent file when two workbooks are linked destination file
An Excel file that saves information about all of the currently opened workbooks, such as their location, size of window, zoom level workspace
When two or more workbooks are linked, this is a workbook that contains data to be used in the destination file source file
A connection between files that allows data to be transferred from one file to another link
A workbook with labels, formats, and formulas already built into it with data removed template
A link in a file to information in that file or another file that can be clicked on hyperlink
The blank Book1 workbook that opens when you start Excel is based on: default template
Web-based version of the MS Office programs that allow you to create, view, and edit Office files direction from your web browser Office Web Apps
To select adjacent worksheets, click and hold this key: Shift
To select non-adjacent worksheets, click and hold this key: Alt
To deselect a worksheet group, either click the sheet tab of a worksheet NOT in the group or click: Ungroup Sheets
To reference cell A10 in the Jan worksheet, what formula would be entered? ='Jan'!A10
The enter a 3D range reference to cell A10 in the adjacent Jan, Feb, and March worksheets, what for the formula be? 'Jan:March'!A10
To apply a page layout to all worksheets in a workbook at all time, do this before altering page setup: group
How are linked workbooks updated when the source file is changed and the destination file is closed? Press Update button
If both the destination and source files are open, Excel will update links: automatically
Under which tab do you go to edit connections for linked workbooks? Data
To insert a hyperlink, go to this tab: Insert
Templates automatically create a new copy of a document and use this to save the first time: Save As
To save as a template, choose Save As and for Save as Type, choose: Template
You can use Windows Live to upload your Office files to an online storage and file sharing service called: OneDrive
To save to OneDrive/SkyDrive or use Office Web Apps, you need this type of account: Windows Live
To create a Workspace, click Save Workspace under what tab? View
This type of cell reference specifies not only the rows and columns of a cell range, but the names of the worksheets on which the cells appear: 3D
If you break a link and wish to undo the action, you will have to: Retype the reference
The active worksheet in a group is indicated by text that appears: bold
The default template has this many worksheets automatically: 3
To move a worksheet or worksheet group to another location in the same workbook, select the worksheets and then drag and drop them by the selected: sheet tab
To delete a hyperlink but leave the text, right click the hyperlink and click: remove hyperlink
When you reference a cell or a range in a different worksheet, this separates the sheet reference from the cell reference exclamation point
If you link to an external workbook, the name of the workbook goes in: brackets
If you link to a different sheet tab, the worksheet name goes in: apostrophes
This appears between the first cell and last cell in a cell reference for a range: colon
Created by: skindawg
Popular Computers sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards