Exam 2: Excel-2019

To ungroup a range of cells in a row in a worksheet, select the rows or columns you wish to ungroup, then click the Group command in the Outline group on the Data tab. In the Group dialog box, select Rows and click OK .

To move a chart to another location on the same worksheet, drag it to the location you want.

You can import a text file that uses a divider such as a space, comma, or semicolon between columns of data.

Helga wants to reset page breaks in a worksheet to display only automatic page breaks. Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

After creating a macro, how can you make it easier to run for other workbook users?

Nathan has recorded a few macros in a workbook and now wants to run one of them. Which dialog box should he open to select a macro and then run it?

When you insert a picture in a worksheet, the Insert Picture dialog box displays only files that contain graphics file extension, such as _____.

When would you explode a slice in a pie chart?

To edit placeholder text, such as in a chart title, you click the object and then type the new text.

Where can you adjust page layout settings and see how they affect a preview of the printed worksheet?

When you select a cell range, the cells must be adjacent to each other.

You can use trendlines to project future data based on past trends.

Jim wants to print sections of the various worksheets. The most efficient way for him to do so is to print one worksheet at a time.

When you remove duplicate records from a table, Excel can examine only one column for duplicate data.

Tracer arrows help you determine which cells are included in named ranges.

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

Which of the following is a way to make a table accessible?

A(n) _____ is a specially formatted word, phrase, or graphic that, when clicked, displays a webpage.

Jenny inserted two types of SmartArt in a worksheet and wants to make them look more similar. Which of the following can she do?

A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value. In order to do so, he will type the formula =A1-B1 in an empty cell.