Bonus Points. Have you completed the Homework Check exercises for Unit 7 prior to starting this exam?  Please answer truthfully. Points will be taken off for aswering incorrectly.

Bonus Points. Have you completed the Homework Check exercises for Unit 6 prior to starting this exam?  Please answer truthfully. Points will be taken off for aswering incorrectly.

¿Qué papel juega la cobertura mediática en la historia?

Where is the cell causing the error in cell B5 on the summary sheet –what sheet and what cell?                 Sheet: [BLANK-1]                Cell: [BLANK-2]         2. Is B5 on the summary sheet a dependent cell or a precedent cell? [BLANK-3]

What festival is held in New York in 1969?

Enter the function in B3 on the analysis sheet that will find the total Salary for employees in the Austin store. Use a fully qualified table reference formulas using the table on the Employee DB sheet. Paste your function below. EX3_Employee Analysis.xlsx

Create a pivot Chart.  After clicking on a Pivot Chart, how do you turn the display of all buttons off–the Report filter field button, the axis and value field buttons and the expand/collapse field buttons by clicking on one thing? [BLANK-1] Will turning all the buttons off on the chart affect the buttons displayed on the PivotTable? [BLANK-2] Insert a Slicers for the Hotel field, if there are two Pivot Tables created that use the Hotel field. How do you get the slicers to work with both PivotTables? [BLANK-3]

A _______ Circular Reference is when a cell uses its own cell address in its formula.

What auditing tool would you use to find and then take you to all the cells that contain errors? [BLANK-1]

Enter the function that can count all the employees with a last name starting with the letter J. This criteria is not in a cell. [BLANK-1]