Exam 2: Excel 2019

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Jack wants to show sparklines with symbols for positive and negative values in a range. He should insert Win/Loss sparklines.

(True/False)
4.7/5
(40)

When you distribute a workbook, you may want to encrypt it with a password to protect it.

(True/False)
4.8/5
(30)

Alba wants to display a picture as the worksheet background. Which of the following buttons on the Page Layout tab should she use?

(Multiple Choice)
4.8/5
(30)

Helen wants to resize slicer buttons to exact dimensions. She selects the slicer, then clicks the Slicer Tools under Options tab. What should she select next to reset the slicer buttons to exact dimensions?

(Multiple Choice)
4.9/5
(30)

One advantage of exporting a workbook as a PDF file is that a PDF preserves formatting and fonts but still lets readers edit the data.

(True/False)
4.9/5
(38)

Which of the following items does the Document Inspector check for sensitive information?

(Multiple Choice)
4.8/5
(43)

To embed an Excel chart in a PowerPoint slide, you can use the Destination Theme & Link Data button in the Paste Options group.

(True/False)
4.9/5
(40)

The _____ of a command button is used internally to reference it.

(Multiple Choice)
4.7/5
(37)

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

(True/False)
4.8/5
(33)

Changing a worksheet window to Normal view changes the contents of the worksheet.

(True/False)
4.8/5
(32)

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?

(Multiple Choice)
4.8/5
(42)

Which of the following can be the target of a hyperlink in Excel?

(Multiple Choice)
4.9/5
(39)

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

(Multiple Choice)
4.9/5
(48)

If Solver finds a solution, you can generate a Solution PivotTable on a separate worksheet.

(True/False)
4.7/5
(41)

Which of the following Shadow property values displays a shadow for Text Box (ActiveX Control)?

(Multiple Choice)
4.9/5
(32)

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.

(True/False)
4.8/5
(31)

To rotate cell contents to an exact value, you change its _____.

(Multiple Choice)
4.9/5
(40)

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

(Multiple Choice)
4.8/5
(43)

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

(Multiple Choice)
4.8/5
(28)

Maria entered three option buttons in a column on a worksheet and linked them to cell B2. When a user clicks the second option button, Excel inserts "2" in cell B2.

(True/False)
4.7/5
(38)
Showing 301 - 320 of 581
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)