Group 9 Lesson Set Notes
docx
keyboard_arrow_up
School
University of Alabama *
*We aren’t endorsed by this school
Course
102
Subject
Mathematics
Date
Apr 3, 2024
Type
docx
Pages
5
Uploaded by AmbassadorMusic4761
Using the Function Arguments Dialog to Enter Functions:
Click formulas tab
Click the Math and Trig button
Click SUM
Type B12:D12 in the Number 1 box and press enter
Click OK in the dialog
Click Insert Function button
Expand the or select a category list
Select Most Recently Used
Click OK
Click OK
Using Formula to AutoComplete to Enter Functions:
The animation shows =su
being typed to begin a formula and Formula AutoComplete is displayed.
Double click SUM
Type B12:D12 and press enter to compelte formula
Calculating Averages:
Click the Formulas tab
Click the More Functions button
Mouse over statistical, click Average
Type B12:D12 in the Number 1 box and press enter
Click OK
Finding Minimum and Maximum Values:
Click formulas tab
Click More Functions button
Mouse over statistical, click MAX
Type B12:D12 in the Number 1 box
Click OK
Click More functions button
Mouse over statistical, click MIN
Type what you need in the Number 1 box
Click OK
Using Date and Time Functions:
Click formulas tab
Click the Date and Time button
Click Today
Click OK
Click Date and Time button
Click Now
Click OK
Creating Formulas Using Counting Functions:
Click Formulas tab
Click More Functions button
Mouse is over statistical, click Count
Type A7:A20 in Value 1 box
Click OK
Click More Functions button
Mouse is over statistical, click Counta
Type B7:B20 in Value 1 box
Click OK
Click More Functions button
Mouse is over statistical, click Countblank
Type E7:E20 in Value 1 box
Click OK
Formatting Text Using Functions:
Formulas tab
Click Text button in Function Library group
Select Proper
Type D2 in the text box Click OK
Click Text button in Function Library group
Select Upper
Type F2 Click OK
Click Text button in Function Library group
Select Lower
Counting the Number of Characters Using LEN:
Click formulas tab
Click the text button
Select LEN
In the text box, type H2
Click OK
Using CONCAT to Combine Text:
Click formulas tab
Click the text button
Select CONCAT
Type B2 in text 1 box
Type " " in the Text 2 box
Type C2 in text 3 box
Click OK
Using TEXTJOIN to Combine Text:
Click formulas tab
Click the Text button
Select TEXTJOIN
Type " " in the Delimiter box
Type TRUE in the Ignore_empty box
Type A2:C2 in text 1 box
Click OK
Creating Formulas referencing Data from Other Worksheets:
Type an equals sign in cell B3
Click expenses worksheets tab
Click cell you need
Press enter
Type equals sign in cell B4
Click income worksheet tab
Select cell you need
Type - , then press Enter
Click expenses sheet tab
Click cell you need
Press enter
Naming Ranges of Cells:
Type StockValue in the Name box to the left of the formula bar
Click the Formulas tab
Click the create from Selection button in the Defined Names group
The top row check box is checked by default, click OK
Working with Named Ranges:
Double click cell E4
Type =SUM(St to display the formula AutoComplete list
Double click StockValue to enter it into the formula
Press enter
Updating Named Ranges with the Name Manager:
Click the Formulas tab
Click the Name Manager button
Edit the cell range to ='Salon Inventory'!$A$5:$F$20 in the refers to box
Click the checkmark to the left of the refers to box
Click the Close button
Editing and Deleting Names with the Name Manager:
Click the formulas tab
Click the Name Manager button The first inventory name is selected by default. Click the Edit… button
Type InventoryOnSale in the Name box
Click OK
Click the ReorderTime name
Click the Delete button
Click OK
Click Close
Using the Logical Function IF:
Click formulas tab
Click the Logical buttin in the Function Library group
Select IF
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
In the Logical_test box, enter D5>E5
In the Value if true box, type do not order
In the Value is false box, type order
Click OK
Calculating Loan Payments Using the PMT Function:
Click formulas tab
Click the Financial button
Select PMT
Type B4/12 in the Rate box
Type B5 in the Nper box
Enter -B3 in the Pv box
Click OK
Finding Data Using the VLOOKUP Function:
Click formula tab
Click the Lookup & Reference button
Select VLOOKUP
Type B1 in the lookup_value box
Type Inventory in the Table array box
Type 2 in the Col_num box
Type False in the Range lookup box
Click OK
Finding Data Using the XLOOKUP Function:
Click formulas tab
Click Lookup & Reference button
Select XLOOKUP
Type E1 in lookup value box
Type Item in Lookup array box
Type QuantityInStock in return array box
Type "Item Not Found" in the Id not found box
Click OK
Checking Formulas for Errors:
Click Cell B8
Click the Smart Tag (triangle with !)
Click Update Formula to Include Cells
Click the Formulas tab
Click the error Checking button
Click the Update Formula to Include Cells button
Click Copy Formula from left button
Click OK
Finding Errors Using Trace Precedents and Trace Dependents:
Click formulas tab
Click the Trace Dependents button
Click Cell B8
Click the Trave Precedents button
Click the Remove Arrows button
Displaying and Printing Formulas:
Click formulas tab
Click the Show formulas button
Click File tab
Click Print
Click the Back arrow to exit backstage view
Click the Show Formulas button