Exam 7: Organizing Data for Effective Analysis

The term ____________________ is commonly used in the XML community to describe an XML document that is properly structured, and meets established rules and guidelines for how data is described and defined using XML.

(Short Answer)

4.8/5

(40)

Question 41

An Excel ____________________ is a range of cells that you formalize as a single unit of data.

(Short Answer)

4.8/5

(35)

Question 42

Identify the letter of the choice that best matches the date and time function. -Converts a serial number to a day of the week

(Multiple Choice)

4.8/5

(42)

Question 43

A(n) list is a set of related data that is stored in tables. _________________________

(True/False)

4.9/5

(44)

Question 44

The FIXED function rounds a number to a specified number of decimals and returns the number as text with ____.

(Multiple Choice)

4.8/5

(38)

Question 45

The TRIM function removes all spaces in a text string except for the single spaces ____.

(Multiple Choice)

4.9/5

(38)

Question 46

The Subtotal command creates summary reports that quickly organize data into categories with subtotal calculations.

(True/False)

4.9/5

(39)

Question 47

The TRIM function removes all spaces in a text string except for the single spaces between words.

(True/False)

4.9/5

(39)

Question 48

The ____ function converts lowercase letters in a text string to uppercase.

(Multiple Choice)

4.9/5

(31)

Question 49

XML stands for ____________________.

(Short Answer)

4.8/5

(35)

Question 50

The data format that separates the values in each record with commas is often called ____.

(Multiple Choice)

4.8/5

(34)

Question 51

The FIXED function rounds a number to a specified number of decimals and returns the number as text with commas and a period. _________________________

(True/False)

4.8/5

(37)

Question 52

A(n) ____________________ is a single characteristic of the entity, such as a product ID number or an address.

(Short Answer)

5.0/5

(29)

Question 53

The ____________________ function combines the values in a range of cells into one text item in a new cell.

(Short Answer)

4.9/5

(44)

Question 54

The ____ function converts a text string that represents a number (a number, date, or time) to a number.

(Multiple Choice)

4.9/5

(35)

Question 55

The PivotTable ____________________ task pane contains a list of fields in the data source you selected for the PivotTable report.

(Short Answer)

4.9/5

(36)

Question 56

When data is formatted as an Excel table, you can insert a new row into the table by selecting the last cell in the last row of the existing data and pressing the ____ key to create a new row.

(Multiple Choice)

4.8/5

(36)

Question 57

The syntax for the CONCATENATE function is as follows: ____.

(Multiple Choice)

4.9/5

(42)

Question 58

When you create an Excel table, drop-down list arrows appear in the header row for each column when the ArrowFilter feature is enabled. _________________________

(True/False)

4.7/5

(28)

Question 59

____ is data that describes other data.

(Multiple Choice)

4.7/5

(29)

Question 60

Showing 41 - 60 of 150

The term ____________________ is commonly used in the XML community to describe an XML document that is properly structured, and meets established rules and guidelines for how data is described and defined using XML.

An Excel ____________________ is a range of cells that you formalize as a single unit of data.

Identify the letter of the choice that best matches the date and time function. -Converts a serial number to a day of the week

A(n) list is a set of related data that is stored in tables. _________________________

The FIXED function rounds a number to a specified number of decimals and returns the number as text with ____.

The TRIM function removes all spaces in a text string except for the single spaces ____.

The Subtotal command creates summary reports that quickly organize data into categories with subtotal calculations.

The TRIM function removes all spaces in a text string except for the single spaces between words.

The ____ function converts lowercase letters in a text string to uppercase.

XML stands for ____________________.

The data format that separates the values in each record with commas is often called ____.

The FIXED function rounds a number to a specified number of decimals and returns the number as text with commas and a period. _________________________

A(n) ____________________ is a single characteristic of the entity, such as a product ID number or an address.

The ____________________ function combines the values in a range of cells into one text item in a new cell.

The ____ function converts a text string that represents a number (a number, date, or time) to a number.

The PivotTable ____________________ task pane contains a list of fields in the data source you selected for the PivotTable report.

When data is formatted as an Excel table, you can insert a new row into the table by selecting the last cell in the last row of the existing data and pressing the ____ key to create a new row.

The syntax for the CONCATENATE function is as follows: ____.

When you create an Excel table, drop-down list arrows appear in the header row for each column when the ArrowFilter feature is enabled. _________________________

____ is data that describes other data.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters