NEW
Font size
WorksheetsExcel
Total questions: 15
Worksheet time: 8mins
The predefined commands that perform some particular operations quickly are known as __________
Sorting
Function
Filtering
Formatting
We can apply filters to only _______ range on a worksheet at a time.
3
2
1
0
Every functions have two parts: function name and ___________
operators
equal sign
cell address
arguments
To see all the rows again after applying Filter, click ____________command.
delete
clear
back
None of these
$A5 is a/an ________ reference.
Relative
Absolute
Mixed
All of the above
Every cell has a name called its ______
address
range
value
function
_______ is used to filter data on specific conditions.
Filter
Range Filter
Custom Filter
Value Filter
Which one is a statistical function?
POWER
PRODUCT
QUOTIENT
SUM
_________ function displays the current date.
=DATE( )
=DAY( )
=TODAY( )
=TODATE( )
What will be the output of =LEN("COMPUTER SCIENCE") ?
15
16
17
18
If the value of A1 is 17, then what will be the output of the given statement.
=IF(A1>18, "PASS" , "FAIL" )
"PASS"
"TRUE"
"FAIL"
"FALSE"
Sort & Filter group is found in _______ tab on the ribbon.
Home
Insert
View
Data
All function must always begin with a/an _________ sign.
$
&
=
:
AVERAGE,MAX and MIN are the _______ functions.
Logical
Statistical
Text
Math
In ___________ referencing both column part and row part are not fixed.
Relative
Absolute
Mixed
None of these
