BASIC EXCEL - 5

It is one of the widely used references in MS-Excel because it is related to column and row.

• Relative

• Absolute

• Mixed

• None of the above

Types of references that do not allow them to be modified at the time of copying since they remain fixed regardless of the number of times they are copied.

• Mixed

• Absolut

• References

• None of the above

This type of reference is a type of combination of the other two references in which the row or column can be locked.

• Absolut

• Mixed

• Relative

• None of the above

What is the correct example of a mixed column reference?

• =A2 + A10

• =A2 + A$10

• =A2 + $A10

• =A2 + $A$10

To sort by criteria, in which tab we can find the Sort command.

• Home

• Insert

• Date

• View

Can we sort by custom criteria within the spreadsheet?

• True

• False

Mention the steps to add levels within a data order.

• Insert - Sort and filter - Sort - Add level - Insert field

• Data - Sort and filter - Filter - Add level - Insert field

• Data - Sort and filter - Sort - Add level - Insert field

• None of the above

It is one of the types of filters that we can use for a series of characters ...

• Numeric

• Text

• Color

• Selection

What are the wildcard characters that we can use within the filters?

• (!) y (?)

• (*) y (?)

• (@) y (%)

• (*) y (/)

The image shows various filter options that can be performed on a set of information. With which filters we can do it.

• Color filters

• Text filters

• Numerical filters

• Search Filters