Computer cyp

What are functions?

• Functions are predefined formulas in Excel

• Functions are continuous cells

• Functions are used to format a text

• Functions are values in a formula.

Absolute reference is used when

• We want the cell address to be different.

• We do not want the cell address to be changed in a formula.

• We want either row or column to be fixed.

The cell address in a formula is also known as ______.

The #VALUE! error occurs when

• A number is divided by 0.

• The formula contains an invalid argument.

• The formula is used incorrectly.

• The column does not have enough space to accommodate the value.

The most common error in Excel is

• #NAME?

• #VALUE!

• #Div/0!

• ####

What are constants?

• The numerical values that may or may not change.

• The numerical values that do not change.

• Cell address is also called as constants.

• Symbols that specify the operation to be performed.

How many rows are there in Excel?

• 10,48,876

• 10,48,576

• 16,384

• 16,956

What are these in a formula?

• Constant

• Mathematical Operators

• Range

• Function

F2 shortcut key is used to

• Enter or modify a formula

• Copy a formula

• Get total of adjacent cells

To use absolute reference we put ___ sign begore the column and row numbers.

• @

• $

• &

• #