The Department summary table should look up the department abbreviation and return all of the data listed. It needs to be filled out. To begin, next to the cell listed "Department", use a function to search the staff table data (not including the row of headings and the total row) and return the department name based on the abbreviation above. The formula will be copied, so make sure it always references the abbreviation. Copy the formula down to complete the Department summary table, and edit the copied formulas to return the values from the headings listed in the left-hand column. In the appropriate cell below the staff table, use a function to display the current date without displaying the time. The averages will not be needed, so delete column O. The date for the next update isn't certain, so hide row 18. Switch to the Budget worksheet, which contains the department budgets from 2021 to 2025. There's already a pie chart showing 2021 budget information, and Carmelo wants another one to compare.Create a 2-D pie chart based on the data in the Department and 2025 columns. Move the chart so that it covers the range H4:O22. Use the third chart style, and use 2025 Budget by Department as the chart title. The pie chart for 2021 now needs to be changed. Format this chart the same way as the 2025 chart. The Departmental Budget Comparison 2021-2025 combo chart needs to be updated as well. Change the minimum bounds of the right vertical axis to 40,000,000, and then add axis titles to the chart. Use Department Budgets as the left vertical title, use Total Budget as the right vertical title, and remove the horizontal axis title. Apply a shape fill to the chart using the Blue, Accent 5, Lighter 80% fill color. The Hiring worksheet won't be needed, so delete it from the workbook.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

The Department summary table should look up the department abbreviation and return all of the data listed. It needs to be filled out.
To begin, next to the cell listed "Department", use a function to search the staff table data (not including the row of headings and the total row) and return the department name based on the abbreviation above. The formula will be copied, so make sure it always references the abbreviation.
Copy the formula down to complete the Department summary table, and edit the copied formulas to return the values from the headings listed in the left-hand column.
In the appropriate cell below the staff table, use a function to display the current date without displaying the time.
The averages will not be needed, so delete column O.
The date for the next update isn't certain, so hide row 18.
Switch to the Budget worksheet, which contains the department budgets from 2021 to 2025. There's already a pie chart showing 2021 budget information, and Carmelo wants another one to compare.
Create a 2-D pie chart based on the data in the Department and 2025 columns. Move the chart so that it covers the range H4:O22. Use the third chart style, and use 2025 Budget by Department as the chart title.
The pie chart for 2021 now needs to be changed. Format this chart the same way as the 2025 chart.
The Departmental Budget Comparison 2021-2025 combo chart needs to be updated as well.
1. Change the minimum bounds of the right vertical axis to 40,000,000, and then add axis titles to the chart.
2. Use Department Budgets as the left vertical title, use Total Budget as the right vertical title, and remove the horizontal axis title.
3. Apply a shape fill to the chart using the Blue, Accent 5, Lighter 80% fill color.
The Hiring worksheet won't be needed, so delete it from the workbook.

AI-Generated Solution

AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.

Unlock instant AI solutions

Tap the button
to generate a solution

Click the button to generate
a solution

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions