7/14/2023 0 Comments Named range dailysales![]() OPEN Backstage view, and click Options 3. LAUNCH Excel if it is not already running OPEN 03 My Invoice Solution from the Lesson 3 folder, if necessary. 2 Using Office Backstage Chapter 3 - Mastery assessment Project 3-5: Manage a Custom ribbon In order for your client to use and maintain the invoice you downloaded in the previous exercise, he has requested that you customize several tabs on the ribbon to make the worksheet easier to manage and edit. SAVE the workbook as 02 Home Sales Flash Fill Solution. Add a label in A3 that says 2014 to-Date. ![]() Type item# and then use Auto Fill to create numbers starting with 1 that are sequential through 14. This feature only works when you type the first letter of the second name. NOTE: If this does not work as intended, delete “Kim” and any other name you have entered and start again. Finally, hit enter to fill out the names Repeat for last names. To do this – enter the first of the first names (ie Kim), then hit enter You will move to the next row - enter only the first letter of the second agent – note that the column will be filled with all the first names in faded out font. Use Flash Fill to create a list of first names in column B and a list of last names in column C. Insert two columns to the right of the “Agent” columns, and type in “First Name” as the label for column B and “Last Name” for column C 3. Use the workbook from the previous project 2. Project 2-6: Using Flash Fill Fabrikam’sĭirector has asked you to redo the workbook you created in Project 2-5 with separate columns for first name and last name and sequentially numbered sales. LEAVE this workbook open for the next project. Click into cell A3 and type First Quarter 2014. SAVE it with the name 02 Home Sales Q1 Solution. Open the 02 Home Sales Q1.xlsx workbook 2. 19 Working with MS Excel Chapter 2 - Mastery assessment Project 2-5: Creating a Home Sales Workbook CEO, Richard Carey has asked you to keep track of the Home sales for the Fabrikam staff. 18 Project 10-6: Creating COUNTIF, AVERAGEIF, and LOOKUP Formulas. 18 Project 10-5: Creating Conditional Logic Formulas. 18 Project 10-4: Create COUNTIF and AVERAGEIF Formulas. 17 Project 10-3: Using a Formula to Format text. 17 Project 10-2: Creating SUMIF and SUMIFs Formulas to Conditionally summarize Data. 17 Project 10-1: Separating text into Columns – SFA Grades. ![]() 15 Projectĩ-2: Subtotalling - Fundraising revenue summary. 13 Project 8-6: Bakery sales error correction. 11 Project 8-4: Pet store Daily sales tally, Part 2. 10 Project 8-3: Pet store Daily sales tally, Part 1. 9 Project 8-2: Photo store accessory sales tracker. 9 Project 8-1: Music store annual sales sheet. 8 Project 5-6: Complete the analysis sheet in the Budget Workbook. 8 Project 5-5: Build Formulas to Track merchandise stock Levels. 4 Project 4-5: Name a range and Use the range in a Formula. 4 Project 4-3: Link to Data in other Worksheets within a Workbook. 2 Project 2-5: Creating a Home Sales Workbook. Training Microsoft Excel 2013 Practice exercises Table of Contents Working with MS Excel.
0 Comments
Leave a Reply. |