Analyzing Data Answers

Which items are examples of components likely found in tables? Check all that apply.header rowbanded rowsheader columnstotal rowheader row drop-down arrowtotal row drop-down arrow

Where would you find the Create Table Dialog Box?

Which tools are found in the Quick Analysis feature? Check all that apply.TablePivotTableSUMCOUNTMoreRow Evaluation

After selecting a cell in the data range, what are some ways to create a table? Check all that apply.Press the F5 + T keys.On the Insert tab, in the Tables group, click Table.On the Data tab, in the Arrangements group, click Form Table.On the Page Layout tab, in the Header & Footer group, click Format as Table.On the Home tab, in the Styles group, select a table style from Format as Table gallery.

Jeremiah needs to see data in two different table views from two regions without creating two tables. Which two features would he use to create this?

Which rule should be on the top line when creating conditional formatting?

Which terms are words or phrases found in setting precedence in conditional formatting rules? Check all that apply.aboveonly cells that containbelowequal or aboveequal or belowand

What is an example of conditional formatting?