Question 1

A mixed reference "locks" one part of the cell reference while the other part can change._______________

Accepted Answer

A) True 
 B)False  True

Question 2

Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

Accepted Answer

A) EXACT 
B) 1 
C) TRUE 
D) FALSE 
A) EXACT 
B) 1 
C) TRUE 
D) FALSE D

Question 3

Which function counts how many cells in a range contain numbers,where value1,value2,and so forth are text,numbers,or cell references?

Accepted Answer

A) SUM 
B) COUNT 
C) COUNTA 
D) AUTOSUM 
A) SUM 
B) COUNT 
C) COUNTA 
D) AUTOSUM B

Question 4

Use ____ references when you want different formulas to refer to the same cell.

Accepted Answer

A) mixed 
B) relative 
C) absolute 
D) fixed 
A) mixed 
B) relative 
C) absolute 
D) fixed

Question 5

Which of the following is a Math & Trig function? ____

Accepted Answer

A) INT 
B) COUNT 
C) MIN 
D) AVERAGE 
A) INT 
B) COUNT 
C) MIN 
D) AVERAGE

Question 6

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

Accepted Answer

A) True 
 B)False

Question 7

Ellen opens Excel 2016 and enters her monthly income for one year beginning with January.To create a series of months,she can ____.

Accepted Answer

A) Type = Jan-Dec in cell A1 and then press Enter. 
B) Type January in cell A1 and then drag the filll handle. 
C) Type =YEAR in cell A1 and then press Enter. 
D) Type =DATE(Jan, Dec) in cell A1 and then press Enter. 
A) Type = Jan-Dec in cell A1 and then press Enter. 
B) Type January in cell A1 and then drag the filll handle. 
C) Type =YEAR in cell A1 and then press Enter. 
D) Type =DATE(Jan, Dec) in cell A1 and then press Enter.

Question 8

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

Accepted Answer

A) cell 
B) relative 
C) absolute 
D) formula 
A) cell 
B) relative 
C) absolute 
D) formula

Question 9

An argument can be any type of value including text,numbers,cell references,or even other formulas or functions._______________

Accepted Answer

A) True 
 B)False

Question 10

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

Accepted Answer

A) Absolute 
B) Relative 
C) Mixed 
D) Matched 
A) Absolute 
B) Relative 
C) Mixed 
D) Matched

Question 11

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current cell._________________

Accepted Answer

A) True 
 B)False

Question 12

Another name for the middle value is the ____ value.

Accepted Answer

A) mode 
B) center 
C) median 
D) relative 
A) mode 
B) center 
C) median 
D) relative

Question 13

A constant is a value in a formula that doesn't change._______________

Accepted Answer

A) True 
 B)False

Question 14

If an optional argument is not included,Excel assumes a(n)____ value for it.

Accepted Answer

A) default 
B) generic 
C) static 
D) absolute 
A) default 
B) generic 
C) static 
D) absolute

Question 15

In "SUM(number1 [,number2,number3,...])",number 1,number 2,and number 3 may be numbers or ____.

Accepted Answer

A) letters 
B) cell references 
C) symbols 
D) operators 
A) letters 
B) cell references 
C) symbols 
D) operators

Question 16

The ____________________ is the middle value from a sample.

Accepted Answer

The answer of The ____________________ is the middle value from...

Question 17

Which of the following is a Statistical function? _____

Accepted Answer

A) INT 
B) RAND 
C) ROUND 
D) AVERAGE 
A) INT 
B) RAND 
C) ROUND 
D) AVERAGE

Question 18

The fill handle copies ____.

Accepted Answer

A) content only 
B) formats only 
C) content and formats 
D) formats and cell references 
A) content only 
B) formats only 
C) content and formats 
D) formats and cell references

Question 19

Which of the following is not an Excel function category? ____

Accepted Answer

A) Math & Trig 
B) Algebra 
C) Statistical 
D) Text 
A) Math & Trig 
B) Algebra 
C) Statistical 
D) Text

Question 20

The Fill Formatting Only option,which is the default,copies both the content and the formatting.______________

Accepted Answer

A) True 
 B)False

A mixed reference "locks" one part of the cell reference while the other part can change._______________

Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

Which function counts how many cells in a range contain numbers,where value1,value2,and so forth are text,numbers,or cell references?

Use ____ references when you want different formulas to refer to the same cell.

Which of the following is a Math & Trig function? ____

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

Ellen opens Excel 2016 and enters her monthly income for one year beginning with January.To create a series of months,she can ____.

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

An argument can be any type of value including text,numbers,cell references,or even other formulas or functions._______________

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current cell._________________

Another name for the middle value is the ____ value.

A constant is a value in a formula that doesn't change._______________

If an optional argument is not included,Excel assumes a(n)____ value for it.

In "SUM(number1 [,number2,number3,...])",number 1,number 2,and number 3 may be numbers or ____.

The ____________________ is the middle value from a sample.

Which of the following is a Statistical function? _____

The fill handle copies ____.

Which of the following is not an Excel function category? ____

The Fill Formatting Only option,which is the default,copies both the content and the formatting.______________

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 9: Performing Calculations With Formulas and Functions

A mixed reference "locks" one part of the cell reference while the other part can change._______________

Susan needs to use a lookup function to find an exact match of an inventory item,so she will set the range_lookup value to _______ .

Which function counts how many cells in a range contain numbers,where value1,value2,and so forth are text,numbers,or cell references?

Use ____ references when you want different formulas to refer to the same cell.

Which of the following is a Math & Trig function? ____

A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook._________________________

Ellen opens Excel 2016 and enters her monthly income for one year beginning with January.To create a series of months,she can ____.

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

An argument can be any type of value including text,numbers,cell references,or even other formulas or functions._______________

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

When a formula includes a cell reference,Excel interprets that cell reference as being located relative to the position of the current cell._________________

Another name for the middle value is the ____ value.

A constant is a value in a formula that doesn't change._______________

If an optional argument is not included,Excel assumes a(n)____ value for it.

In "SUM(number1 [,number2,number3,...])",number 1,number 2,and number 3 may be numbers or ____.

The ____________________ is the middle value from a sample.

Which of the following is a Statistical function? _____

The fill handle copies ____.

Which of the following is not an Excel function category? ____

The Fill Formatting Only option,which is the default,copies both the content and the formatting.______________

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters