Font size
WorksheetsQuiz on MS Excel (Part 3) [G6]
Total questions: 10
Worksheet time: 32mins
The symbol for greater than or equal to in writing a formula is _____.
=<
>=
<<
>>
In writing a formula, one should start with a/an _____ sign , followed by the function, and then the cell range which are contained in parentheses.
dollar ( $ )
equal ( = )
plus ( + )
minus ( - )
Relational Operators are used to compare values in the specified cells.
Which is the relational operator is used for not equal in MS Excel?
=
≠
< >
<=
Type the formula for this statement:
If the value in cell A1 is not equal to 100 , display ON on this cell. If not, then
display OFF.
(a)
What does this formula mean in text?
=IF(F4>=5,"YES","NO")
If the value in cell F4 is not equal to 5, display "YES". If not, then display "NO".
If the value in cell F4 is equal to 5, display "YES". If not, then display "NO".
If the value in cell F4 is less than or equal to 5, display "YES". If not, then display "NO".
If the value in cell F4 is greater than or equal to 5, display "YES". If not, then display "NO".
Which icon means the AutoSum command?
To use AutoSum, do the following steps:
1. Select the cell where you wanted the sum to appear.
2. From the Home tab, ______ group, click the
AutoSum button.
Alignment
Number
Editing
Clipboard
Functions are ready made formulas that perform a series of operations on a specified range of values.
Which icon will you click to see and use different formulas?
You can enter function through the following methods, EXCEPT _____.
Using the Insert Function feature
Using the AutoComplete feature
Using the formula bar
Using the AutoRecover feature
TRUE or FALSE
Computations in Excel are done using formulas, which are composed of functions.
(a)
