Question $6$: What CANNOT be the Value if True argument in an IF function?

Answer:

A$.$ A formula

B$.$ The cell in which the formula is entered

C$.$ A cell reference

D$.$ Text

Question $7$: Which formula contains a nested function?

Answer:

A$.=$IF$($A$4>2,43,$ IF$($B$7=2,86,0))$

B$.=$SUM$($B$6$:B$14)-$SUM$($C$6$:C$14)$

C$.=$AVERAGE$($A$6$:C$6,$ B$12)$

D$.=$MAX$($A$5$:A$30)+$MIN$($B$1$:B$28)$

$8-$Which cell shown here displays an absolute cell reference?

Answer:

A$.$ F$1$

B$.$ $F$$1$

C$.$ $F$1$

D$.$ F$$1$

Question $9$: What would be the result in cell F$8$ if the formula were copied to cell F$8?$

Answer:

A$.=$E$$4+12$

B$.=$D$$5+12$

C$.=$E$$5+12$

D$.=$C$$3+12$

Question $10$: What would be the result in cell A$2$ if the formula were copied to cell A$2?$

Answer:

A$.=$$C$20+$$D$20$

B$.=$$C$19+$$D$19$

C$.=$$C$20+$$D$19$

D$.=$$C$19+$$D$20$

$11$

Question $11$: Match each reference or formula to its best description.

$=$$A$$6------------------------------------------$ABSOLUTE CELL REFERENCES

$=$$B$7--------------------------------------------$ Mixed cell reference

$=$SUM$($AVERAGE$($A$1$:$!6),$ B$7)------------$ Nested function

$=$C$2-----------------------------------------------$RELATIVE FUNCTION

Question $12$: Which argument is optional for the HLOOKUP function?

Answer:

A$.$ Lookup value

B$.$ Table array

C$.$ Column index number

D$.$ Range lookup

Question $13$: What displays when the range lookup in a lookup function is False and an exact match is not located in the table array?

Answer:

A$.0$

B$.$#DIV$/0!$

C$.$#N$/$A$$

D$.$ A blank space

Question $14$: What is a valid range lookup entry for a VLOOKUP function?

Answer:

A$.2$

B$.$ A$5$

C$.6*$B$4$

D$.$ False

Question $15$: Which of these best describes the purpose of a lookup function?

Answer:

A$.$ To combine multiple entries in other cells of the worksheet

B$.$ To retrieve a piece of data from a table

C$.$ To modify a formula in an adjacent cell

D$.$ To correct a previously incomplete formula in the worksheet

Question $16$: What is NOT allowed in a defined name?

Answer:

A$.$ Text

B$.$ Number

C$.$ Underscore

D$.$ Space

Question $17$: What is NOT a standard approach to improving worksheet readability?

Answer:

A$.$ Using a single underline below data for which a calculation is being performed

B$.$ Using a double underline below data representing the final figure in a column

C$.$ Using highlighting, underlining, and different font types, sizes, and colors

D$.$ Using formatting such as bold or italic to set headers apart from other content