Data Analysis with Excel - Module 6 Practice
In cell F5, enter a formula using the OR function that returns a value of TRUE if either the condition E525000 or the condition D5=3 is met. - answer-Click cell F5 Click Formulas Tab Click insert function Select "Logical" Category in drop down In the Select a function box, click OR In Logical1 enter : E525000 In Logical2 enter: D5=3 Click Ok Format range A4:E19 as a table with headers using Blue, Table Style Medium 2 (Medium section, row 1, option 2) - answer-Click Format as a Table Select (Medium section, row 1, option 2) Assign the name Clients to the Table - answer-Click Cell A4 Select Design in the Table Tools Tab In the properties group, click the table name text box, and type clients and press ENTER Apply Green, Table Style Medium 7 - answer- Convert the Client Contacts table in range A5:I18 to a range - answer-Click cell A5 In the Tools group, click the Convert to Range button Add a total row to the Sales by Branch table and display totals, using the Sum function, for columns B and D - answer-Click Cell A8 Click Design in the Table tools tab Click Total Row in Table Style Options Click cell B9 Click Arrow and then click Sum Add a new record to the end of the client summary table entering the following data: type 115 in cell A19, type Tekvision in cell B19, type 6 in cell C19, and type CA in cell D19. Press ENTER when done - answer- Use the Region slicer to filter the PivotTable to display only data for the Southern and Western regions - answer-
Document information
- Uploaded on
- June 26, 2024
- Number of pages
- 3
- Written in
- 2023/2024
- Type
- Other
- Person
- Unknown