Excel Formulas (Beginners)

What is the formula to sum a range of cells in Excel?

• =TOTAL(range)

• =SUM(cells)

• =ADD(range)

• =SUM(range)

How do you multiply two cells in Excel using a formula?

• =A1-B1

• =A1+A1

• =SUM(A1,B1)

• =A1*B1

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

• Absolute cell references change based on the formula's position, while relative cell references do not

• Absolute cell references and relative cell references are interchangeable in Excel formulas

• Absolute cell references adjust when copied, while relative cell references remain constant

• Absolute cell references do not change when copied, while relative cell references adjust based on the formula's position.

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

• =SUM(range)

• =AVERAGE(range)

• =MAX(range)

• =MIN(range)

What is the formula to calculate the percentage of a total in Excel?

• (Part*100)/Total

• (Total-Part)/Total

• (Part/Total)*100

• (Total/Part)*100

What is the function to count the number of cells that contain data in Excel?

• COUNTB

• COUNTA

• COUNTC

• COUNTD

Explain the difference between COUNT and COUNTA functions in Excel.

• COUNT function counts only numerical values, while COUNTA function counts all values including text in Excel.

• COUNT function counts all values including text, while COUNTA function counts only numerical values in Excel.

• COUNT function counts cells with errors, while COUNTA function counts cells without errors in Excel.

• COUNT function counts cells without errors, while COUNTA function counts cells with errors in Excel.

What is the correct function to calculate the average of cells A1 to A10 in Excel?

• =SUM(A1:A10)/COUNT(A1:A10)

• =AVERAGE(A1:A10)+SUM(A1:A10)

• =AVERAGE(A1:A10)*COUNT(A1:A10)

• =AVERAGE(A1:A10)

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

• =MAX(range)

• =HIGH(range)

• =LARGEST(range)

• =TOP(range)

How can you round a number to the nearest integer in Excel?

• =ROUND(number)

• =INT(number)

• =ROUNDUP(number)

• =ROUND(number,0)