Exam 7: Excel

The DAVERAGE function returns the maximum value in a column for cells matching the criteria.

You can use an XML map to import and export PDF data, a format often used for storing and exchanging data.

Before you can track changes in a workbook, what can you do to use the Track changes (legacy) feature?

A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth.To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

You can set a scaling option to resize a worksheet to fit within a single page.

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?

Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?

Where can you display a list of all the macros in the current workbook.

Ricki wants to apply a particular chart style to a PivotChart she has created.Which of these tabs will help her apply it?

To specify an action based on certain conditions, you use an If…Then…Else conditional statement in VBA.

When you change cell contents to italics, you are changing the cell's alignment.

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.

When creating a _____ in Power Pivot, you can combine fields from multiple tables in the data model.

Jeremy created a worksheet with a Departments column and an Expenses column.To average the expense amounts for the Customer Service Department only, he can use the AVERAGE function.

Reggie created a data validation rule for cell B3, which contains a unit price.He wants to use the only the data validation in cell D3.Which of the following should he do?

If a worksheet arranges lookup values in rows rather than columns, which function is best for retrieving data from the lookup table?

To return cell contents to its default font and style, you can use the _____ command.

Which Command Button property is used to internally reference the button?

Which of the following objects contains VBA code that determines its behavior?