Question 1

Which of the following is not a date function? ____

Accepted Answer

A)  YEAR 
B)  NOW 
C)  AND 
D)  TODAY 
A)  YEAR 
B)  NOW 
C)  AND 
D)  TODAY

Question 2

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

Accepted Answer

A)  uary 
B)  Feb, Mar, Apr 
C)  Kan, Lan, Man, Nan 
D)  Jan1, Jan2, Jan3 
A)  uary 
B)  Feb, Mar, Apr 
C)  Kan, Lan, Man, Nan 
D)  Jan1, Jan2, Jan3

Question 3

An error value begins with a pound sign (#) followed by an error name that indicates the type of error.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The ____ function returns the maximum value in the range.

Accepted Answer

A)  TOP 
B)  FIRST 
C)  MAX 
D)  MOST 
A)  TOP 
B)  FIRST 
C)  MAX 
D)  MOST

Question 6

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1.

Accepted Answer

A) True 
 B)False

Question 7

Excel functions are organized into ____ categories.

Accepted Answer

A)  8 
B)  10 
C)  11 
D)  13 
A)  8 
B)  10 
C)  11 
D)  13

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Case 3-2
Susan is in charge of the inventory reports for her company.  She will need to find specific inventory items as well as project increases in inventory costs.  To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools.
-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.

Accepted Answer

A)  ##### 
B)  #Value 
C)  #N/A 
D)  Value not found 
A)  ##### 
B)  #Value 
C)  #N/A 
D)  Value not found

Question 10

The numbers, text, or cell references used by the function to return a value are called ____.

Accepted Answer

A)  expressions 
B)  arguments 
C)  data 
D)  values 
A)  expressions 
B)  arguments 
C)  data 
D)  values

Question 11

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 12

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

Question 13

The Insert Function button is in the ____ group.

Accepted Answer

A)  Calculation 
B)  Function Library 
C)  Sort & Filter 
D)  Home 
A)  Calculation 
B)  Function Library 
C)  Sort & Filter 
D)  Home

Question 14

____ 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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A)  The average of the values in the range A1:A100 is added to the integer. 
B)  The average of the integer value is calculated. 
C)  The average of the values in the range A1:A100 is calculated. 
D)  The integer portion of the value is extracted. 
A)  The average of the values in the range A1:A100 is added to the integer. 
B)  The average of the integer value is calculated. 
C)  The average of the values in the range A1:A100 is calculated. 
D)  The integer portion of the value is extracted.

Question 19

After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.

Accepted Answer

A)  Go 
B)  Select 
C)  Insert 
D)  Next 
A)  Go 
B)  Select 
C)  Insert 
D)  Next

Question 20

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

Which of the following is not a date function? ____

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

An error value begins with a pound sign (#) followed by an error name that indicates the type of error.

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

The ____ function returns the maximum value in the range.

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1.

Excel functions are organized into ____ categories.

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

The numbers, text, or cell references used by the function to return a value are called ____.

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

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

The Insert Function button is in the ____ group.

____ 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.

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

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

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

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

After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.

The fill handle copies ____.

Word Module Access Module Creating a Database

Access Module : Building a Database and Defining Table Relationships

Access Module Maintaining and Querying a Database

Word Module Creating and Editing a Document

Word Module 2: Navigating and Formatting a Document

Excel Module Getting Started With Excel

Excel Module Formatting Workbook Text and Data

Powerpoint Module Creating a Presentation

Managing Your Files

Communicating With Microsoft Outlook Angel

Productivity Apps for School and Work

Filters

Exam 8: Excel Module Performing Calculations With Formulas and Functions

Which of the following is not a date function? ____

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

An error value begins with a pound sign (#) followed by an error name that indicates the type of error.

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

The ____ function returns the maximum value in the range.

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1.

Excel functions are organized into ____ categories.

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

The numbers, text, or cell references used by the function to return a value are called ____.

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

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

The Insert Function button is in the ____ group.

____ 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.

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

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

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

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

After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.

The fill handle copies ____.

Word Module Access Module Creating a Database

Access Module : Building a Database and Defining Table Relationships

Access Module Maintaining and Querying a Database

Word Module Creating and Editing a Document

Word Module 2: Navigating and Formatting a Document

Excel Module Getting Started With Excel

Excel Module Formatting Workbook Text and Data

Powerpoint Module Creating a Presentation

Managing Your Files

Communicating With Microsoft Outlook Angel

Productivity Apps for School and Work

Filters