BCIS 2610 EXCEL EXAM (MODULES 6 & 11)
When you edit cells in a worksheet group, the changes you make to one worksheet are
automatically applied to the other worksheets in the group - Answers -true
To ungroup worksheets, right-click _________ - Answers -any sheet tab
What is the first step in copying worksheets to another workbook? - Answers -select the
sheet tabs you want to copy
The fastest way to copy an entire worksheet to press and hold the alt key as you drag
and drop the sheet tab - Answers -false
What are the steps to enter a formula that references another worksheet? - Answers -
click the cell where you want to enter the formula, type = to enter the formula. To insert
a reference from another worksheet, click the sheet tab for the worksheet, and then
click the cell or select the range you want to reference. When the fromula is complete,
press the enter key
What is a 3-D reference? - Answers -it refers to the same cell or range in multiple
worksheets in the same workbook?
What is a worksheet range? - Answers -it is the range of worksheets you want to
reference
What is a cell range? - Answers -the same cell or range in each of those worksheets
that you want to reference
A __________ is a connection between the files that allows data to be transferred from
one file to the other - Answers -link
When two files are linked, the _________ file is the workbook that contains the data -
Answers -source
The _______ is displayed at the end of the table - Answers -total row
The __________ file (sometimes referred to as the dependent file)) is the workbook that
receives the data - Answers -destination
A reference in a formula that refers to another workbook is called a workbook reference
- Answers -false
, When you break a link using the break Links command in the Edit links dialog box, all
the external reference formulas are converted to their most recent values - Answers -
true
A ________ is a link in a file - Answers -hyperlink
To use a hyperlink, you click anywhere inside the cell that contains the link - Answers -
false
When you start excel and see the blank workbook called Book1 you are actually using a
workbook based on a template known as the __ template - Answers -default
You can create a workbook with all the formulas and formatting you need and then save
it as a template on which you can base other woekbooks - Answers -true
A ____________ is a workbook template you create that is ready to run with the
formulas for all calculations included as well as all formatting - Answers -custom
template
________ refers to data, applications, and even resources that are stored on servers
that you access over the internet rather than you own computer - Answers -cloud
computing
You can can acess your skydrive and the office web apps anywhere you have internet
access - Answers -true
When you save a worksheet as a web page, excel converts the contents of the
worksheet into XML - Answers -false
You can save an item in a worksheet as a web page - Answers -true
Worksheet group - Answers -a collection of two or ore selected worksheets
3-D reference - Answers -a reference to the same cell or range in multiple worksheets
in the same workbook
Destination file - Answers -the workbook that receives data from another workbook
External reference - Answers -reference to cells or ranges in a worksheet from another
workbook
Hyperlink - Answers -link in a file to information within that file or another file
When a text file's data is separated by commas, it is said to be __________ - Answers
-delimited
When you edit cells in a worksheet group, the changes you make to one worksheet are
automatically applied to the other worksheets in the group - Answers -true
To ungroup worksheets, right-click _________ - Answers -any sheet tab
What is the first step in copying worksheets to another workbook? - Answers -select the
sheet tabs you want to copy
The fastest way to copy an entire worksheet to press and hold the alt key as you drag
and drop the sheet tab - Answers -false
What are the steps to enter a formula that references another worksheet? - Answers -
click the cell where you want to enter the formula, type = to enter the formula. To insert
a reference from another worksheet, click the sheet tab for the worksheet, and then
click the cell or select the range you want to reference. When the fromula is complete,
press the enter key
What is a 3-D reference? - Answers -it refers to the same cell or range in multiple
worksheets in the same workbook?
What is a worksheet range? - Answers -it is the range of worksheets you want to
reference
What is a cell range? - Answers -the same cell or range in each of those worksheets
that you want to reference
A __________ is a connection between the files that allows data to be transferred from
one file to the other - Answers -link
When two files are linked, the _________ file is the workbook that contains the data -
Answers -source
The _______ is displayed at the end of the table - Answers -total row
The __________ file (sometimes referred to as the dependent file)) is the workbook that
receives the data - Answers -destination
A reference in a formula that refers to another workbook is called a workbook reference
- Answers -false
, When you break a link using the break Links command in the Edit links dialog box, all
the external reference formulas are converted to their most recent values - Answers -
true
A ________ is a link in a file - Answers -hyperlink
To use a hyperlink, you click anywhere inside the cell that contains the link - Answers -
false
When you start excel and see the blank workbook called Book1 you are actually using a
workbook based on a template known as the __ template - Answers -default
You can create a workbook with all the formulas and formatting you need and then save
it as a template on which you can base other woekbooks - Answers -true
A ____________ is a workbook template you create that is ready to run with the
formulas for all calculations included as well as all formatting - Answers -custom
template
________ refers to data, applications, and even resources that are stored on servers
that you access over the internet rather than you own computer - Answers -cloud
computing
You can can acess your skydrive and the office web apps anywhere you have internet
access - Answers -true
When you save a worksheet as a web page, excel converts the contents of the
worksheet into XML - Answers -false
You can save an item in a worksheet as a web page - Answers -true
Worksheet group - Answers -a collection of two or ore selected worksheets
3-D reference - Answers -a reference to the same cell or range in multiple worksheets
in the same workbook
Destination file - Answers -the workbook that receives data from another workbook
External reference - Answers -reference to cells or ranges in a worksheet from another
workbook
Hyperlink - Answers -link in a file to information within that file or another file
When a text file's data is separated by commas, it is said to be __________ - Answers
-delimited
