STD VIII - Computers
###### 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"}
More Quizzes
FB QUIZ 5 June
1585
Pronomes
1475
Discover Your Dosha
11694
2020 ISO Quiz
14712
Storepro Quiz July 2020
1470
Vine Trivia
1587
Banner Aetna Trivia July 2022
15811
Elton John
840
Xcel Knowledge Quiz
15816
Which Jin Ling uncle are you?
843499
How well do you know the candidates?
23120
Which quote that makes me emo inside are you
840