Quiz
Exam 2 Tutorial 11
This quiz has question types that open in the usual player.
Questions in this quiz (22)
1 When a text file’s data is separated by commas, it is said to be [blank_start]delimited[blank_end].
- Adelimited
2True/False: A text file contains number, text, formulas, and special fonts. (
- ATrue
- BFalse
3. A [blank_start]connection[blank_end] is a defined method of retrieving data from an external file.
- Aconnection
4To delete a connection to its data source, select the connection in the list in the Workbook Connections
dialog box, and then click the [blank_start]remove[blank_end] button.- Aremove
5True/False: You can define how Excel updates, or refreshes, the data.
- ATrue
- BFalse
6 How do you apply a connection to a new location?
- A(Answer: Click the Existing Connections button in
the Get External Data group on the Data tab. Open the connection you want to apply, and specify the new
location in the workbook.) - BDead Dragons
- A(Answer: Click the Existing Connections button in
7Where do you find the Trust Center in Excel?
- A(Answer: Click the Office Button and then click the
Excel Options button.) - BDead Dragons
- A(Answer: Click the Office Button and then click the
8You define a trusted location through the [blank_start]trust center[blank_end].
- Atrust center
9True/False: When other users copy your Excel projects to their own computers, path names to external
data sources might change and become unusable.- ATrue
- BFalse
10A [blank_start]database[blank_end] is a file that stores a collection of related data.
- Adatabase
11 A [blank_start]table[blank_end] is a collection of data arranged in rows and columns.
- Atable
12A [blank_start]query[blank_end] is a question you ask about the data in the database.
- Aquery
13 True/False: In a database, a table and a query are actually the same thing.
- ATrue
- BFalse
14 True/False: The first step in the Query Wizard is to create a data source.
- ATrue
- BFalse
15What is a data filter?
- A(Answer: When you filter data, you specify which records you want to retrieve
using specific criteria.) - BDead as Shit dragon skullz
- A(Answer: When you filter data, you specify which records you want to retrieve
16What is a filter?
- A(Answer: When you filter data, you specify which records you want to retrieve using
specific criteria.) - BLame Dead Dragons
- A(Answer: When you filter data, you specify which records you want to retrieve using
17 True/False: When Excel imports external data into a PivotTable, the initial table is empty
- ATrue
- BFalse
18. When you [blank_start]refresh[blank_end] a query, Excel retrieves the most current data from the data source, using the query
definition you have created.- Arefresh
19[blank_start]RTF[blank_end] is a file format that allows for text formatting styles including boldface, italic, and color, but
not advanced features such as hyperlinks or complicated table structures.
- ARTF
20. Data in an XML document is contained within [blank_start]element[blank_end]s.
- Aelements
21 A(n) [blank_start]opening tag[blank_end] marks the beginning of the data value.
- Aopening tag
22 A(n) [blank_start]data map[blank_end] can be created that displays the layout of the elements in a schematic diagram. (Answer:
data map)- Adata map
Information
- Description
- 2610 BCIS Quiz on Exam 2 Tutorial 11, created by Chris Serrano on 30/10/2015.
- Author
- Chris Serrano
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz