Analyzing Data Answers

8 verified answers2 views
1
Free Preview

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

A
the most important rule that marks it as lowest precedence
B
the most important rule that marks it as highest precedence
C
the least important rule that marks it as highest precedence
D
the least important rule that marks it as lowest precedence
4

Where would you find the Create Table Dialog Box?

A
Data tab, Get & Transform Data group
B
Data tab, Outline Command group
C
Insert tab, Charts gallery
D
Insert tab, Tables command group
6

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.

A
Press the F5 + T keys.
B
On the Insert tab, in the Tables group, click Table.
C
On the Data tab, in the Arrangements group, click Form Table.
D
On the Page Layout tab, in the Header & Footer group, click Format as Table.
E
On the Home tab, in the Styles group, select a table style from Format as Table gallery.
8

What is an example of conditional formatting?

A
Cells in a range with values under 10 have a red background.
B
Cells in a row have a yellow background.
C
Cells in a column have green text.
D
Cells in a worksheet have borders around their edges.

Did you find these answers helpful?