Group 9 Lesson Set Notes

.docx

School

University of Alabama *

*We aren’t endorsed by this school

Course

102

Subject

Mathematics

Date

Apr 3, 2024

Type

docx

Pages

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