Exam 9: Performing Calculations With Formulas and Functions

Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function,specifying the lookup value and other criteria,the lookup value cannot be found. It displays ______ error value in the cell.

(Multiple Choice)

4.9/5

(30)

Question 21

Which of the following is not a date function? ____

(Multiple Choice)

4.9/5

(29)

Question 22

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal._________________________

(True/False)

4.7/5

(40)

Question 23

When you copy a formula that contains an absolute reference to a new location,the reference ____.

(Multiple Choice)

4.7/5

(31)

Question 24

=IF(G22="x",SUM(H22:J22), " ")with display ______ if G22 is not equal to "x".

(Multiple Choice)

4.8/5

(35)

Question 25

By default,AutoFill copies only the content not the formatting of the original range to the selected range._______________

(True/False)

4.8/5

(34)

Question 26

TODAY is an example of a(n)____________________ function.

(Short Answer)

4.8/5

(33)

Question 27

Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal.She can use ______.

(Multiple Choice)

4.8/5

(30)

Question 28

Absolute references are marked with a ____.

(Multiple Choice)

4.8/5

(30)

Question 29

To display the current date and time,which is updated each time the workbook is reopened, use the TODAY function._______________

(True/False)

4.8/5

(30)

Question 30

A logical function is a function that works with values that are either ____.

(Multiple Choice)

4.8/5

(30)

Question 31

Functions are organized in the Function Library group on the FORMULAS tab._______________

(True/False)

4.9/5

(28)

Question 32

The ____ function returns the maximum value in the range.

(Multiple Choice)

4.8/5

(42)

Question 33

Using AutoFill,what would be the extended series of the initial entry Jan? ___

(Multiple Choice)

4.8/5

(31)

Question 34

____________________ is a set of rules which specifies how a function should be written.

(Short Answer)

4.9/5

(36)

Question 35

Which of the following is not a comparison operator? ____

(Multiple Choice)

4.8/5

(42)

Question 36

Lookup tables can be constructed for exact match or approximate match lookups._______________

(True/False)

4.8/5

(26)

Question 37

An error value indicates that some part of a function is preventing Excel from returning a calculated value.________________

(True/False)

4.9/5

(41)

Question 38

In the formula =INT(AVERAGE(A1:A100)),which would occur first? ____

(Multiple Choice)

4.9/5

(28)

Question 39

If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.

(Multiple Choice)

4.8/5

(32)

Question 40

Showing 21 - 40 of 75

Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function,specifying the lookup value and other criteria,the lookup value cannot be found. It displays ______ error value in the cell.

Which of the following is not a date function? ____

Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal._________________________

When you copy a formula that contains an absolute reference to a new location,the reference ____.

=IF(G22="x",SUM(H22:J22), " ")with display ______ if G22 is not equal to "x".

By default,AutoFill copies only the content not the formatting of the original range to the selected range._______________

TODAY is an example of a(n)____________________ function.

Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item,which Excel uses to determine the input value needed to reach that goal.She can use ______.

Absolute references are marked with a ____.

To display the current date and time,which is updated each time the workbook is reopened, use the TODAY function._______________

A logical function is a function that works with values that are either ____.

Functions are organized in the Function Library group on the FORMULAS tab._______________

The ____ function returns the maximum value in the range.

Using AutoFill,what would be the extended series of the initial entry Jan? ___

____________________ is a set of rules which specifies how a function should be written.

Which of the following is not a comparison operator? ____

Lookup tables can be constructed for exact match or approximate match lookups._______________

An error value indicates that some part of a function is preventing Excel from returning a calculated value.________________

In the formula =INT(AVERAGE(A1:A100)),which would occur first? ____

If the VLOOKUP function cannot find the lookup value,the _________ error value is displayed in the cell.

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