Uploading Your Work — Unit test

Question 1

Fiona is starting to utilize the protection capabilities of Excel 2019. For the Lock or Unlock Cells function to work, which option should be enabled?

Revolt · Accepted Answer

The Protect Worksheet function needs to be enabled.

Question 2

Which option represents the location of the Goal Seek function?

Revolt · Accepted Answer

Data tab, Forecast group

Question 3

Which sparkline type is best for displaying trends in data changes over time?

Revolt · Accepted Answer

line

Question 4

Quinn is opening an Excel workbook and receives an information bar and warning that the workbook contains macros.Quinn is prompted to enable the macros. What should he do?

Revolt · Accepted Answer

Check where the file originates from, and if it is a trusted source or his own workbook, click Enable Content.

Question 5

Lonnie has several workbooks that contain financial and sales data. He needs to ensure that if the data in a single cell in one workbook changes that it is automatically updated and reflected in another workbook.What should Lonnie create?

Revolt · Accepted Answer

linked cell

Question 6

In a VLOOKUP formula, what does the argument column_index_number mean?

Revolt · Accepted Answer

the number of the column within the selected table array where the lookup result is located

Uploading Your Work — Unit test Answers

More from this Course

TRY EDGENUITY HACKS