Questions and Answers
What happens when you copy a formula with a relative cell reference down one cell?
The cell reference is adjusted relative to its position in the worksheet
What is the purpose of using an absolute cell reference in a formula?
To ensure the formula always refers to the same cell
How do you make a cell reference absolute in a formula?
By adding a dollar sign
What happens when you copy a formula with an absolute cell reference to a different cell?
Signup and view all the answers
What is a mixed cell reference in a formula?
Signup and view all the answers
How do you create a mixed cell reference in a formula?
Signup and view all the answers
What happens when you copy a formula with a mixed cell reference down one cell?
Signup and view all the answers
Can you use uppercase or lowercase when typing a cell reference in a formula?
Signup and view all the answers
How do you enter a cell reference in a formula?
Signup and view all the answers
What is the result of copying a formula with an absolute cell reference to a different cell?
Signup and view all the answers
Study Notes
Formulas in Excel
- Formulas can be created by typing in a cell or using the mouse pointer to select cells.
- Basic formulas can be created for addition, subtraction, multiplication, and division.
Displaying Formulas
- Formulas can be displayed using the Show Formulas command in the FORMULAS tab, Formula Auditing group.
- When displaying formulas, the results of the formulas are not shown.
Order of Operations
- The order of operations can be controlled using parentheses in formulas.
- Examples of using parentheses to control the order of operations include:
(7 + 8) * (3 / 2).
Creating Formulas
Addition Formula
- A simple addition formula can be created by typing
=B3+B4in a cell. - The formula adds the values in cells B3 and B4 and displays the result.
Subtraction Formula
- A subtraction formula can be created by typing
=B3-B4in a cell. - The formula subtracts the value in cell B4 from the value in cell B3 and displays the result.
Multiplication Formula
- A multiplication formula can be created by typing
=1200*12in a cell. - The formula multiplies the values and displays the result.
Division Formula
- A division formula can be created by typing
=B23/12in a cell. - The formula divides the value in cell B23 by 12 and displays the result.
Using Cell References in Formulas
Relative Cell References
- Relative cell references can be used in formulas.
- When copying a formula that uses a relative cell reference, the reference is adjusted relative to its position in the worksheet.
Absolute Cell References
- Absolute cell references can be used in formulas by typing dollar signs (e.g.
$B$3). - When copying a formula that uses an absolute cell reference, the reference remains the same.
Mixed Cell References
- Mixed cell references can be used in formulas (e.g.
$B3). - When copying a formula that uses a mixed cell reference, the column reference is absolute, but the row reference is relative.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
