Excel

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