1.) A student creates data for trees in an orchard. He enters headings in cells A1, B1, C1, D1, and E1 as Tree, Height, Age, Yield, and Height respectively. He mentions the criteria ="=Mango", >10, ="Orange" and <15 in cells a2, b2, a3 and e2 respectively. a4 to a10 with heading "type of trees" cell contain data for the type trees, b4 b10 "height" height c4 c10 "age" age trees d4 d10 "yield" their annual yield. he can use formula: =DCOUNTA(A5:D10, "yield", a1:e2) count rows containing mango column a>10 and <15.

True or False

2.) How can one filter a PivotTable using a report filter?

a. Right-click a cell in the pivot table, and click Pivot Table Options, then set the 'Display Fields in Report Filter Area' to 'Down, Then Over' On the Layout & Format tab.

b. Click the Report Filter's drop-down arrow, then click on an item to select an item in the list and click OK.

c. Click on the drop down arrow for a Report Filter in the pivot table and Click (All).

d. Right-click a cell in the pivot table, and click Pivot Table Options, then set the 'Display Fields in Report Filter Area' to Over, Then Down' On the Layout & Format tab.

3.) If Power View is enabled, one can create a new Power View report page by clicking Insert tab > Power View button.

True or False

4.) In which of these boxes will you list all the possible fields that can be included in your formula in a PivotTable?

a. Formula text box

b. Name text box

c. Calculated Field dialog box

d. Fields lists box

5.) Marcos wants to refresh the data in a Pivot table manually. He clicks on the PivotTable to show the PivotTable Tools on the ribbon. Which combination of keys should he press next to complete the procedure?

a. Alt +F5

b. Shift +Tab

c. Ctrl + K

d. Alt + F9

6.) To illustrate different data levels using small graphics representing values, which of the following can you use?

a. icon sets

b. color scales

c. data bars

d. Highlight Cells Rules