Question 1

Which feature is best suited to split imported text into multiple columns?
A)Text Import Wizard
B)Column Split Wizard
C)Convert Column Tool
D)Convert Text to Columns Wizard

Accepted Answer

The Convert Text to Columns Wizard is specifically designed to split imported text into multiple columns. It allows the user to choose a delimiter (such as a comma or space) to separate the text into columns. The other options listed (Text Import Wizard, Column Split Wizard, Convert Column Tool) may have features that could aid in splitting text into columns, but they are not specifically designed for this purpose.

Question 2

This feature is a productivity tool which interprets patterns and completes data entry based on the pattern you establish.
A)Auto Fill
B)Auto Complete
C)Predictive Loading
D)Flash Fill

Accepted Answer

Flash Fill is specifically designed to interpret patterns and complete data entry based on the pattern established by the user. It is a productivity tool that can save a lot of time and effort by automating the data entry process. Auto Fill and Auto Complete do not have this level of pattern interpretation, and predictive loading is not a recognized productivity tool in this context.

Question 3

There are a total of ________ text manipulation functions in Excel.
A)4
B)10
C)27
D)7

Accepted Answer

According to Excel documentation, there are a total of 27 text manipulation functions in Excel.

Question 4

Which message displays in the status bar when a connection is being updated?
A)Running background query
B)Connections updating
C)Updating
D)Query in progress

Accepted Answer

The message "Running background query" is typically displayed in the status bar when a connection is being updated.

Question 5

What would you do to start to manage an existing connection in a linked workbook?
A)Click Manage in the Connections group of the Data tab.
B)Click Connections in the Connections group of the Data tab.
C)Click Existing Connection in the Get External Data group of the Data tab.
D)Click Refresh All in the Connections group of the Data tab.

Accepted Answer

To start managing an existing connection in a linked workbook, you should click on Connections in the Connections group of the Data tab. This option allows you to view, edit or delete the connections that currently exist in the workbook. The Manage option in the Connections group only applies when creating a new connection, not managing an existing one. Get External Data is a different option that is used to import data from an external source, not manage connections. Refresh All is used to update all of the data connections in the workbook, but does not provide options for managing individual connections.

Question 6

If you do not want to create a link to an Access database table ________.
A)use the Embed Access table command
B)copy each line of data from Access and paste into an Excel worksheet
C)open the table in Access and select data and field names and then copy and paste it into an Excel worksheet
D)Excel had no capacity to do this. It must be done in Access.

Accepted Answer

Copying and pasting data from Access to Excel without creating a link is possible by selecting the data and field names in Access and then pasting them into an Excel worksheet.

Question 7

What would be the return of the following function in C2? 
=CONCATENATE(A2," ",B2)
A)jamesturner
B)JAMES
C)james Turner
D)jamesTurner

Accepted Answer

The function will concatenate the values in cell A2 and B2 separated by a space. In this case, A2 contains "james" and B2 contains "Turner", so the function will return "james Turner" with the first letter of each name capitalized.

Question 8

Which of the following functions is not a text string manipulation tool?
A)CONCATENATE
B)MATCH
C)TRIM
D)LEFT

Accepted Answer

MATCH is not a text string manipulation tool. It is used to search for a specified item in a range of cells and returns the relative position of the item within that range. The other options (CONCATENATE, TRIM, LEFT) are all tools that manipulate text strings.

Question 9

An alternative to the CONCATENATE function is to use ________ to join strings.
A)+
B)^
C)&
D)#

Accepted Answer

The ampersand (&) symbol can be used to join strings and is a commonly used alternative to the CONCATENATE function in Excel.

Question 10

A company changes name from Wally's Widgets to Wally's Wonders.Which function would change all Wally's Widgets to Wally's Wonders?
A)SUBSTITUTE
B)TRIM
C)MID
D)LEFT

Accepted Answer

The SUBSTITUTE function can be used to change all occurrences of a specific text string in a cell or range of cells. In this scenario, we would use the SUBSTITUTE function to replace all instances of "Wally's Widgets" with "Wally's Wonders." The TRIM, MID, and LEFT functions are not relevant for this specific task.

Question 11

Embedded data in an excel workbook is ________.
A)uneditable data linked to a web source
B)data that imported using Power Query
C)any imported data
D)editable data with no link back to its original source

Accepted Answer

Embedded data in an excel workbook is editable data with no link back to its original source. It is stored within the workbook itself and can be modified without affecting the original source.

Question 12

Which of the following are settings that control how imported data in cells connect to their source data?
A)Import settings
B)Data range properties
C)Link settings
D)Data Control settings

Accepted Answer

Data range properties are settings that control how imported data in cells connect to their source data, allowing for adjustments in how data is refreshed, maintained, or displayed from the original source.

Question 13

Which of these file types cannot be imported into Excel?
A).txt
B).CSV
C).PDF
D)CAD

Accepted Answer

CAD files cannot be directly imported into Excel.

Question 14

What would be the return of the following function in C4? 
=PROPER(A4)
A)TASHA
B)tasha
C)Tasha
D)Tasha McCall

Accepted Answer

The PROPER function capitalizes the first letter of each word in a cell. Therefore, it would capitalize the first letter of "tasha" to give "Tasha."

Question 15

If you use the Text to Columns wizard to separate the Name Column in the table below into First Name and Last name columns, what would happen if you separated the names at the space between first name and last name without making any other changes to the table? 
A)Excel would add a new column to accommodate last names.
B)The two new columns would be created in a new worksheet.
C)Excel would return an error message.
D)The new last name column would overwrite the data in the street address column.

Accepted Answer

The answer of If you use the Text to Columns...

Question 16

What would be the return of the following function in C3? 
=LOWER(B3)
A)STEWART
B)Stewart
C)stewart
D)Aaron Stewart

Accepted Answer

The LOWER function will convert any uppercase letters in the cell B3 to lowercase. If the original value in B3 was "STEWART", the function will return "stewart".

Question 17

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?
A)TRIM
B)LEFT
C)CONCATENATE
D)SUBSTITUTE

Accepted Answer

The SUBSTITUTE function is best suited for replacing specific text within a text string, such as "Doctor" with "Dr." We can use the SUBSTITUTE function to replace all instances of "Doctor" with "Dr." in a text string.

Question 18

On which tab is the Text to Columns Wizard?
A)Insert
B)Data
C)Formula
D)Developer

Accepted Answer

The Text to Columns Wizard is located on the Data tab in Excel. This wizard allows users to separate data in a single cell into multiple columns based on a chosen delimiter or fixed width.

Question 19

Which of the following actions refreshes data connections in a linked Excel workbook?
A)Click Existing Connection in the Get External Data group of the Data tab.
B)Click Refresh on the File tab.
C)Right-click on the data table and select Refresh all.
D)Click Refresh All in the Connections group of the Data tab.

Accepted Answer

Clicking Refresh All in the Connections group of the Data tab will refresh all the data connections in a linked Excel workbook.

Question 20

What do you call characters that separate data?
A)Hollariths
B)Separators
C)Hashes
D)Delimiters

Accepted Answer

Delimiters are characters that separate data or define the boundaries between different pieces of data in a file or a string of text. They are used in programming and data storage to facilitate the parsing and processing of data. Examples of delimiters include commas, semicolons, tabs, spaces, brackets, and quotation marks.

Quiz 10: Imports, Xml, and Power Add-Ins

Which feature is best suited to split imported text into multiple columns?

This feature is a productivity tool which interprets patterns and completes data entry based on the pattern you establish.

There are a total of ________ text manipulation functions in Excel.

Which message displays in the status bar when a connection is being updated?

What would you do to start to manage an existing connection in a linked workbook?

If you do not want to create a link to an Access database table ________.

What would be the return of the following function in C2? =CONCATENATE(A2," ",B2)

Which of the following functions is not a text string manipulation tool?

An alternative to the CONCATENATE function is to use ________ to join strings.

A company changes name from Wally's Widgets to Wally's Wonders.Which function would change all Wally's Widgets to Wally's Wonders?

Embedded data in an excel workbook is ________.

Which of the following are settings that control how imported data in cells connect to their source data?

Which of these file types cannot be imported into Excel?

What would be the return of the following function in C4? =PROPER(A4)

If you use the Text to Columns wizard to separate the Name Column in the table below into First Name and Last name columns, what would happen if you separated the names at the space between first name and last name without making any other changes to the table?

What would be the return of the following function in C3? =LOWER(B3)

Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?

On which tab is the Text to Columns Wizard?

Which of the following actions refreshes data connections in a linked Excel workbook?

What do you call characters that separate data?