Advanced Excel End of Workshop Assessment

Which tool would you use to clean data in excel?

• Power Query

• Space tab

• Slicer

• Thesaurus

Name any Excel Function you can use to find values in your dataset.

(a)  

You use (a)   to fix the cell/range reference.

How would you get data from different data sources?

• Home > Editing > Choose data source

• Data > Get & transform data commands > Choose your data source

• File > Open > Choose your data source

• Data > Data tools > Choose data source

What will the command =LEN(Worksheets) return?

(a)  

Wildcards can be used to filter data in Excel.

• Yes

• No

What is the difference between FUNCTION and FORMULA in Excel

• A FUNCTION contains symbols while a FORMULA does not.

• A FORMULA is a subset of a FUNCTION

• A FUNCTION is a build-in rule by Excel while the FORMULA is a statement written by the user for calculations

• A FUNCTION is a higher level FORMULA

Jane works at IOM Regional Offices in Timbuktu. The organization has a Windows-based network. Jane has to perform the following tasks: Summarize large amounts of data, Analyze numeric data, and Answer unexpected questions about data.

Which of the following actions will Jane take to accomplish the task?

• She will use stand-alone slicers.

• She will configure form controls.

• He will create the accounting template.

• She will create a Pivot Table report

You have created a spreadsheet in Excel and shared it with your colleagues. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data.

Which of the following options will you choose to accomplish the task?

• Mark as Final

  Sheet

• Encrypt with Password

  Sheet

• Protect Workbook Structure

• Protect Current Sheet

If you want to copy the format of a cell, text or image and apply it to another cell, the Format painter is used.

• True

• False