Upload your TWBX file   Save your Tableau workbook file as a…

Upload your TWBX file   Save your Tableau workbook file as a TWBX file and then upload it here.   Note: we need a TWBX — “Tableau Packaged Workbook” file — not a plain TWB file.   All of the points you earned earned for Tableau tasks 1-5 will be awarded on this question.   Reminder #1 — partial credit is possible, but only based on the work that’s in the saved TWBX file you upload here.  Reminder #2 — Do not delete, modify, or even open your XLSX or TWBX file after the exam!  This protects your work, just in case there is a tech glitch with the upload of your exam file.   End of Tableau Skills Section   End of Exam.  Congratulations!

In a Relational Database, multiple data tables are linked to…

In a Relational Database, multiple data tables are linked together to reduce the duplication of data, saving space and reducing the potential for error. Select all of the valid relationship types listed below.   Note: don’t guess. Canvas awards points for correct answers, but deletes points for incorrect responses.

Excel Skills Test — General Instructions Download   Exam2-R…

Excel Skills Test — General Instructions Download   Exam2-Restaurant-Spring2021.XLSX and  open it in Excel.  You will be asked to complete a set of tasks using that spreadsheet. Most of your work will be graded manually by the instructional team; you’ll also answer some exam questions about your results. At the end of this section, you will save and upload your Excel file. Important note:  when grading, we do award partial credit, so give every question your best effort, even if you’re not 100% sure what to do. It’s better to submit a formula that is partially correct and returns an error than to return a blank cell. We can’t award any points for a blank cell.

Excel Task 7      (max 9 pts) Go to the “Restaurants” sheet…

Excel Task 7      (max 9 pts) Go to the “Restaurants” sheet of the exam file. Management wants to compare the popularity of its restaurant chains across different states.. Create another pivot table. States on the rows. Columns should be the four restaurant chains Provide an analysis of the average customer visits last year.  Format the results to 1 decimal place, with commas for thousands separators.   Name the pivot table’s sheet as “Pivot-States”   NOTES: This task will be graded manually, based on our evaluation of the XLSX file you submit.