Analyzing Data

Question 1

What is the name of the table tools contextual tab that appears once you insert a table?

Revolt · Accepted Answer

Design

Question 2

Select the correct navigational path to mark all teachers who have achieved “excellent” on their evaluations a red background.

Revolt · Accepted Answer

Click the tab on the ribbon and look in the gallery.: Home; Click the tab on the ribbon and look in the gallery.: Conditional Formatting; Select .: New Rule; Select and fill in the formula for the IF statement and formatting. Click OK.: “Use a formula”

Question 3

Clipboard Alignment Number ✔ Conditional Formatting

Revolt · Accepted Answer

✔ Conditional Formatting

Question 4

✔ New RuleManage Rule Clear Rule

Revolt · Accepted Answer

✔ New Rule

Question 5

“Format only top or bottom” “Format all cells”✔ “Use a formula”

Revolt · Accepted Answer

✔ “Use a formula”

Question 6

Which components exist in the contextual tab for tables called Design? Check all that apply.Table StylesExport Table DataPropertiesToolsBanded RowsExternal Table DataTable Style Options

Revolt · Accepted Answer

Table Styles; Properties; Tools; External Table Data; Table Style Options

Question 7

What are some areas to fill out in the New Formatting Rule dialog box? Check all that apply.rule typefunction nameconditioncell referenceargumentformat

Revolt · Accepted Answer

rule type; condition; format

Question 8

Select the correct navigational path to mark all teachers who have achieved “excellent” on their evaluations a red background.

Revolt · Accepted Answer

✔ Home; Click the tab on the ribbon and look in the gallery.: Home; Click the tab on the ribbon and look in the gallery.: Conditional Formatting; Select .: New Rule; Select and fill in the formula for the IF statement and formatting. Click OK.: “Use a formula”

Analyzing Data Answers

More from this Course

TRY EDGENUITY HACKS