STD VIII - Computers

Name
ITS ID
###### 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:
^
*
@
#
State true or false: The formula: =((A2+B5)*5% is valid.
True
False
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
{"name":"STD VIII - Computers", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Name, Class, ###### in MS Excel means:","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
Powered by: Quiz Maker