Exam 2: Excel-2019

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

A histogram chart displays each category as a rectangle and each subcategory nested within a rectangle.

You must display the Visual Basic tab on the ribbon to insert form controls into a worksheet.

You can use the Links dialog box to manually update a link in an Excel workbook.

In a PivotTable, the Row Labels appear above the PivotTable values.

When you copy and paste a formula to a new location, the formula's relative references do not change.

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.

When you lock a cell, it is hidden in the worksheet.

You can insert two types of controls in a worksheet: VBA controls and ActiveX controls.

If you link Excel data to a Word document and then decide not to maintain the connection between the files, you can break the link

Where calculated columns summarize data in each row of a table, a constraint creates an overall summary.

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Aaron has a column chart that displays data in the range B3:D7. When he clicks the chart, then drags the sizing handle around the data to include row 8, he is adding a data table to the chart.

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

Which of the following conditional formatting types can you apply to use red fill to indicate cells that have higher values and green fill to indicate lower values?

When you protect the structure of a workbook, you have the option of increasing the protection by requiring a password to open the workbook.

Excel Solver is a(n) _____, which means it must be installed before you can use it for the first time.

You can copy and paste only the cell validation by copying a cell with data validation, right-clicking the destination cell, clicking Paste Special, then clicking the Rules button in the Paste Special dialog box.

You can import text data into Excel and save the imported data in Excel format.

A workbook template has which of the following file extensions?