Question 1

If a cell containing the formula =$B$14 is not copy and pasted,but moved four columns over and four rows down,what would the resultant cell reference become?

Accepted Answer

A) =F18 
B) =$F$18 
C) =B14 
D) =$B$14 
A) =F18 
B) =$F$18 
C) =B14 
D) =$B$14 D

Question 2

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell,what the cell reference become in the new cell.

Accepted Answer

A) $A5 
B) $A7 
C) $C5 
D) $C7 
A) $A5 
B) $A7 
C) $C5 
D) $C7 B

Question 3

It is very important to sort the first column in a table lookup array in descending order.

Accepted Answer

A) True 
 B)False  False

Question 4

In a lookup table,the number of the column which contains the return values is called the ________.

Accepted Answer

The answer of In a lookup table,the number of the...

Question 5

Where does Excel automatically display statistics like count,average,and sum when a range of values is selected?

Accepted Answer

A) Formula bar 
B) Name box 
C) Status bar 
D) Statistics bar 
A) Formula bar 
B) Name box 
C) Status bar 
D) Statistics bar

Question 6

Match between columns
                        Premises: 1
62.33
31.50
199
6

Accepted Answer

The Answer of COUNT and MAX and AVERAGE and MEDIAN is...

Question 7

The ________ function finds the largest value in a range.

Accepted Answer

The answer of The ________ function finds the largest value...

Question 8

What describes a function's purpose?

Accepted Answer

A) Arguments 
B) Name 
C) Category 
D) Variables 
A) Arguments 
B) Name 
C) Category 
D) Variables

Question 9

If a cell containing =B$14 is copy and pasted three columns over and two rows down,what would the resultant cell reference become?

Accepted Answer

A) E$14 
B) $E$14 
C) B16 
D) B$16 
A) E$14 
B) $E$14 
C) B16 
D) B$16

Question 10

What error will you get if you type a function name incorrectly?

Accepted Answer

A) #FUNCTION? 
B) #VALUE? 
C) #ERROR? 
D) #NAME? 
A) #FUNCTION? 
B) #VALUE? 
C) #ERROR? 
D) #NAME?

Question 11

Match between columns
                        Premises: =$A$54
=A54
=$A54
=SUM(A54:B97)
"Ohio"

Accepted Answer

The Answer of Mixed reference and Ensures text entry and is...

Question 12

What type of cell reference should be used when a value remains constant?

Accepted Answer

A) Absolute 
B) Relative 
C) Mixed 
D) Constant 
A) Absolute 
B) Relative 
C) Mixed 
D) Constant

Question 13

The most used logical function is the IF function.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: Function ScreenTip
Quick Analysis
Logical test
Formula AutoComplete
Syntax

Accepted Answer

The Answer of Matches letters as you type and Can is...

Question 15

The MIN and MAX functions can be used with ________ as well as numbers.

Accepted Answer

dates,vari

Question 16

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

Accepted Answer

A) True 
 B)False

Question 17

The default calculation using the PMT function will produce a negative number.

Accepted Answer

A) True 
 B)False

Question 18

What does the AVERAGE function not ignore?

Accepted Answer

A) Text 
B) Empty cells 
C) Dates 
D) Cells with N/A 
A) Text 
B) Empty cells 
C) Dates 
D) Cells with N/A

Question 19

In the PMT function,the PV argument refers to the ________ of the loan.

Accepted Answer

The answer of In the PMT function,the PV argument refers...

Question 20

The test argument in an IF statement must evaluate to either ________.

Accepted Answer

True or Fa

If a cell containing the formula =$B$14 is not copy and pasted,but moved four columns over and four rows down,what would the resultant cell reference become?

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell,what the cell reference become in the new cell.

It is very important to sort the first column in a table lookup array in descending order.

In a lookup table,the number of the column which contains the return values is called the ________.

Where does Excel automatically display statistics like count,average,and sum when a range of values is selected?

The ________ function finds the largest value in a range.

What describes a function's purpose?

If a cell containing =B$14 is copy and pasted three columns over and two rows down,what would the resultant cell reference become?

What error will you get if you type a function name incorrectly?

What type of cell reference should be used when a value remains constant?

The most used logical function is the IF function.

The MIN and MAX functions can be used with ________ as well as numbers.

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

The default calculation using the PMT function will produce a negative number.

What does the AVERAGE function not ignore?

In the PMT function,the PV argument refers to the ________ of the loan.

The test argument in an IF statement must evaluate to either ________.

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters

Exam 2: Formulas and Functions

If a cell containing the formula =$B$14 is not copy and pasted,but moved four columns over and four rows down,what would the resultant cell reference become?

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell,what the cell reference become in the new cell.

It is very important to sort the first column in a table lookup array in descending order.

In a lookup table,the number of the column which contains the return values is called the ________.

Where does Excel automatically display statistics like count,average,and sum when a range of values is selected?

The ________ function finds the largest value in a range.

What describes a function's purpose?

If a cell containing =B$14 is copy and pasted three columns over and two rows down,what would the resultant cell reference become?

What error will you get if you type a function name incorrectly?

What type of cell reference should be used when a value remains constant?

The most used logical function is the IF function.

The MIN and MAX functions can be used with ________ as well as numbers.

If you are looking up exact values in a lookup table then it does not matter how the table is sorted.

The default calculation using the PMT function will produce a negative number.

What does the AVERAGE function not ignore?

In the PMT function,the PV argument refers to the ________ of the loan.

The test argument in an IF statement must evaluate to either ________.

Introduction to Excel

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, styles, and Macros

Office 2016 Common Features

Filters