Busy. Please wait.
Log in using Clever

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever

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.
Didn't know it?
click below
Knew it?
click below
Don't know
Remaining cards (0)
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

CTS 130 EM06

Excel Module 6

A worksheet ____ is a collection of two or more selected worksheets. group
Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets. ranges
To select adjacent worksheets, you use the ____ key. shift
To select nonadjacent worksheets, you use the ____ key. ctral
Rather than retyping the same formulas across a series of worksheets, you can enter them all at once by creating a worksheet ____. group
If you cannot see the sheet tab of a worksheet you want to include in a group, use the sheet ____ controls to display it. navigation
The ____ caption indicates a worksheet group. [Group]
To ungroup worksheets, you can click a sheet ____ of a sheet not in the group. tab
When a worksheet group is selected, the ____ includes text to indicate this. title
The active worksheet in a group is indicated by ____ text. bold
To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu. ungroup
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 ____. tabs
When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference. !
When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____. single (‘ ‘) quotation marks
The general format of a 3-D cell reference is ____. WorksheetRange!CellRange
The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4." Sheet1:Sheet4
A(n) ____ cell reference specifies not only the rows and columns of a cell range, but also the names of the worksheets on which the cells appear. 3-D
If a sheet range includes more than one sheet, you specify the first and last sheet in the range separated by a ____. colon
A link is a connection between two ____ allowing information to be transferred from one to the other. files
If you need to use data located in one workbook in the other workbook, you have to create a(n) ____ between the two workbooks. link
The general form of an external reference is ____, where Path is the path of the workbook file on the computer or network, Workbook Name is the filename of the workbook, and Sheet Range and Cell Range are worksheets and cells in the workbook, respectively [WorkbookName]WorksheetName!CellRange
If you want to create a cell reference to the B6 on the Summary Info worksheet of the Sales.xls workbook, you would use the following external reference: ____. '[Sales.xlsx]Summary Info'!B6
The ____ arrangement option layers the open workbooks on the screen. cascade
A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks. external.
You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6. mixed
Formulas created using the point-and-click method contain ____ references. absolute
If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values. break
If you trust the provider of source files, you can choose to ____ the content, which allows the external reference formulas to function and updates the links in the destination workbook. enable
When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file. destination.
As part of the Excel security system that attempts to protect against ____, links to other workbooks are not updated without your permission. malicious software.
When two workbooks are ____, it is important that the data in the destination file accurately reflects the contents of the source file. linked
If the destination file is closed when you make a change in the ____ file, you can choose whether to update the link to display the current values when you open the destination file. source
The ____ dialog box lists all of the links in the current workbook. edit links
If you break a link, to undo the action you’d do ________? Retype the external reference formula
In regard to open workbooks, a workspace saves all of the following EXCEPT ____. the workbooks themselves
In the Edit Links dialog box, the ____ option shows whether Excel successfully accessed the link and updated the values from the source document. status
If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____. ok
To manually update the link and see the new data values, click the Update Values button in the Edit Links dialog box. update values
In the Edit Links dialog box, Type identifies the type of each ____ file. source.
In the Edit Links dialog box, ____ indicates the file to which the link points. source.
Choosing to ____ update values is useful when you want to see the older data values before updating to the new data. manually
The ____ button on the Ribbon is used to create a hyperlink. hyperlink
You can insert a ____ directly in a workbook file hyperlink
____ are usually represented by colored words with underlines or images. hyperlinks
When you click a(n) ____, the computer switches to the file or portion of the file that it references. hyperlink
To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink. remove
The default template has column widths is set to ____ characters. 8.43
The default template has ____ worksheets inserted in the workbook. three
The default template contains the default formatting you start out with in every new workbook, including ____ 11-point font. calibri
Each time you start Excel, a blank ____ workbook opens. Book 1
A ____ is a blank workbook that you can open with the text, formats, and formulas already built into it. template.
When you start Excel and use the blank workbook that displays, you are actually using a workbook based on a template known as the ___ template. default
The ____ template in Excel creates an online time card to track employees’ work hours. timesheet
The default template contains the default formatting you start out with in every new workbook, including the ____ number format. calibri
The default template places the formula results aligned to the ____ of a cell. right-side
To create a template, you simply save an Excel workbook in template format using the ____ dialog command. save as
All template files have a(n) ____ extension. .xltx
To delete the data values, you can click the Clear button in the Editing group on the ____ tab, and then click Clear Contents. none
Office Web Apps are a part of Windows ____, which is a collection of services and Web applications that you can use to be more productive. live
Created by: galvanl



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:
restart all cards