Exam 7: Excel

Which of the following statements describes tables where the EmployeeID field in the Employees table can be associated with many CustomerID fields in the Customers table?

Your worksheet contains a price in cell A5, and many formulas refer to that price.How would you refer to that price in the formulas?

Before you can unprotect a worksheet, you must enter the correct password.

To combine the results of four separate scenarios, you create an Answer report.

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

Flash Fill enters text based on patterns it finds in the data.

Sheila wants to extract the hour from the time, 12:00:56, in cell A1.Which formula can she use to do this?

After you delete a worksheet column, _____.

When you insert a table, it is organized into rows of data called _____.

You open the Visual Basic Editor by clicking the Macros button in the Code group on the Developer tab.

Excel provides a tool for tracing formula operators.

Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?

Joyce wants to calculate the monthly payment for a $16,000 car loan at 5.5% interest over 5 years.She should create a formula using the NPER function.

A(n) highlighting scale is a formatting scheme that uses colors to convey relative values of data, such as using red for cells with high values and green for cells with low values.

A field named Difference appears in the PivotTable Fields pane and in the PivotTable, where it displays the difference between the Year 1 and Year 2 fields.What type of field is Difference?

If you insert an ActiveX text box in a worksheet, you must link it to a cell on the same worksheet.

When you create custom theme fonts, you select which of the following types of fonts? Select all the options that apply.

Tomoko lists monthly sales for each region in a worksheet.Before adding subtotals for each region, she needs to sort the values in the Region column.

When you set a Stop error alert style in a cell, users have the option of entering data or cancelling.

Niki wants to insert Line sparklines in selected cells.To do so, she can click the Line button in the Sparklines group on the Insert tab.