NEW
Font size
WorksheetsAdvanced Operations with Excel Quiz
Total questions: 20
Worksheet time: 10mins
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
A pivot table in MS Excel serves what purpose?
To create a dynamic summary report
To record macros
To send emails from Excel
To protect the workbook
What is the purpose of a pivot chart in MS Excel?
To protect the workbook
To send emails from Excel
To record macros
To create a dynamic summary report
What is the purpose of using the macro recorder in MS Excel?
To manually perform routine tasks
To delete data from the workbook
To create pivot tables
To automate routine tasks
What does the Use Relative References option do in MS Excel?
Sorts the data in ascending order
Counts the number of cells in a range
Uses relative cell addresses when recording a macro
Uses absolute cell addresses when recording a macro
How can you edit a created macro in MS Excel?
By using the VBA programming editor
By using the macro recorder
By sending an email
By protecting the workbook
What is the purpose of protecting a workbook in MS Excel?
To prevent accidental deletion of critical data
To make it easier to format cells
To allow anyone to modify the data
To restrict access to the workbook
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 protect the workbook
To send emails from Excel
What is the purpose of a pivot table in MS Excel?
To create a dynamic summary report
To record macros
To send emails from Excel
To protect the workbook
A field that has a column orientation in the pivot table. Each item in the field occupies a column.
Column labels
Report Filter
Row labels
Values area
A field that has a row orientation in the pivot table. Each item in the field occupies a row.
Values area
Column labels
Row labels
Report Filter
