Quiz
Exam 2 Tutorial 6
This quiz has question types that open in the usual player.
Questions in this quiz (15)
1 True/False. 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.- ATrue
- BFalse
2To ungroup worksheets, right-click [blank_start]sheet tab[blank_end].
- Asheet tab
3What is the first step in copying worksheets to another workbook? [blank_start]Select the sheet tabs youwant to copy[blank_end]
- ASelect the sheet tabs you want to copy
4 What is a 3-D reference?
- AIt refers to the same cell or range in multiple worksheets in the
same workbook.) - BDragons
- AIt refers to the same cell or range in multiple worksheets in the
5What is a Worksheet Range?
- A(Answer: It is the range of worksheets you want to
reference.) - BDead Dragons
- A(Answer: It is the range of worksheets you want to
6 What is a CellRange?
- A(Answer: The same cell or range in each of those worksheets that you want to
reference.) - BSuper Fucking Dead Dragons
- A(Answer: The same cell or range in each of those worksheets that you want to
7When two files are linked, the [blank_start]source[blank_end] file is the workbook that contains the data.
- Asource
8 The [blank_start]destination[blank_end] file (sometimes referred to as the dependent file) is the workbook that receives the data.
- Adestination
9 True/False. A reference in a formula that refers to another workbook is called a workbook reference.
- ATrue
- BFalse
10 True/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.- ATrue
- BFalse
11A [blank_start]hyperlink[blank_end] is a link in a file
- Ahyperlink
12. True/False. To use a hyperlink, you click the anywhere inside the cell that contains the link.
- ATrue
- BFalse
13True/False. 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 workbooks.- ATrue
- BFalse
14 A [blank_start]custom template[blank_end] is a workbook template you create that is ready to run with the formulas for all calculations
included as well as all formatting.- Acustom template
15 True/False. When you save a worksheet as a Web page, Excel converts the contents of the worksheet
into XML.- ATrue
- BFalse
Information
- Description
- 2610 BCIS Quiz on Exam 2 Tutorial 6, created by Chris Serrano on 30/10/2015.
- Author
- Chris Serrano
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz