What is an example of conditional formatting?
What is the name of the table tools contextual tab that appears once you insert a table?
Which items are examples of components likely found in tables? Check all that apply.header rowcalculated columnheader columnstotal rowheader row drop-down arrowtotal row drop-down arrow
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?
What are some areas to fill out in the New Formatting Rule dialog box? Check all that apply.rule typefunction namecell referenceargumentformatting
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.above averageorbelow averagebottom 10 itemstop 10 itemsand
Did you find these answers helpful?