EXCEL EXPERT - 1

In order to import external data into Excel we have two options which are:

• Excel clipboard and import data from another file

• Windows clipboard and import data from another file

• Windows clipboard and export data from another file

• Exportar e importar datos de otro archivo

Within the wizard to import text, we indicate that the information is separated and that separator can be ...

• (,) Comma sign

• ($) Money sign

• (*) Aestrisk

• (#) Number sign

In Excel when we have data that contains repeating values ​​and we need to get unique values, we can use the command ...

• Import from file

• Data validation

• Remove duplicates

• Text to columns

Can we tell the remove duplicate command that the data has headers?

• True

• False

Command that allows me to ensure that the values ​​entered in the cells are correct, we can even display an error message.

• Remove duplicates

• Group data

• Subtotals

• Data validation

At the time of entering the rent payment in a cell of Excel, it is indicated that the rent amount is from 5500, what is the validation criterion that we must choose?

• List

• Integer

• Text length

• Decimals

It is one of the tabs in the data validation dialog box to configure:

• Exit message

• Data selection

• Error message

• None of the above

If I want to sort my information as shown in the image, let me see the processor in column D: "Core 2 Duo" and in ascending order in column E. What are the steps to follow?

• Data - Sort and filter - sort from A to Z, two times

• Data - Sort and filter - sort - add levels in columns D and E

• Home - Editing - Sort from A to Z

• None of the above

When we have a table or database in Excel with a large amount of information, we can add all of them, we use the command.

• Subtotals

• Group data

• Filters

• Sort Data

It is one of the functions that allows us to make subtotals.

• Product

• Logarithm

• Average

• Median