Question: NO PIVOT TABLES, ONLY FORMULAS. Create a new worksheet called R 0 1 _ DASHBOARD and create a dashboard based on the SALES table that

NO PIVOT TABLES, ONLY FORMULAS. Create a new worksheet called

01_

DASHBOARD

and create a dashboard based on the SALES table that resembles the template shown in Appendix A

(

image on the right

),

with each city in the dataset represented. As shown in Appendix A

,

the dashboard will show the monthly sales for a given city and month based

on the year specified in the top left portion of the dashboard. The year must be a dropdown that

allows the user to select any year in the data set, and the sales amounts must dynamically recalculate when year is selected. All amounts must be formatted with commas and no decimal places.

NO PIVOT TABLES, ONLY FORMULAS. Create a new worksheet called R01_DASHBOARD

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

WITHOUT A PIVOT TABLE. ONLY USING FORMULAS Create a new worksheet called R01_DASHBOARD and create a dashboard based on the SALES table that resembles the template shown in Appendix A, with each city...

REQUIREMENT 1 :VISUALIZING AND ASSESSING VOLUMES Background IF offers several direct routes between cities across Canada, with each route identified by their origin ( starting ) and destination (...

Background IF offers several direct routes between cities across Canada, with each route identified by their origin ( starting ) and destination ( ending ) cities. While some airlines offer multi -...

In the " R 0 1 _ SOURCE" worksheet, convert the range of data to an Excel table renamed as "PAX". Create a new worksheet called " R 0 1 _ DASHBOARD" and create a dashboard based on the PAX table that...

Maverick Motors Inc. Project Data:MMI data.xlsx Role and Situation: You are a newly hired associate at a data analysis consulting company engaged by MMI to help them perform a basic analysis of their...

Project Deliverable # 2 Week 9 1 . Create a copy of your Deliverable # 1 submission to use as a starting point for Deliverable # 2 . 2 . Create a new worksheet called Dashboard to display summary...

Tasks: Using the data in the Monthly App Downloads worksheet, create a new worksheet called App Downloads Report with the following four charts (All your charts should be formatted, labelled and...

It's an excel question that should be calculated and done in excel QUESTION 3: DIGITAL FIRST FINANCIAL Situation: Digital First Industries (DFI) is a provider of software solutions that help...

DO IN EXCEL Tasks: Using the data in the Monthly_App_Downloads worksheet, create a new worksheet called App_Downloads_Report with the following four charts (All your charts should be formatted,...

Gensource Company provided the following information from its accounting records for 2021: Estimated production 60,000 labor hours Actual production 56,000 labor hours Estimated overhead $1,800,000...

A water vessel is tied to the car roof by using rubber cords as shown in the figure. The original length of the cord is 40 inches. Determine the average normal strain in the cord if the cord is...

True or False? Under the Choice and Consent component of the AICPA/CICA framework, it is the organization's responsibility to decide whether the individuals have to be informed of the consequences of...

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.