Microsoft Excel Calculation

What is the basic formula to add two cells in Excel?

• A1-B1

• A1*B1

• =A1+B1

• A1/B1

What function is used to find the average of a range of cells in Excel?

• AVERAGE

• SUM

• MAX

• COUNT

What is the operator used for multiplication in Excel?

• M

• x

• *

• multiply

Explain the difference between relative and absolute cell references in Excel.

• Relative cell references do not change when copied to another cell, while absolute cell references change.

• Relative cell references change when copied to another cell, while absolute cell references change randomly.

• Relative cell references change when copied to another cell, while absolute cell references change in the opposite direction.

• Relative cell references change when copied to another cell, while absolute cell references do not change.

How can conditional formatting be used to highlight cells with values greater than 100?

• Apply conditional formatting with the rule 'Less Than' and set the value to '100'.

• Apply conditional formatting with the rule 'Greater Than' and set the value to '100'.

• Use the 'Highlight Cells' feature and select 'Greater Than' from the dropdown menu.

• Manually change the font color of cells with values greater than 100.

What is the formula to subtract the value in cell B1 from the value in cell A1?

• A1/B1

• A1+B1

• A1*B1

• =A1-B1

Name a function in Excel that can be used to count the number of cells in a range that meet a certain condition.

• SUMIF

• COUNTIF

• AVERAGEIF

• RANGEIF

What is the purpose of using the SUM function in Excel?

• To find the average of the values in a range of cells.

• To multiply the values in a range of cells.

• To add up the values in a range of cells.

• To sort the values in a range of cells.

Explain the difference between the COUNT and COUNTA functions in Excel.

• The COUNT function counts all non-blank cells in a range, including text and empty cells

• The COUNTA function counts only numeric values in a range

• The COUNT function counts only numeric values in a range, while the COUNTA function counts all non-blank cells in a range, including text and empty cells.

• The COUNT function counts only text values in a range

How can the IF function be used to apply conditional logic in Excel?

• By creating a new worksheet

• By testing a condition and returning one value if the condition is true and another value if the condition is false.

• By formatting cells in a specific way

• By using the SUM function