Excel - Flashcardizz

Front

What is one of the most powerful features in Excel for calculating numerical information? Options: Charts, Formulas, Tables, Graphs

Back

Formulas

Front

Which operator is used in Excel for multiplication?

Back

Asterisk (*)

Front

What must all formulas in Excel begin with?

Back

Equals sign (=)

Front

Which operator is used in Excel for exponents?

Back

Caret (^)

Front

What is a cell reference in Excel?

Back

Using cell addresses to create a formula

Front

What happens when you change the values in referenced cells in Excel?

Back

The formula automatically recalculates

Front

In the example provided, what does cell A3 do? Options: Multiplies the values of A1 and A2, Subtracts the value of A2 from A1, Adds the values of A1 and A2, Divides the value of A1 by A2

Back

Adds the values of A1 and A2

Front

What can be combined with cell references to create formulas in Excel?

Back

Mathematical operators

Front

What is the formula to add the values of cells A1 and A2?

Back

=A1+A2

Front

Which formula would you use to find the square of the value in cell R5? Options: =R5*2, =R5^2, =R5+R5, =R5/2

Back

=R5^2