Advanced Operations with Excel Quiz

What is the purpose of using macros in MS Excel?

• To make the tasks more complicated

• To automate routine tasks

• To slow down the procedure

• To limit the functionality of Excel

This is one of the options in the Macros command button dropdown menu. This opens the Macro dialog box where you can select a macro to run or edit.

• Use Relative References

• Record Macro

• View Macros

• Delete Macro

What does the VLOOKUP function do in MS Excel?

• Sorts the data in ascending order

• Counts the number of cells in a range

• Searches for a value vertically

• Searches for a value horizontally

One of the parameters of VlookUp that is value that the function uses to search on.

• Range_lookup

• lookup_value

• Col_index_num

• The table_array

This VlookUp option is the column of data that contains the answer that you want.

• Col_index_num

• The table_array

• lookup_value

• Range_lookup

It is the area of cells in which the table is located. This includes not only the column being searched on, but the data columns for which you are going to get the values that you need.

• Col_index_num

• The table_array

• lookup_value

• Range_lookup

How can you email a workbook in MS Excel?

• Choose File » Print

• Choose File » Save and Send

• Choose View » Email Workbook

• Choose Edit » Send Email

What is the purpose of protecting a worksheet in MS Excel?

• To restrict access to the workbook

• To make it easier to format cells

• To prevent accidental deletion of critical data

• To allow anyone to modify the data

The following statements are the various ways Excel provide to protect a workbook, EXCEPT one. Which one is it?

• Prevents users from changing the size or position of windows

• Prevents the users from adding sheets, deleting sheets, hiding sheets, and unhiding sheets.

• Requires a password to open the workbook.

• Allows users to full access to the sheets.

What is the purpose of a data table in MS Excel?

• To create a list of macros

• To summarize data in a table format

• To send emails from Excel

• To protect the workbook