Explore all topics
Start Free Trial
Need Help? Contact us
back arrowfull exam logo
search
ai logoChat with AI
Servicesarrow
Discoverarrow

Topics

Explore all topics
Discover more topics

Exam 10: Imports, xml, and Power Add-Ins

arrow
Exam 1: Introduction to Excel100 Questionsadd course
Exam 2: Formulas and Functions100 Questionsadd course
Exam 3: Charts100 Questionsadd course
Exam 4: Datasets and Tables100 Questionsadd course
Exam 5: Subtotals, Pivot-tables, and Pivot-charts100 Questionsadd course
Exam 6: What-If Analysis100 Questionsadd course
Exam 7: Specialized Functions100 Questionsadd course
Exam 8: Statistical Functions100 Questionsadd course
Exam 9: Multiple-Sheet Workbook Management98 Questionsadd course
Exam 10: Imports, xml, and Power Add-Ins95 Questionsadd course
Exam 11: Collaboration and Workbook Distribution96 Questionsadd course
Exam 12: Templates, styles, and Macros97 Questionsadd course
Exam 13: Office 2016 Common Features100 Questionsadd course
Select questions type
  • Essay
  • Multiple Choice
  • Short Answer
  • True False
  • Matching
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
Select questions type
  • Essay
  • Multiple Choice
  • Short Answer
  • True False
  • Matching
  • Select Tags
Match each of the following term to its best description:
Premises:
Responses:
Relationship
Tool that enables the user to build pivot tables on multiple tables
Power Query
Group of related data
Table
Cleanses data
Correct Answer:
Verified
Premises:
Responses:
Relationship
Tool that enables the user to build pivot tables on multiple tables
Power Query
Group of related data
Table
Cleanses data
Power BI
Association between two identical fields in different tables
Power Pivot
Online application suite designed to help users manage:supplement:visualize:and analyze data
(Matching)
4.9/5
(32)
Question 61

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

(Multiple Choice)
4.8/5
(42)
Question 62

You cannot maintain a connection with an XML source file.

(True/False)
4.8/5
(26)
Question 63

What application could be used to create an XML document in its native file format?

(Multiple Choice)
4.8/5
(37)
Question 64

Text string functions cannot be nested.

(True/False)
4.8/5
(35)
Question 65
Match each of the following functions to its best description:
Premises:
Responses:
SUBSTITUTE
Returns the specified number of characters from the start of a text string
RIGHT
Returns the specified number of characters from the middle of a text string,based on a starting position and number of characters
LEFT
Removes leading and trailing spaces in a text string but maintains spaces between words in a text string
Correct Answer:
Verified
Premises:
Responses:
SUBSTITUTE
Returns the specified number of characters from the start of a text string
RIGHT
Returns the specified number of characters from the middle of a text string,based on a starting position and number of characters
LEFT
Removes leading and trailing spaces in a text string but maintains spaces between words in a text string
MID
Has an optional argument that specifies which occurrence of old_text you want to replace with new_text
TRIM
Returns the specified number of characters from the end of a text string
(Matching)
4.8/5
(40)
Question 66

________ is an Excel add-in that enables you to create a visual dashboard.

(Multiple Choice)
4.7/5
(40)
Question 67

The ________ is the area that contains the dashboard in Power View.

(Short Answer)
4.9/5
(35)
Question 68

You can import text files into Excel workbooks.

(True/False)
4.8/5
(33)
Question 69

Power Query is ________.

(Multiple Choice)
4.8/5
(33)
Question 70

________ is an Excel add-in Business Intelligence tool which enables you to visualize and analyze data.

(Short Answer)
5.0/5
(37)
Question 71

Use the ________ function to combine text from multiple columns.

(Short Answer)
4.9/5
(38)
Question 72

The ________ function will change JILL JONES to jill jones.

(Short Answer)
4.9/5
(34)
Question 73

Power View is installed by default.

(True/False)
4.8/5
(46)
Question 74

=CONCATENATE(PROPER("adam")," ",PROPER("smith"))would return Adam Smith.

(True/False)
4.9/5
(34)
Question 75

A(n)________ is a user defined marker that identifies the beginning and ending of a piece of data.

(Short Answer)
4.8/5
(43)
Question 76

A tab character separates data into columns in a CSV.

(True/False)
4.8/5
(34)
Question 77
Match each of the following terms to its best description of its purpose:
Premises:
Responses:
CSV
Data sets of this type are often available for data sharing on websites like Census.gov
Text File
Unformatted data in a file with a .txt extension
Newline character
Used in CSV files
Correct Answer:
Verified
Premises:
Responses:
CSV
Data sets of this type are often available for data sharing on websites like Census.gov
Text File
Unformatted data in a file with a .txt extension
Newline character
Used in CSV files
Delimiter
Imported data that does not update its source
Embedded
Separates columns in a text file
(Matching)
4.9/5
(32)
Question 78

When connections are being refreshed in a workbook the status bar displays the message Running ________ query.

(Short Answer)
4.8/5
(34)
Question 79

What governing body developed XML?

(Multiple Choice)
4.9/5
(37)
Question 80
Showing 61 - 80 of 95
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)