Analyzing Data

Question 1

Where would you find the Create Table Dialog Box?

Revolt · Accepted Answer

Insert tab, Tables command group

Question 2

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”

Question 3

ClipboardAlignmentNumber✔ Conditional Formatting

Revolt · Accepted Answer

✔ Conditional Formatting

Question 4

✔ New RuleManage RuleClear 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

Where would you find the Create Table Dialog Box?

Revolt · Accepted Answer

Insert tab, Tables command group

Question 8

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”

Analyzing Data Answers

More from this Course

TRY EDGENUITY HACKS