Excel Formulas and Functions

It spans a cell or a group of cells adjacent to each other on a worksheet.

• Reference

• Sequence

• Range

• Collection

To get the total of adjacent cells which key combination is used.

• Alt + =

• Shift + =

• Ctrl + =

• Space + =

What are pre-designed formulas in Excel

• Cell reference

• Range

• Relative reference

• Functions

This function returns the remainder after a number is divided by the divisor

• POWER( )

• AVERAGE( )

• MOD( )

• INT( )

Which of the given cell reference can be included in relative reference?

• $D6

• B3

• A$3

• B$3

Microsoft Excel follows the __________ rule to evaluate the mathematical expression.

• BODMAS

• BIDMAS

• BEDMAS

• DMAS

Formulas in Excel must begin with _________________ symbol.

• !

• @

• #

• =

_______________ are inputs to functions, which accept values as number or text.

• Arguments

• Parameters

• Cell reference

• Range

Which function will display the current date in the selected cell?

• DATE( )

• DAY( )

• CURRENT DATE( )

• TODAY( )

To use the Sheet reference, which address is appropriate out of the following options.

• A4 ! Sheet1

• Sheet1 ! A4

• Sheet1 $ A4

• A4 # Sheet1