Question 1

Match the following five terms to their meanings:
i.database
II.data
III.information
IV.functions
v.arguments

Accepted Answer

A) Predefined formulas that perform calculations by using specific values. 
B) The specific values used to perform calculations. 
C) Data that is organized in a useful manner. 
D) Facts about people,events,things,or ideas. 
E) An organized collection of facts related to a particular topic or purpose. 
A) Predefined formulas that perform calculations by using specific values. 
B) The specific values used to perform calculations. 
C) Data that is organized in a useful manner. 
D) Facts about people,events,things,or ideas. 
E) An organized collection of facts related to a particular topic or purpose.

Question 2

In an icon set,a green upward pointing arrow icon in a range of cells represents a higher value.

Accepted Answer

A) True 
 B)False

Question 3

Side-by-side tables must contain the same number of rows and columns.

Accepted Answer

A) True 
 B)False

Question 4

________ is an arrangement of the arguments in a function.

Accepted Answer

A) criteria 
B) schema 
C) syntax 
D) information 
A) criteria 
B) schema 
C) syntax 
D) information

Question 5

To use Flash Fill to place data in a column,the data that you want to alter must be in the adjacent column.

Accepted Answer

A) True 
 B)False

Question 6

When creating custom headers and footers,you can insert text but NOT pictures or the date.

Accepted Answer

A) True 
 B)False

Question 7

An icon set can make data visually easier to interpret.

Accepted Answer

A) True 
 B)False

Question 8

Each vertical column stores information that describes the record and is referred to as a ________.

Accepted Answer

The answer of Each vertical column stores information that describes...

Question 9

The criteria range for the DAVERAGE function must consist of at least ________ vertical cell(s).

Accepted Answer

A) one 
B) three 
C) four 
D) two 
A) one 
B) three 
C) four 
D) two

Question 10

Side-by-side tables can be sorted individually.

Accepted Answer

A) True 
 B)False

Question 11

________ are three,four,or five small graphic images that are useful for quickly identifying higher and lower numbers within a large group of data.

Accepted Answer

The answer of ________ are three,four,or five small graphic images...

Question 12

To get data that resides outside of Excel into Excel,use the commands in the ________ group.

Accepted Answer

The answer of To get data that resides outside of...

Question 13

The ________ function extracts a series of characters from a text string given the location of the beginning character.

Accepted Answer

A) FRONT 
B) LEFT 
C) MID 
D) RIGHT 
A) FRONT 
B) LEFT 
C) MID 
D) RIGHT

Question 14

If a worksheet is slightly wider and taller than the normal margins,use ________ to keep all the information on one page.

Accepted Answer

A) Scale to Fit 
B) Page Layout 
C) Orientation 
D) Margins 
A) Scale to Fit 
B) Page Layout 
C) Orientation 
D) Margins

Question 15

The ________ text function will extract a series of characters from a string of characters given the location of the beginning character.

Accepted Answer

The answer of The ________ text function will extract a...

Question 16

Excel CANNOT format text data.

Accepted Answer

A) True 
 B)False

Match the following five terms to their meanings: i.database II.data III.information IV.functions v.arguments

In an icon set,a green upward pointing arrow icon in a range of cells represents a higher value.

Side-by-side tables must contain the same number of rows and columns.

________ is an arrangement of the arguments in a function.

To use Flash Fill to place data in a column,the data that you want to alter must be in the adjacent column.

When creating custom headers and footers,you can insert text but NOT pictures or the date.

An icon set can make data visually easier to interpret.

Each vertical column stores information that describes the record and is referred to as a ________.

The criteria range for the DAVERAGE function must consist of at least ________ vertical cell(s).

Side-by-side tables can be sorted individually.

________ are three,four,or five small graphic images that are useful for quickly identifying higher and lower numbers within a large group of data.

To get data that resides outside of Excel into Excel,use the commands in the ________ group.

The ________ function extracts a series of characters from a text string given the location of the beginning character.

If a worksheet is slightly wider and taller than the normal margins,use ________ to keep all the information on one page.

The ________ text function will extract a series of characters from a string of characters given the location of the beginning character.

Excel CANNOT format text data.

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

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

Match the following five terms to their meanings: i.database II.data III.information IV.functions v.arguments

In an icon set,a green upward pointing arrow icon in a range of cells represents a higher value.

Side-by-side tables must contain the same number of rows and columns.

________ is an arrangement of the arguments in a function.

To use Flash Fill to place data in a column,the data that you want to alter must be in the adjacent column.

When creating custom headers and footers,you can insert text but NOT pictures or the date.

An icon set can make data visually easier to interpret.

Each vertical column stores information that describes the record and is referred to as a ________.

The criteria range for the DAVERAGE function must consist of at least ________ vertical cell(s).

Side-by-side tables can be sorted individually.

________ are three,four,or five small graphic images that are useful for quickly identifying higher and lower numbers within a large group of data.

To get data that resides outside of Excel into Excel,use the commands in the ________ group.

The ________ function extracts a series of characters from a text string given the location of the beginning character.

If a worksheet is slightly wider and taller than the normal margins,use ________ to keep all the information on one page.

The ________ text function will extract a series of characters from a string of characters given the location of the beginning character.

Excel CANNOT format text data.

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