Question 1

When constructing a formula,Excel's default reference type is relative cell referencing.

Accepted Answer

A) True 
 B)False  True

Question 2

Given the following information:
 
What is the result of =C1/A7?

Accepted Answer

A) #VALUE! 
B) #REF! 
C) #N/A 
D) #DIV/0! 
A) #VALUE! 
B) #REF! 
C) #N/A 
D) #DIV/0! D

Question 3

What is the error message when you attempt to use a cell that has been deleted as a function argument?

Accepted Answer

A) #NPV? 
B) #NAME? 
C) #REF! 
D) #N/A 
A) #NPV? 
B) #NAME? 
C) #REF! 
D) #N/A C

Question 4

To modify a named range,you select its name in the Name Box,then click Name Manager in the ________.

Accepted Answer

A) Defined Names group on the HOME tab 
B) Edit Names group on the HOME tab 
C) Defined Names group on the FORMULAS tab 
D) Edit group on the FORMULAS tab 
A) Defined Names group on the HOME tab 
B) Edit Names group on the HOME tab 
C) Defined Names group on the FORMULAS tab 
D) Edit group on the FORMULAS tab

Question 5

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 6

The result of =RIGHT("Texas",2)is ________.

Accepted Answer

The answer of The result of =RIGHT("Texas",2)is ________....

Question 7

When cell D4 containing the formula =$A4-B$5 is copied to cell E2,the formula in cell E2 is ________.

Accepted Answer

A) =$A4-B$5 
B) =B4-C5 
C) =$A2-C$5 
D) =$A2-B$3 
A) =$A4-B$5 
B) =B4-C5 
C) =$A2-C$5 
D) =$A2-B$3

Question 8

The result of =LEFT("Washington",4)is Wash.

Accepted Answer

A) True 
 B)False

Question 9

=$B$2 - C5 is an example of mixed cell referencing.

Accepted Answer

A) True 
 B)False

Question 10

If you wanted to determine how many cells in a range are not empty,you would use the ________ function.

Accepted Answer

A) COUNT 
B) COUNTA 
C) NOTEMPTY 
D) HASVALUE 
A) COUNT 
B) COUNTA 
C) NOTEMPTY 
D) HASVALUE

Question 11

Given the following information:
   
The result of =OR( A4>B4,C1>B3,B3=A5)is ________.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: COUNTA
AVERAGE
COUNT
MEDIAN
MODE.SNGL

Accepted Answer

The Answer of Returns the mean of a set of is...

Question 13

An absolute cell reference is denoted by a(n)________.

Accepted Answer

A) dollar sign ($) 
B) asterisk (*) 
C) number sign (#) 
D) at sign (@) 
A) dollar sign ($) 
B) asterisk (*) 
C) number sign (#) 
D) at sign (@)

Question 14

When cell D3 containing the formula =$B$5^$C$6 is copied to cell G7,the formula in cell G7 is ________.

Accepted Answer

The answer of When cell D3 containing the formula =$B$5^$C$6...

Question 15

Function arguments are enclosed in a pair of ________.

Accepted Answer

A) braces { } 
B) parentheses ( ) 
C) brackets [ ] 
D) quotes " " 
A) braces { } 
B) parentheses ( ) 
C) brackets [ ] 
D) quotes " "

Question 16

The ________ function returns the number of workdays between to dates.

Accepted Answer

A) NETWORKDAYS 
B) WORKINGDAYS 
C) DAYS 
D) WEEKNUM 
A) NETWORKDAYS 
B) WORKINGDAYS 
C) DAYS 
D) WEEKNUM

Question 17

Match between columns
                        Premises: Name Manager
Mixed cell reference
Named range
Syntax
Flash Fill

Accepted Answer

The Answer of Recognizes patterns as you type and automatically is...

Question 18

The result of =FIND("is","Mississippi",3)is ________.

Accepted Answer

A) 2 
B) 4 
C) 5 
D) 6 
A) 2 
B) 4 
C) 5 
D) 6

Question 19

The result of =PROPER("KANSAS")is ________.

Accepted Answer

The answer of The result of =PROPER("KANSAS")is ________....

Question 20

________ indicates that an error occurred when using the DATEDIF function

Accepted Answer

The answer of ________ indicates that an error occurred when...

When constructing a formula,Excel's default reference type is relative cell referencing.

Given the following information: What is the result of =C1/A7?

What is the error message when you attempt to use a cell that has been deleted as a function argument?

To modify a named range,you select its name in the Name Box,then click Name Manager in the ________.

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

The result of =RIGHT("Texas",2)is ________.

When cell D4 containing the formula =$A4-B$5 is copied to cell E2,the formula in cell E2 is ________.

The result of =LEFT("Washington",4)is Wash.

=$B$2 - C5 is an example of mixed cell referencing.

If you wanted to determine how many cells in a range are not empty,you would use the ________ function.

Given the following information: The result of =OR( A4>B4,C1>B3,B3=A5)is ________.

An absolute cell reference is denoted by a(n)________.

When cell D3 containing the formula =$B$5^$C$6 is copied to cell G7,the formula in cell G7 is ________.

Function arguments are enclosed in a pair of ________.

The ________ function returns the number of workdays between to dates.

The result of =FIND("is","Mississippi",3)is ________.

The result of =PROPER("KANSAS")is ________.

________ indicates that an error occurred when using the DATEDIF function

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 3: Cell References, named Ranges, and Functions

When constructing a formula,Excel's default reference type is relative cell referencing.

Given the following information: What is the result of =C1/A7?

What is the error message when you attempt to use a cell that has been deleted as a function argument?

To modify a named range,you select its name in the Name Box,then click Name Manager in the ________.

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

The result of =RIGHT("Texas",2)is ________.

When cell D4 containing the formula =$A4-B$5 is copied to cell E2,the formula in cell E2 is ________.

The result of =LEFT("Washington",4)is Wash.

=$B$2 - C5 is an example of mixed cell referencing.

If you wanted to determine how many cells in a range are not empty,you would use the ________ function.

Given the following information: The result of =OR( A4>B4,C1>B3,B3=A5)is ________.

An absolute cell reference is denoted by a(n)________.

When cell D3 containing the formula =$B$5^$C$6 is copied to cell G7,the formula in cell G7 is ________.

Function arguments are enclosed in a pair of ________.

The ________ function returns the number of workdays between to dates.

The result of =FIND("is","Mississippi",3)is ________.

The result of =PROPER("KANSAS")is ________.

________ indicates that an error occurred when using the DATEDIF function

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters