Question 1

The result of =UPPER("Anthony")is ________.

Accepted Answer

The answer of The result of =UPPER("Anthony")is ________....

Question 2

When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.

Accepted Answer

A) =G7/H8 
B) =$G$7/$H$8 
C) =B5/C6 
D) =$B$5/$C$6 
A) =G7/H8 
B) =$G$7/$H$8 
C) =B5/C6 
D) =$B$5/$C$6

Question 3

The result of =DATEDIF("12/21/2014","11/02/2016","Y")is 2.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is NOT a financial function?

Accepted Answer

A) PMT 
B) PPMT 
C) NPV 
D) APR 
A) PMT 
B) PPMT 
C) NPV 
D) APR

Question 5

=B$4 + $D5 is an example of ________ cell referencing.

Accepted Answer

The answer of =B$4 + $D5 is an example of...

Question 6

Match between columns
                        Premises: RAND
ABS
ROUNDDOWN
INT
ROUND

Accepted Answer

The Answer of Returns the absolute value of a number is...

Question 7

Which of the following is NOT a comparison operator symbol?

Accepted Answer

A) = 
B) ≠ 
C) = 
A) = 
B) ≠ 
C) =

Question 8

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

Accepted Answer

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

Question 9

A named range CANNOT contain any spaces.

Accepted Answer

A) True 
 B)False

Question 10

The ________ Excel function category works with URL and XML connections.

Accepted Answer

The answer of The ________ Excel function category works with...

Question 11

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 12

The logical comparison operator for not equal is ≠.

Accepted Answer

A) True 
 B)False

Question 13

The comparison operator for does not equal is ________.

Accepted Answer

The answer of The comparison operator for does not equal...

Question 14

A named range CANNOT begin with a(n)________.

Accepted Answer

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

Question 15

Which of the following is NOT a common error message?

Accepted Answer

A) #NPV? 
B) #NAME? 
C) #REF! 
D) #VALUE! 
A) #NPV? 
B) #NAME? 
C) #REF! 
D) #VALUE!

Question 16

The Text Excel function category provides data about cell content within a worksheet.

Accepted Answer

A) True 
 B)False

Question 17

When cell D3 containing the formula =C4*B4 is copied to cell F2,the formula in cell F2 is =C4*B4.

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: 11ea4e48_4fb4_27e4_84bd_1f3969f8c751_TB3001_11
11ea4e48_4fb4_27e3_84bd_e9999206e25d_TB3001_11
11ea4e48_4fb4_27e2_84bd_e1974babe67a_TB3001_11
11ea4e48_4fb4_4ef6_84bd_7b1de866eed4_TB3001_11
11ea4e48_4fb4_4ef5_84bd_237a7c0b17e8_TB3001_11

Accepted Answer

The Answer of AutoFill and Error Message and Insert Function is...

Question 19

Excel's WEEKDAY function returns a number from 1-7 or 0-6.

Accepted Answer

A) True 
 B)False

Question 20

The result of =MID("Tallahassee",6,3)is ________.

Accepted Answer

A) Tall 
B) lahass 
C) has 
D) hassee 
A) Tall 
B) lahass 
C) has 
D) hassee

The result of =UPPER("Anthony")is ________.

When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.

The result of =DATEDIF("12/21/2014","11/02/2016","Y")is 2.

Which of the following is NOT a financial function?

=B$4 + $D5 is an example of ________ cell referencing.

Which of the following is NOT a comparison operator symbol?

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

A named range CANNOT contain any spaces.

The ________ Excel function category works with URL and XML connections.

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

The logical comparison operator for not equal is ≠.

The comparison operator for does not equal is ________.

A named range CANNOT begin with a(n)________.

Which of the following is NOT a common error message?

The Text Excel function category provides data about cell content within a worksheet.

When cell D3 containing the formula =C4B4 is copied to cell F2,the formula in cell F2 is =C4B4.

Excel's WEEKDAY function returns a number from 1-7 or 0-6.

The result of =MID("Tallahassee",6,3)is ________.

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

The result of =UPPER("Anthony")is ________.

When cell A4 containing the formula =$B$5/$C$6 is copied to cell F6,the formula in cell F6 is ________.

The result of =DATEDIF("12/21/2014","11/02/2016","Y")is 2.

Which of the following is NOT a financial function?

=B$4 + $D5 is an example of ________ cell referencing.

Which of the following is NOT a comparison operator symbol?

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

A named range CANNOT contain any spaces.

The ________ Excel function category works with URL and XML connections.

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

The logical comparison operator for not equal is ≠.

The comparison operator for does not equal is ________.

A named range CANNOT begin with a(n)________.

Which of the following is NOT a common error message?

The Text Excel function category provides data about cell content within a worksheet.

When cell D3 containing the formula =C4*B4 is copied to cell F2,the formula in cell F2 is =C4*B4.

Excel's WEEKDAY function returns a number from 1-7 or 0-6.

The result of =MID("Tallahassee",6,3)is ________.

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

When cell D3 containing the formula =C4B4 is copied to cell F2,the formula in cell F2 is =C4B4.