Question 1

Excel's TIME function returns the number of minutes in the range 1 to 60.

Accepted Answer

A) True 
 B)False

Question 2

The result of =CONCATENATE("12","34")is ________.

Accepted Answer

A)  45 
B)  1234 
C)  22 
D)  12,34 
A)  45 
B)  1234 
C)  22 
D)  12,34

Question 3

There are how many different types of cell references?

Accepted Answer

A)  Two 
B)  Three 
C)  Four 
D)  Five 
A)  Two 
B)  Three 
C)  Four 
D)  Five

Question 4

The TRIM function returns text from which any leading,trailing,or extra spaces between words have been removed.

Accepted Answer

A) True 
 B)False

Question 5

Excel's MAXIMUM function returns the largest number from a set of numbers.

Accepted Answer

A) True 
 B)False

Question 6

The ________ logical function returns true only if all of its arguments are true.

Accepted Answer

The answer of The ________ logical function returns true only...

Question 7

A name of a range CANNOT contain any spaces.

Accepted Answer

A) True 
 B)False

Question 8

The ________ function rounds down any decimal values associated with a number to the nearest
whole integer.

Accepted Answer

The answer of The ________ function rounds down any decimal...

Question 9

Semantics is the structure and order of the function and the arguments used by Excel to perform a calculation.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is an alternative to using a space when naming a range?

Accepted Answer

A)  Use a hyphen 
B)  Use an equal sign 
C)  Capitalize the first letter of each word 
D)  Use an underscore 
A)  Use a hyphen 
B)  Use an equal sign 
C)  Capitalize the first letter of each word 
D)  Use an underscore

Question 11

Which of the following is NOT a unit value option for the DATEDIF function?

Accepted Answer

A)  H 
B)  M 
C)  D 
D)  Y 
A)  H 
B)  M 
C)  D 
D)  Y

Question 12

Excel's DAY function returns the day of the month.

Accepted Answer

A) True 
 B)False

Question 13

When cell A3 containing the formula =$A$5+$B$6 is copied to cell G7,the formula in cell G7 is =$G$9+$H$10.

Accepted Answer

A) True 
 B)False

Question 14

When cell B2 containing the formula =A4*B6 is copied to cell C1,the formula in cell C1 is ________.

Accepted Answer

A)  =A4*C5 
B)  =A4*B6 
C)  =B3*C5 
D)  =B3*C6 
A)  =A4*C5 
B)  =A4*B6 
C)  =B3*C5 
D)  =B3*C6

Question 15

A(n)________ is a named calculation which Excel uses to calculate the output based on the provided input.

Accepted Answer

The answer of A(n)________ is a named calculation which Excel...

Question 16

Which of the following functions returns the number in the middle of a set of numbers?

Accepted Answer

A)  COUNT 
B)  MEAN 
C)  MEDIAN 
D)  COUNTA 
A)  COUNT 
B)  MEAN 
C)  MEDIAN 
D)  COUNTA

Question 17

To display the Create Names from Selection dialog box,you click Create From Selection in the ________ tab.

Accepted Answer

A)  Defined Names group on the Formulas 
B)  Edit Names group on the Formulas 
C)  Defined Names group on the Home 
D)  Edit Names group on the Home 
A)  Defined Names group on the Formulas 
B)  Edit Names group on the Formulas 
C)  Defined Names group on the Home 
D)  Edit Names group on the Home

Question 18

Names for ranges CANNOT begin with a(n)________.

Accepted Answer

A)  letter 
B)  number 
C)  underscore (_) 
D)  backslash (\) 
A)  letter 
B)  number 
C)  underscore (_) 
D)  backslash (\)

Question 19

Match between columns
                        Premises: Date & Time
Cube
Engineering
Information
Compatibility

Accepted Answer

The Answer of Works with serial date and time values is...

Question 20

The result of =LEN("54")is 9.

Accepted Answer

A) True 
 B)False

Excel's TIME function returns the number of minutes in the range 1 to 60.

The result of =CONCATENATE("12","34")is ________.

There are how many different types of cell references?

The TRIM function returns text from which any leading,trailing,or extra spaces between words have been removed.

Excel's MAXIMUM function returns the largest number from a set of numbers.

The ________ logical function returns true only if all of its arguments are true.

A name of a range CANNOT contain any spaces.

The ________ function rounds down any decimal values associated with a number to the nearest whole integer.

Semantics is the structure and order of the function and the arguments used by Excel to perform a calculation.

Which of the following is an alternative to using a space when naming a range?

Which of the following is NOT a unit value option for the DATEDIF function?

Excel's DAY function returns the day of the month.

When cell A3 containing the formula =$A$5+$B$6 is copied to cell G7,the formula in cell G7 is =$G$9+$H$10.

When cell B2 containing the formula =A4*B6 is copied to cell C1,the formula in cell C1 is ________.

A(n)________ is a named calculation which Excel uses to calculate the output based on the provided input.

Which of the following functions returns the number in the middle of a set of numbers?

To display the Create Names from Selection dialog box,you click Create From Selection in the ________ tab.

Names for ranges CANNOT begin with a(n)________.

The result of =LEN("54")is 9.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 9: Cell References, Named Ranges, and Functions

Excel's TIME function returns the number of minutes in the range 1 to 60.

The result of =CONCATENATE("12","34")is ________.

There are how many different types of cell references?

The TRIM function returns text from which any leading,trailing,or extra spaces between words have been removed.

Excel's MAXIMUM function returns the largest number from a set of numbers.

The ________ logical function returns true only if all of its arguments are true.

A name of a range CANNOT contain any spaces.

The ________ function rounds down any decimal values associated with a number to the nearest whole integer.

Semantics is the structure and order of the function and the arguments used by Excel to perform a calculation.

Which of the following is an alternative to using a space when naming a range?

Which of the following is NOT a unit value option for the DATEDIF function?

Excel's DAY function returns the day of the month.

When cell A3 containing the formula =$A$5+$B$6 is copied to cell G7,the formula in cell G7 is =$G$9+$H$10.

When cell B2 containing the formula =A4*B6 is copied to cell C1,the formula in cell C1 is ________.

A(n)________ is a named calculation which Excel uses to calculate the output based on the provided input.

Which of the following functions returns the number in the middle of a set of numbers?

To display the Create Names from Selection dialog box,you click Create From Selection in the ________ tab.

Names for ranges CANNOT begin with a(n)________.

The result of =LEN("54")is 9.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters