Study Guide for Excel 2016 Session 4.docx - Study Guide for Excel 2016 Session 4 Basic Formulas Which is a true statement concerning basic formulas in

# Study Guide for Excel 2016 Session 4.docx - Study Guide for...

• Test Prep
• 8
• 100% (3) 3 out of 3 people found this document helpful

This preview shows page 1 - 3 out of 8 pages.

Study Guide for Excel 2016 Session 4 Basic Formulas Which is a true statement concerning basic formulas in Excel 2016? Choices: A - Formulas will change automatically if the user utilizes the Formula Bar B - Formulas will not change automatically if the user utilizes the Formula Bar C - The user needs to alter the formula when entering new data into applicable cells D - The user does not need to alter the formula when entering new data into applicable cells References: Calculations with Formulas and Functions Use Basic Formulas and Functions Multiplication With the preselected cell, multiply cell B7 with cell K1. Use the mouse to select the appropriate cells. Steps: Step 1: Click in the interface to begin the demo Step 2: Type: = Step 3: Click the B7 cell Step 4: Type: * Step 5: Click the K1 cell Step 6: Press the Enter key References: Calculations with Formulas and Functions Use Basic Formulas and Functions Absolute Reference Which is an example of an absolute reference in Excel? Choices: A - K\$1 B - \$K1 C - \$K\$1 D - *K\$1
References: Calculations with Formulas and Functions Use Absolute and Mixed References Formulas Across Worksheets In the preselected cell, add the B9 cell from the OC Sales worksheet to the B9 cell from the LA Sales worksheet. Use the mouse to select the cells. Steps: Step 1: Click in the interface to begin the demo Step 2: Type: = Step 3: Click the OC Sales tab Step 4: Click the B9 cell Step 5: Type: + Step 6: Click the LA Sales tab Step 7: Click the B9 cell Step 8: Press the Enter key References: Calculations with Formulas and Functions Using Formulas Across Worksheets The Sum Function Use the Excel 2016 ribbon to apply the Sum function from the Formulas tab to the preselected cell.