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.

__________________ are a great source of data about your customers. They contain data about a business exchange, such as the sale of goods. They are standardized and occur repeatedly.    What one-word term fits best in the blank above?

Excel Task 1 Go to the “Customers” sheet of the exam file. Perform a multilevel sort, first by State (A-Z) and then by Date of Last Visit (newest to oldest).   Question: Which customer is on row 6 of the spreadsheet? 

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 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.

This term refers to the combination of  Operating System + Applications + Settings  that is created once by IT, saved to disk and then repeatedly deployed onto new PCs, redeployed PCs, etc.

Excel Task 1 Go to the “Customers” sheet of the exam file. Perform a multilevel sort, first by State (A-Z) and then by Date of First Visit (newest to oldest).   Question: Which customer is on row 4 of the spreadsheet? 

Social media research can help a manager determine what an organization’s customers are interested in.

You have a group of employees who are “Task-Oriented Workers.”  They perform a standard set of tasks each and every day. They require only modest computing power to do those tasks.   Which of the solutions below will meet the requirements at the lowest TCO?   (Please consider both Direct and Indirect costs)    

Having a good social media policy will give employees freedom in using social media by defining the content areas they should avoid and precautions they should take.