Exam 10: Excell: External Data, Database Functions, and Side-By-Side Tables

Explore all topics

When getting external data into Excel,you can establish connections to the external data so that you can automatically update your Excel workbook from the original data.

(True/False)

4.7/5

(33)

Question 41

The ________ Wizard assists you with steps to import a text file into Excel.

(Short Answer)

4.8/5

(45)

Question 42

In Excel,you can create simple ________,which are collections of data related to a particular topic or purpose.

(Multiple Choice)

4.9/5

(29)

Question 43

To bring data from other sources into Excel you ________ the data.

(Multiple Choice)

4.8/5

(33)

Question 44

Database functions are identified by the letters DF.

(True/False)

4.7/5

(33)

Question 45

Functions are predefined formulas that perform calculations by using specific values,called ________.

(Multiple Choice)

4.9/5

(38)

Question 46

Match the following five terms to their meanings: i.external data II.database III.record IV.field v.table

(Multiple Choice)

4.8/5

(38)

Question 47

Microsoft Access is a database program that manages database files.

(True/False)

4.8/5

(28)

Question 48

Match the following four terms to their meanings: i.conditional formatting II.icons III.icon sets IV.filtering controls

(Multiple Choice)

4.9/5

(38)

Question 49

Another term for filtering controls is filtering ________,because of how they display in the table.

(Short Answer)

5.0/5

(35)

Question 50

The ________ function returns the specified number of characters from the end of a string of characters.

(Multiple Choice)

4.8/5

(29)

Question 51

Match the following five text functions to their descriptions: i.RIGHT II.MID III.UPPER IV.LOWER v.PROPER

(Multiple Choice)

4.8/5

(44)

Question 52

Excel includes several tools to help you clean up data automatically.

(True/False)

4.7/5

(40)

Question 53

From Excel you can establish links,also known as data ________,to external data so that you can update your Excel workbook from the original data whenever it changes.

(Short Answer)

4.8/5

(39)

Question 54

When you convert data to a table,a table style is applied,and the headings display ________ arrows.

(Multiple Choice)

4.8/5

(38)

Question 55

A(n)________ is a collection of data related to a particular topic or purpose.

(Short Answer)

4.8/5

(33)

Question 56

Data in a worksheet is NOT always formatted in a way you can use it.

(True/False)

4.9/5

(38)

Question 57

The ________ function removes extra blank spaces from a string of characters.

(Multiple Choice)

4.8/5

(42)

Question 58

Imported data must be free of duplicate data or it will result in an error.

(True/False)

4.7/5

(34)

Question 59

You can create custom headers and footers to provide useful information about your worksheet.

(True/False)

5.0/5

(41)

Question 60

Showing 41 - 60 of 96

When getting external data into Excel,you can establish connections to the external data so that you can automatically update your Excel workbook from the original data.

The ________ Wizard assists you with steps to import a text file into Excel.

In Excel,you can create simple ________,which are collections of data related to a particular topic or purpose.

To bring data from other sources into Excel you ________ the data.

Database functions are identified by the letters DF.

Functions are predefined formulas that perform calculations by using specific values,called ________.

Match the following five terms to their meanings: i.external data II.database III.record IV.field v.table

Microsoft Access is a database program that manages database files.

Match the following four terms to their meanings: i.conditional formatting II.icons III.icon sets IV.filtering controls

Another term for filtering controls is filtering ________,because of how they display in the table.

The ________ function returns the specified number of characters from the end of a string of characters.

Match the following five text functions to their descriptions: i.RIGHT II.MID III.UPPER IV.LOWER v.PROPER

Excel includes several tools to help you clean up data automatically.

From Excel you can establish links,also known as data ________,to external data so that you can update your Excel workbook from the original data whenever it changes.

When you convert data to a table,a table style is applied,and the headings display ________ arrows.

A(n)________ is a collection of data related to a particular topic or purpose.

Data in a worksheet is NOT always formatted in a way you can use it.

The ________ function removes extra blank spaces from a string of characters.

Imported data must be free of duplicate data or it will result in an error.

You can create custom headers and footers to provide useful information about your worksheet.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters