Exam 2: Excel 2019

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others. After clicking in row 25, which option should she select in the Breaks button list?

(Multiple Choice)

4.9/5

(26)

Question 381

Use the DLOOKUP function to extract a single record from a table that matches criteria you specify.

(True/False)

4.9/5

(29)

Question 382

You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.

(Multiple Choice)

4.8/5

(38)

Question 383

A scenario is a named set of values you use in a what-if analysis to store and observe different worksheet results.

(True/False)

4.9/5

(44)

Question 384

You can use the DELETE key to clear cell contents.

(True/False)

4.7/5

(43)

Question 385

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

(True/False)

5.0/5

(31)

Question 386

By default, Excel records which type of cell references in a macro?

(Multiple Choice)

4.9/5

(41)

Question 387

What are you doing when you have Excel automatically translate each of your keystrokes and commands into program code?

(Multiple Choice)

4.7/5

(27)

Question 388

Ned has a table with an Expenses column listing monthly expenses. To total numbers in the Expenses column that are greater than 100, he can use the DSUM function.

(True/False)

4.8/5

(41)

Question 389

When a PivotTable has two levels of data in the Rows or Columns area, which of the following can you do?

(Multiple Choice)

4.8/5

(41)

Question 390

You can merge scenarios to apply scenarios from another worksheet into the current one.

(True/False)

4.9/5

(31)

Question 391

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12. When he presses ENTER, 23/08/2012 will appear in B12.

(True/False)

4.7/5

(31)

Question 392

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

(Multiple Choice)

4.8/5

(34)

Question 393

When you name a range, you can also define its _____, the location in a worksheet where the named range is recognized.

(Multiple Choice)

4.9/5

(42)

Question 394

The _____ function returns the value from a range of data at the intersection of a specified row and column.

(Multiple Choice)

4.8/5

(35)

Question 395

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

(True/False)

4.9/5

(38)

Question 396

To print more than one copy of your worksheet, which tab would you go to?

(Multiple Choice)

4.8/5

(34)

Question 397

After you delete a worksheet column, _____.

(Multiple Choice)

4.9/5

(34)

Question 398

To select the chart title in a PivotChart, click the Chart Title check box in the PivotrChart Fields pane.

(True/False)

4.9/5

(32)

Question 399

Which of the following tabs should you add to the ribbon to enable and run macros in a workbook?

(Multiple Choice)

4.8/5

(36)

Question 400

Showing 381 - 400 of 581

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others. After clicking in row 25, which option should she select in the Breaks button list?

Use the DLOOKUP function to extract a single record from a table that matches criteria you specify.

You can _____ PivotTable data to analyze specific values in a field, such as revenue data for two quarters.

A scenario is a named set of values you use in a what-if analysis to store and observe different worksheet results.

You can use the DELETE key to clear cell contents.

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

By default, Excel records which type of cell references in a macro?

What are you doing when you have Excel automatically translate each of your keystrokes and commands into program code?

Ned has a table with an Expenses column listing monthly expenses. To total numbers in the Expenses column that are greater than 100, he can use the DSUM function.

When a PivotTable has two levels of data in the Rows or Columns area, which of the following can you do?

You can merge scenarios to apply scenarios from another worksheet into the current one.

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12. When he presses ENTER, 23/08/2012 will appear in B12.

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

When you name a range, you can also define its _____, the location in a worksheet where the named range is recognized.

The _____ function returns the value from a range of data at the intersection of a specified row and column.

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

To print more than one copy of your worksheet, which tab would you go to?

After you delete a worksheet column, _____.

To select the chart title in a PivotChart, click the Chart Title check box in the PivotrChart Fields pane.

Which of the following tabs should you add to the ribbon to enable and run macros in a workbook?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters