Excel Formula Basics

What symbol is used to indicate multiplication in Excel formulas?

• ^

• *

• /

• +

How can you start a formula in Excel?

• Use a dollar sign ($)

• Begin with an equal sign (=)

• Start with a hashtag (#)

• Begin with a plus sign (+)

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

• ADD

• MERGE

• TOTAL

• SUM

What does the formula '=A1+B1' do in Excel?

• It divides the value in cell A1 by B1

• It subtracts the value in cell B1 from A1

• It adds the values in cells A1 and B1 together.

• It multiplies the values in cells A1 and B1

How can you reference a cell in a formula in Excel?

• Use a random number generator to select the cell

• Count the number of cells from the top left corner

• Ask a friend to point out the cell

• Type the cell reference directly into the formula.

What is the result of the formula '=10/2' in Excel?

• 5

• 3

• 2.5

• 7

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

• AVERAGE

• MAX

• MEDIAN

• SUM

What does the formula '=SUM(A1:A5)' do in Excel?

• It calculates the total sum of the values in cells A1 to A5.

• It finds the average of the values in cells A1 to A5

• It multiplies the values in cells A1 to A5

• It calculates the maximum value in cells A1 to A5

How can you apply a formula to multiple cells in Excel?

• Enter formula in all cells individually

• Use the same formula bar for each cell

• Enter formula in one cell, copy, select range, right-click, Paste Special > Formulas

• Enter formula in one cell, select range, right-click, Paste Special > Formulas

What is the purpose of using absolute cell references in Excel formulas?

• Absolute cell references allow for dynamic cell values in Excel formulas

• Absolute cell references are used to change the format of cells in Excel

• The purpose of using absolute cell references in Excel formulas is to keep a specific cell constant when copying the formula to other cells.

• Absolute cell references help in sorting data in Excel