EXCEL EXPERT - 2

Can we group the information in MS Excel?

• True

• False

Before subtotals within the information, what should we do in the first instance?

• Filter

• Sort

• Scheme

• Validate

In the next image, we want to subtotal quantity and total, the option to replace current subtotals, if it was disabled. What action is carried out?

• Delete the subtotals that were made previously

• Send the subtotals to another spreadsheet

• Shows the subtotals that have been made previously

• None of the above

To place an error message in the data validation, we have three icons that we can present and one of them is ...

• Access

• Error

• Delete

• Find

It is one of the options to be able to import data into Microsoft Excel.

• Microsoft Access

• Adobe photoshop

• Oracle Database

• Visual Studio

Can we perform a totally personalized data filtering, providing the criteria to be able to do it?

• Search filters

• Advanced filters

• Numerical filters

• Text filters

Wildcard that helps us make a filter by expanding the search in some criteria and that can be placed before and after the word.

• Question sign

• Exclamation sign

• Asterisk sign

• Pesos sign

The option to copy to another place in the Advanced Filter dialog box, what action does it take?

• Displays the filter result in another position on the spreadsheet

• Displays the filter result in another position in the book

• Removes the information that is not required and displays it in the same place on the spreadsheet

• None of the above

In the following figure if you ask me to filter the people who work in the finance department, I just want you to show me the employee number, what would the filter criteria be?

• Criterion: Name, Information to display: No. employee

• Criterion: Department, Information to show: Name

• Criterion: Surname, Information to display: No. employee

• Criteria: Department, Information to show: Employee No.

With how many maximum variables can we work in a data table?

• 4 variables

• 6 variables

• 2 variables

• None of the above