According to the ‘Creating a Simple Dashboard using Excel’ video, what did subject matter experts advise when building dashboards?1 pointBright colors highlight key points.Displaying too much information means your key points can get lost.Use numbers as much as possible to help focus users on your key points.Having as many visualizations as possible can help you clearly define your key points.

According to the ‘Creating a Simple Dashboard using Excel’ video, which of the following should you have already done prior to creating a dashboard? (Select all that apply) 1 pointFormatted the data as a table.Created pivot tables to help analyze data.Created a data analysis findings report.Verified data is clean and error free.

Which one of the following statements best describes the main purpose of a digital dashboard?1 pointTo display all your charts in one location.To provide a static data-findings report of your business data.To display the most important or relevant information in a single place.To analyse different types of data.2.Question 2According to the ‘Creating a Simple Dashboard using Excel’ video, what did subject matter experts advise when building dashboards?1 pointHaving as many visualizations as possible can help you clearly define your key points.Displaying too much information means your key points can get lost.Use numbers as much as possible to help focus users on your key points.Bright colors highlight key points.3.Question 3Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?1 pointSortingFiltersPivot TablesSparklines4.Question 4Which of the following tasks should you perform before creating a dashboard? (Select all that apply)1 pointFormat the data as a table firstRemove blank data rows Format the data as a CSV file firstCreate visualizations

You should try and add as much information and as many visualizations as possible into your dashboard so that it conveys the most amount of information possible. 1 pointTrueFalse

Question 1Which of the following are benefits of dashboards in Excel? (Select all that apply)1 pointDashboards can alert you to trends and patterns.Dashboards can be updated dynamically as source data changes.Dashboards provide a way to monitor the performance of your data applications.Dashboards can offer useful insights into your data.

What are some techniques for creating interactive dashboards in Excel?Review LaterUsing conditional formatting and data validation to make the dashboard more user-friendly.Embedding interactive videos and animations in the dashboard.Adding background music to enhance the interactive experience.Using emojis and GIFs to engage users in the dashboard.