Question 14 to insert a list box form control into a

Question 14

To insert a list box (form control) into a worksheet, click the Developer tab > Controls group > Insert >
Form Controls > Button with an up and a down arrow in two rectangular boxes, placed one below the
other.
Question 15
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?
Question 16
Chastity wants to rename her pivot table from PivotTable1 to ProductData. She clicks the Pivot table
then goes to PivotTable Tools > Analyze, and clicks the X text box in the PivotTable group. She then types
a new name and presses ENTER. What can X be in the procedure?
Question 17
Arlo creates a rectangular shape and inserts the text 'Color Box' in it. Then, he right clicks on the shape
and selects a button to assign a macro to it. Which of the following can his selection be?
Assign Macro…
Size and Properties…
Format Shape…
Set as Default Shape

Question 18
Which of the following properties is used to specify the way the control is attached to the cells below it,
while inserting a command button (ActiveX control) into a worksheet?
Question 19
After drilling down, Esteban wants to drill up to analyze summary data. To do so, he follows the
following steps: 1. Select the item to drill up on in the PivotTable hierarchy you have drilled into. 2. Click
the Quick Explore button that appears in the lower-right corner of the selection. 3. Use the Quick Explore
button to reach the data you want. Which step did he miss while following this procedure?