Deck 11: Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Question 1

Which of the terms below would be most closely associated with the following formula:
=100*$B$7

A) named range
B) absolute reference
C) relative reference
D) mixed reference

Answer 1

A

Question 2

Which of the terms below would be most closely associated with the following formula:
=Q$4/3

A) mixed reference
B) absolute reference
C) relative reference
D) named range

Answer 2

A

Question 3

Which of the following is NOT a valid cell reference?

A) =T$11
B) =G6
C) =$B$K
D) =$X14

Answer 3

C

Question 4

Which of the following is a valid name for a range?

A) 2011Sales
B) S2011
C) Sales_2011
D) All are valid names for named ranges.

Question 5

Which of the following formulas contains a hard-coded value?

A) =SUM(J1:J3)
B) =$F$4*$F$5
C) =AVERAGE(Sales)
D) =F1*0.07

Question 6

If a cell in a formula should remain in the same row when copied,but change the column,use a(n)________.

A) relative reference
B) named range
C) absolute reference
D) mixed reference

Question 7

Which of the following statements about cell references is FALSE?

A) Cell references can NOT refer to a range of cells.
B) Referencing cells improves efficiency should cell data change over time.
C) Cell references can refer to a single cell.
D) None of the above statements is false.

Question 8

Which of the following is the argument in the following formula:
=SUM(J2:J4)

A) =
B) J2:J4
C) SUM
D) None of the above are arguments.

Question 9

In order to display only the current date,use the ________ function.

A) DAY
B) DATE
C) NOW
D) TODAY

Question 10

Which of the terms below would be most closely associated with the following formula:
=SUM(Quantities)

A) mixed reference
B) named range
C) relative reference
D) absolute reference

Question 11

If a cell included in a formula needs to remain unchanged when the formula is copied,use a(n)________.

A) relative reference
B) mixed reference
C) named range
D) absolute reference

Question 12

The structure and order of a function and its arguments is also known as the function's ________.

A) reference
B) syntax
C) range
D) pseudocode

Question 13

If a cell in a formula should remain in the same column when copied,but change the row,use a(n)________.

A) named range
B) relative reference
C) absolute reference
D) mixed reference

Question 14

A(n)________ allows a cell's row and column to change when copied.

A) relative reference
B) named range
C) mixed reference
D) absolute reference

Question 15

Which of the following is NOT a type of cell reference?

A) relative
B) mixed
C) absolute
D) formula

Question 16

Which of the following is TRUE about hard-coded values?

A) In the formula =J5*12 the 12 is a hard-coded value.
B) A formula such as =P1*Q2 contains a hard-coded value.
C) Hard-coding is recommended when you have a value that may change.
D) Hard-coding makes it easier to update data and adapt to change.

Question 17

In order to simplify a formula,users can replace cell ranges such as J2:J5 with a(n)________.

A) relative reference
B) absolute reference
C) named range
D) mixed reference

Question 18

Which of the following is the function in the following formula:
=AVERAGE(E2:E5)

A) =
B) E2:E5
C) AVERAGE
D) None of the above are functions.

Question 19

Which of the terms below would be most closely associated with the following formula:
=J1*H4

A) relative reference
B) named range
C) absolute reference
D) mixed reference

Question 20

Which of the terms below would be most closely associated with the following formula:
=$J1+44

A) mixed reference
B) absolute reference
C) named range
D) relative reference

Question 21

The Show Formulas view is when cells display the formulas instead of the output.

Question 22

To perform a comparison and make a decision based on that decision,use a ________ function.

A) logical
B) math & trig
C) statistical
D) financial

Question 23

IF,AND,and OR are examples of ________ functions.

A) financial
B) statistical
C) logical
D) math & trig

Question 24

All cell references MUST include a $ within the reference.

Question 25

Cell references improve efficiency and flexibility,and allow easier updates to a spreadsheet.

Question 26

The cells associated with a named range can be modified after they have been created.

Question 27

SUM,MIN,and MAX are examples of Excel functions.

Question 28

The formula below contains a named range.
=SUM($J$5:J$7)

Question 29

Finding the maximum,minimum,and average values for a range of cells are all part of the category of functions called ________ functions.

A) logical
B) statistical
C) math & trig
D) financial

Question 30

Arguments are required for all functions.

Question 31

The formula below contains a hard-coded value.
=B3*8.85

Question 32

Hard-coding values,like sales tax in a formula,is generally preferable to using cell references.

Question 33

Named ranges make formulas easier to read.

Question 34

A cell reference allows users to refer to a cell in a formula.

Question 35

If you type a formula into a cell and instead of results you see a formula,it is because you have likely switched the Show Formulas feature on.

Question 36

Absolute values of a number,rounding,and summing are all part of the category of functions called ________ functions.

A) logical
B) statistical
C) engineering
D) math & trig

Question 37

Names for named ranges must start with a number.

Question 38

A named range can be a single cell.

Question 39

To switch to the Show Formulas view,hold the Ctrl key and press the $ key.

Question 40

Loan payment calculations and net present value calculations are formulas found in the ________ category of functions.

A) logical
B) statistical
C) financial
D) math & trig

Question 41

Inputs given to a function are known as ________.

Question 42

Two different pseudocodes can produce the same results.

Question 43

All arguments MUST be separated by commas.

Question 44

A formula which states =B1*$B5 contains two ________ references.

Question 45

Excel includes statistical functions such as SUM.

Question 46

The PMT function requires users to enter the total number of payments that will be made for the loan,or the ________.

Question 47

The structure and order of the function,and the arguments needed for Excel to run a function,are known as the ________ of the function.

Question 48

A(n)________ is a named calculation where Excel calculates the output based on the input provided.

Question 49

Some functions have optional arguments that can remain blank.

Question 50

The PMT function requires users to enter present value for an investment,known as the ________ field within the function.

Question 51

Syntax rules state that functions start with an equal sign.

Question 52

Users can create pseudocode to understand the logic of a problem before actually creating a formula.

Question 53

Pseudocode is a complete formula,such as:
=IF(H1>15,A5*5,A5*7)

Question 54

The PMT function's first argument is the periodic interest ________ of the loan.

Question 55

A(n)________ allows users to refer to a particular cell or range of cells within a formula or function.

Question 56

In this formula: =SUM(Sales),SUM is an example of a(n)________.

Question 57

Including actual data in a formula is known as ________ the values.

Question 58

A rough draft of a formula or code is also known as ________.

Question 59

Functions such as TODAY,which has no arguments,are written as: =TODAY

Question 60

A set of cells that have been given a label that can then be used within a formula or function is a(n)________ range.

Question 61

There are two methods for creating functions: typing in the function and through the Functions ________ dialog box.

Question 62

The Statistical Function Category is used when working with ________ calculations.