Exam 2: Excel 2019

Before importing data into Excel, you can use the Power Query Editor to remove columns.

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.

Which of the following keys should you press to have Excel calculate all open workbooks manually?

A(n) _____ is an electronic attachment that verifies the authenticity of the author.

You can create a PivotChart from data or from a PivotTable report.

To insert only the current date in cell B1, use the NOW function in cell B1 .

An Excel table contains columns named Salary and Commission. Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

Which of the following is an effect you can apply to a picture?

To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

To outline data, select the rows or columns you want to group, then click the Group button on the Data tab.

One can manage available Office add-ins by clicking Gear icon > Settings > Mail > Options pane > General > Manage add-ins > Add/ Uninstall/ find more add-ins.

When you change cell contents to italics, you are changing the cell's alignment.

Which of the following statements describes tables where the EmployeeID field in the Employees table can be associated with many CustomerID fields in the Customers table?

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

A teacher creates a table for Sports Day events. The table includes columns for Event, Rank, First Name, and Last Name. To find the top-ranking participants for each event, the teacher can sort the table first by Event and then by Rank.

When you underline cell content, you are using _____.

Tomoko lists monthly sales for each region in a worksheet. Before adding subtotals for each region, she needs to sort the values in the Region column.

Which of the following is the default function Excel uses to summarize text data in a PivotTable?

Cora inserted a Check Box control in a worksheet. She wants to display the text TRUE in cell B17 when the control contains a checkmark. What property should she set?

Martha created a table where employees can enter customer data. She wants to display a reminder when an employee clicks a cell in the Contact Type column Which of the following should she use?