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]    

To enter an array formula, you press a combination of keys and then Excel will enclose the formula in a set of some characters. Which of the following choices is correct?

How would you enter the criteria to find all males in the Accounting department who are instructors and make a salary of less than 150000? Enter all the field names you would use and put the criteria under them. Enter only the field names that are needed so it is faster to answer the question. Put NA if the field should be left blank.    [BLANK-1] [BLANK-2] [BLANK-3] [BLANK-4] [BLANK-5] [BLANK-6] [BLANK-7] [BLANK-8]    [BLANK-9] [BLANK-10] [BLANK-11] [BLANK-12]    

From the postwar authors we have studied (Williams, Brooks, Walker, Kincaid, Plath, Rich, or Olsen), select one whose work stood out to you. Analyze how their writing both resonates with you personally and represents larger post‑World War II concerns, using at least two specific examples from the period.