Question 1

The file extension for Adobe's file format that preserves exactly the look and feel of a document is ________.

Accepted Answer

The answer of The file extension for Adobe's file format...

Question 2

A cell reference that changes when copied is known as a(n)________ cell reference.

Accepted Answer

The answer of A cell reference that changes when copied...

Question 3

An unchanging value such as 3.14 for Pi can also be called a(n)________.

Accepted Answer

The answer of An unchanging value such as 3.14 for...

Question 4

All formulas begin with the ________ sign.

Accepted Answer

The answer of All formulas begin with the ________ sign....

Question 5

If cell J6 contains 14 and cell J7 contains 6, the ________()function would return 10 if applied to that range.

Accepted Answer

The answer of If cell J6 contains 14 and cell...

Question 6

The ________()function is essentially the same as dividing the sum of a range of cells by the count of those cells.

Accepted Answer

The answer of The ________()function is essentially the same as...

Question 7

A(n)________ allows users to perform basic mathematical calculations.

Accepted Answer

The answer of A(n)________ allows users to perform basic mathematical...

Question 8

The largest value in a range can be found using the ________()function.

Accepted Answer

The answer of The largest value in a range can...

Question 9

The plus sign (+)and the minus sign (-)are examples of ________ used in formulas.

Accepted Answer

The answer of The plus sign (+)and the minus sign...

Question 10

The inclusion of an explicit value in a formula is known as ________.

Accepted Answer

The answer of The inclusion of an explicit value in...

Question 11

________ allows the specification of rules that apply formatting to a cell as determined by the rule outcome.

Accepted Answer

The answer of ________ allows the specification of rules that...

Question 12

The rule that determines the order that Excel processes calculations in a formula is known as the ________.

Accepted Answer

The answer of The rule that determines the order that...

Question 13

The function that allows users to determine how many numerical values exist in a range is the ________()function.

Accepted Answer

The answer of The function that allows users to determine...

Question 14

A(n)________ is a value that may potentially change over time and is stored in a cell and referenced in a formula.

Accepted Answer

The answer of A(n)________ is a value that may potentially...

Quiz 5: Excel

The file extension for Adobe's file format that preserves exactly the look and feel of a document is ________.