Test your understanding

A _______ is a predefined formula that performs calculations using specific values in a particular order.

• operator

• function

• argument

• function name

The______function checks whether a certain condition is true or false.  

• COUNTIF()

• RANK()

• COUNT()

• IF()

In order to work correctly, a function must be written a specific way, which is called the______

• syntax

• argument

• parts of a function

• cell ranges

The function =AVERAGE(B1:B9) would calculate the average of the values in the cell range B1:B9. This function contains only _____argument.

• four

• three

• two

• one

Krishna is using =$D6:E$6 formula for computing something in an excel worksheet. This formula is an example of ------------------- cell referencing.

• relative

• absolute

• mixed

• comparative

The basic syntax for a function is the equals sign (=), the function name, and one or more arguments.

• TRUE

• FALSE

A ________ refers to an intersection of a row and column in a worksheet, which contains a number, formula or text.

The process in which we make changes in the appearance of the cell of the data in the cells of a worksheet according to our requirements is called_________

• number formatting

• cell formatting

• ranges formatting

• cell referencing

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)

• SUM(B3:B9)

• =SUMB3+B9

• =ADD(B3:B9)

 Which formula gets the smallest value of a range of cells?

• MAX

• SMALL

• SUM

• MIN