Question 1

The Quick Access gallery provides easy access to common formatting tools

Accepted Answer

A) True 
 B)False

Question 2

AVERAGE is a common statistical function

Accepted Answer

A) True 
 B)False

Question 3

You are working on a spreadsheet that contains many different kinds of calculations. Your supervisor knows that Excel has built-in functions for many of the calculations. 
 Your spreadsheet contains a list of dates and you need to determine the intervals between the dates in the list. Which set of functions should you use to determine how many days have passed?

Accepted Answer

You should use the Date & Time

Question 4

In the accompanying figure, which item displays where the result of the function will appear?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 5

You are working on a spreadsheet that contains many different kinds of calculations. Your supervisor knows that Excel has built-in functions for many of the calculations. 
 Your spreadsheet contains a set of test results, and your supervisor needs to know information such as the average, maximum, and minimum. Which set of functions should you use in your spreadsheet?

Accepted Answer

You should use the statistical

Question 6

To display only the data you need, you can use the ____ feature.

Accepted Answer

A)  filter 
B)  sort 
C)  criteria 
D)  analysis 
A)  filter 
B)  sort 
C)  criteria 
D)  analysis

Question 7

In the accompanying figure, which item is the name of a function?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 8

What are the four parts to every function?

Accepted Answer

A)  an equal sign, the function name, a set of parentheses, and variables 
B)  an equal sign, the function name, a set of brackets, and arguments 
C)  an equal sign, the function name, a set of parentheses, and arguments 
D)  a plus sign, the function name, a set of parentheses, and arguments 
A)  an equal sign, the function name, a set of parentheses, and variables 
B)  an equal sign, the function name, a set of brackets, and arguments 
C)  an equal sign, the function name, a set of parentheses, and arguments 
D)  a plus sign, the function name, a set of parentheses, and arguments

Question 9

If your Excel table contains a large amount of data, you might want to ____ it to display only the data you need.

Accepted Answer

A)  sort 
B)  update 
C)  filter 
D)  organize 
A)  sort 
B)  update 
C)  filter 
D)  organize

Question 10

A(n) ____________________ cell reference is a cell reference that always stays the same, even when you copy a formula that contains it to a new location.

Accepted Answer

The answer of A(n) ____________________ cell reference is a cell...

Question 11

In the accompanying figure, what is another type of conditional formatting that could be applied to the Total Sales Less Returns column?

Accepted Answer

A)  Icon Sets 
B)  Sparklines 
C)  Data Boxes 
D)  Blends 
A)  Icon Sets 
B)  Sparklines 
C)  Data Boxes 
D)  Blends

Question 12

In the accompanying figure, which item represents a description of the function?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 13

You have a spreadsheet containing the sales figures for every sale that has taken place in your organization. The spreadsheet includes the sales person's name, the customer's name, the date of the sale, the amount of the sale, as well as the highest and lowest priced items from the sale. 
 Your supervisor would like to see the sales figures arranged by total sales and then sales person. How can you rearrange the figures to accomplish her request?

Accepted Answer

Convert the range of data to a table and

Question 14

Rows of data in an Excel table are called ____.

Accepted Answer

A)  sets 
B)  table rows 
C)  fields 
D)  records 
A)  sets 
B)  table rows 
C)  fields 
D)  records

Question 15

To make a range of cells stand out visually, you may want to apply ____ and borders.

Accepted Answer

A)  patterns 
B)  sticky notes 
C)  hatch marks 
D)  shading 
A)  patterns 
B)  sticky notes 
C)  hatch marks 
D)  shading

Question 16

____________________ are all of the information a function needs to perform a task.

Accepted Answer

The answer of ____________________ are all of the information a...

Question 17

You can identify the smallest value in a range of cells using the ____________________ function.

Accepted Answer

The answer of You can identify the smallest value in...

Question 18

When you choose from a list of available filters for a column, you are specifying the ____ you wish to use to filter the data.

Accepted Answer

A)  criteria 
B)  values 
C)  order 
D)  data 
A)  criteria 
B)  values 
C)  order 
D)  data

Question 19

To change the way a page breaks, in the Page Break Preview, drag the ____ dotted line.

Accepted Answer

A)  blue 
B)  black 
C)  red 
D)  white 
A)  blue 
B)  black 
C)  red 
D)  white

Question 20

Describe how Microsoft Excel computes formulas containing more than one operator.

Accepted Answer

When a formula contains multiple operato

The Quick Access gallery provides easy access to common formatting tools

AVERAGE is a common statistical function

In the accompanying figure, which item displays where the result of the function will appear?

To display only the data you need, you can use the ____ feature.

In the accompanying figure, which item is the name of a function?

What are the four parts to every function?

If your Excel table contains a large amount of data, you might want to ____ it to display only the data you need.

A(n) ____________________ cell reference is a cell reference that always stays the same, even when you copy a formula that contains it to a new location.

In the accompanying figure, what is another type of conditional formatting that could be applied to the Total Sales Less Returns column?

In the accompanying figure, which item represents a description of the function?

Rows of data in an Excel table are called ____.

To make a range of cells stand out visually, you may want to apply ____ and borders.

____________________ are all of the information a function needs to perform a task.

You can identify the smallest value in a range of cells using the ____________________ function.

When you choose from a list of available filters for a column, you are specifying the ____ you wish to use to filter the data.

To change the way a page breaks, in the Page Break Preview, drag the ____ dotted line.

Describe how Microsoft Excel computes formulas containing more than one operator.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Working With Charts

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters

Exam 8: Using Complex Formulas, Functions, and Tables

The Quick Access gallery provides easy access to common formatting tools

AVERAGE is a common statistical function

In the accompanying figure, which item displays where the result of the function will appear?

To display only the data you need, you can use the ____ feature.

In the accompanying figure, which item is the name of a function?

What are the four parts to every function?

If your Excel table contains a large amount of data, you might want to ____ it to display only the data you need.

A(n) ____________________ cell reference is a cell reference that always stays the same, even when you copy a formula that contains it to a new location.

In the accompanying figure, what is another type of conditional formatting that could be applied to the Total Sales Less Returns column?

In the accompanying figure, which item represents a description of the function?

Rows of data in an Excel table are called ____.

To make a range of cells stand out visually, you may want to apply ____ and borders.

____________________ are all of the information a function needs to perform a task.

You can identify the smallest value in a range of cells using the ____________________ function.

When you choose from a list of available filters for a column, you are specifying the ____ you wish to use to filter the data.

To change the way a page breaks, in the Page Break Preview, drag the ____ dotted line.

Describe how Microsoft Excel computes formulas containing more than one operator.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Working With Charts

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters