STD VIII - Computers | Super Survey Maker

###### in MS Excel means:

You have entered a number wrong

You have misspelled something

The cell is not wide enough

None of the above

State true or false: A formula and a function are the same thing.

True

False

In order to apply exponential value in a formula in MS Excel you would use:

If cells: A1 = 90, A2 = 85, A3 = 80, A4=75, A5 = 75. What will be your formula if you are going to get the average?

Average (A1:A5)

=(A1+A2+A3+A4+A5)/5

Average (A5:A1)

=avg (A5:A2)

To specify an absolute reference in a formula, enter a _____________________ before a column letter or a row number.

Percent sign

Dollar sign

Apostrophe sign

Equal sign

A cell reference with only one dollar sign before either the column or the row is called a(n) ______________________________.

Complete cell reference

Absolute cell reference

Mixed cell reference

Relative cell reference

What does the cell reference A10:A13 mean?

It refers to a range of cells located in column A rows 10 to 13 (inclusive).

It refers to two cells located in column A, namely A10 and A13.

It refers to a range of cells located in column a rows 1 to 10 and 10 to 13 (inclusive).

It refers to a range of cells located in column A rows 1 to 10 and 10 to 13 (inclusive).

Observe the following spreadsheet and answer the following questions: (a) What will be the resultant value in cell C1? (b) Which type of referencing is this ($B$1 and A1)?

384, Relative

320, Absolute

416, Absolute

384, Mixed

State true or false: The Max( ) function is used to find the largest value in a set of values.

True

False

STD VIII - Computers

More Quizzes