Exam 2: Excel-2019

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

Marianna wants to make the legend stand out on a chart. Which of the following can she do?

To enter a typed number into a cell, you can press Tab or Backspace.

A teacher creates a table of student data that contains columns for First Name, Last Name, and Date of Birth. To list the students in alphabetical order by last name, she can sort the Last Name column in ascending order.

Rohan can display the current date in a cell using the TODAY() function.

You can change the caption of a Check Box form control, but not its internal name.

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

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

Binay wants to create an X-Y scatter plot. To do so, he should select the data he wants to plot in the scatter chart, then click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.

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

You can set only one language as the editing language in Excel.

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

Which of the following is true about moving cell contents?

The Clipboard task pane shows the contents of the _____.

Which of the following would you use to print only one page of a multipage worksheet?

With a _____, you can emphasize one data point by exploding it.

What feature inserts a function that totals the cells above or to the left of the selected cell?

Carol wants to redisplay a workbook window she had hidden earlier. Which button should she click on the View tab?

The formula =ROUNDDOWN(G5,0) can be used to round the number 46.734, entered in cell G5, to the nearest whole number.

You should not move a PivotChart because it must be on the same worksheet as its PivotTable.