Question 1

________ is a web language that was created to tell the browser how to properly display the web page.

Accepted Answer

A) HTML 
B) XML 
C) VBA 
D) Query 
A) HTML 
B) XML 
C) VBA 
D) Query A

Question 2

A(n)________ document is saved as an .xsd file.

Accepted Answer

XML schema

Question 3

To remove all spaces from text except for single spaces between words,use the ________ function.

Accepted Answer

A) CLEAN 
B) PROPER 
C) TRIM 
D) SUBSTITUTE 
A) CLEAN 
B) PROPER 
C) TRIM 
D) SUBSTITUTE C

Question 4

HTML and XML are both examples of ________.

Accepted Answer

A) markup languages 
B) web query sources 
C) tags 
D) multimedia 
A) markup languages 
B) web query sources 
C) tags 
D) multimedia

Question 5

Excel has a query wizard built into its Microsoft Query function that can be a very powerful aid for linking a worksheet to an Access database.

Accepted Answer

A) True 
 B)False

Question 6

External data connections for Excel can be found on the ________ tab.

Accepted Answer

A) Insert 
B) View 
C) Data 
D) File 
A) Insert 
B) View 
C) Data 
D) File

Question 7

Flash Fill involves more typing than traditional text functions and can be more difficult to use on touch-enabled devices.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Text file
CSV file
Delimiter
Metadata
Tab-delimited file

Accepted Answer

The Answer of A simple container of text data and is...

Question 9

Text files are imported into Excel in a similar manner as XML and HTML files.

Accepted Answer

A) True 
 B)False

Question 10

Excel has the ability to consolidate diverse types of data.

Accepted Answer

A) True 
 B)False

Question 11

When a primary key from one table is connected to another table,it is said to be a ________ key.

Accepted Answer

A) primary 
B) foreign 
C) super 
D) secondary 
A) primary 
B) foreign 
C) super 
D) secondary

Question 12

Match between columns
                        Premises: LEN
RIGHT
LEFT
CONCATENATE
MID

Accepted Answer

The Answer of Returns the specified number of characters from is...

Question 13

Copy and pasting data from a website and using a web query have the same result.

Accepted Answer

A) True 
 B)False

Question 14

To import a text file into Excel with all the text import features,click the ________ tab.

Accepted Answer

A) Data 
B) New 
C) Info 
D) Options 
A) Data 
B) New 
C) Info 
D) Options

Question 15

Which of the following is NOT true of text files?

Accepted Answer

A) Text files do not contain graphics. 
B) Text files are also called ASCII files. 
C) Text files contain formatting. 
D) Text files are larger than XML files. 
A) Text files do not contain graphics. 
B) Text files are also called ASCII files. 
C) Text files contain formatting. 
D) Text files are larger than XML files.

Question 16

________ are functions that manipulate data to clean it up and make it useful.

Accepted Answer

A) Text functions 
B) Data functions 
C) Data verification 
D) Data cleansing 
A) Text functions 
B) Data functions 
C) Data verification 
D) Data cleansing

Question 17

All of the following are common formats used to import data into Excel EXCEPT ________.

Accepted Answer

A) ODBC 
B) HTML 
C) XML 
D) .accdb 
A) ODBC 
B) HTML 
C) XML 
D) .accdb

Question 18

Conditional formatting can aid in removing duplicate data.

Accepted Answer

A) True 
 B)False

Question 19

Most organizations keep their information in one single data source.

Accepted Answer

A) True 
 B)False

Question 20

All of the following statements are TRUE about connecting to an Access database EXCEPT:

Accepted Answer

A) You can copy and paste data from an Access table into a blank Excel worksheet. 
B) Within Access, users have the option of exporting tabular data into an Excel format. 
C) For longer-term projects, a permanent connection between an Access database and the Excel application can be created by using the Access Data Connect feature. 
D) Live data from a permanent connection can be imported as a simple table, or even a PivotTable report or PivotChart. 
A) You can copy and paste data from an Access table into a blank Excel worksheet. 
B) Within Access, users have the option of exporting tabular data into an Excel format. 
C) For longer-term projects, a permanent connection between an Access database and the Excel application can be created by using the Access Data Connect feature. 
D) Live data from a permanent connection can be imported as a simple table, or even a PivotTable report or PivotChart.

________ is a web language that was created to tell the browser how to properly display the web page.

A(n)________ document is saved as an .xsd file.

To remove all spaces from text except for single spaces between words,use the ________ function.

HTML and XML are both examples of ________.

Excel has a query wizard built into its Microsoft Query function that can be a very powerful aid for linking a worksheet to an Access database.

External data connections for Excel can be found on the ________ tab.

Flash Fill involves more typing than traditional text functions and can be more difficult to use on touch-enabled devices.

Text files are imported into Excel in a similar manner as XML and HTML files.

Excel has the ability to consolidate diverse types of data.

When a primary key from one table is connected to another table,it is said to be a ________ key.

Copy and pasting data from a website and using a web query have the same result.

To import a text file into Excel with all the text import features,click the ________ tab.

Which of the following is NOT true of text files?

________ are functions that manipulate data to clean it up and make it useful.

All of the following are common formats used to import data into Excel EXCEPT ________.

Conditional formatting can aid in removing duplicate data.

Most organizations keep their information in one single data source.

All of the following statements are TRUE about connecting to an Access database EXCEPT:

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 9: Organize, import, export, and Cleanse Data Sets

________ is a web language that was created to tell the browser how to properly display the web page.

A(n)________ document is saved as an .xsd file.

To remove all spaces from text except for single spaces between words,use the ________ function.

HTML and XML are both examples of ________.

Excel has a query wizard built into its Microsoft Query function that can be a very powerful aid for linking a worksheet to an Access database.

External data connections for Excel can be found on the ________ tab.

Flash Fill involves more typing than traditional text functions and can be more difficult to use on touch-enabled devices.

Text files are imported into Excel in a similar manner as XML and HTML files.

Excel has the ability to consolidate diverse types of data.

When a primary key from one table is connected to another table,it is said to be a ________ key.

Copy and pasting data from a website and using a web query have the same result.

To import a text file into Excel with all the text import features,click the ________ tab.

Which of the following is NOT true of text files?

________ are functions that manipulate data to clean it up and make it useful.

All of the following are common formats used to import data into Excel EXCEPT ________.

Conditional formatting can aid in removing duplicate data.

Most organizations keep their information in one single data source.

All of the following statements are TRUE about connecting to an Access database EXCEPT:

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters