BASIC EXCEL - 4

From the following options. What are the basic orderings within a spreadsheet?

• Ascending and by field

• Descending and ascending

• By image and descending

• None of the above

Mention in which tab we can find the sorting group and filter apart from the Home tab.

• Formulas

• View

• Revision

• Date

How can we put the filters inside the columns in the spreadsheet?

• Home Tab - Editing - Sort & Filter - Filter

• Data Tab - Sort & Filter - Filter

• Insert Tab - Edit - Sort & Filter - Filter

• View Tab - Sort & Filter - Filter

To use a formula or function within a spreadsheet, we must place the sign ...

• Asterisk

• Admiration

• Question

• Equal

This MS-Excel tool is used to highlight errors, values ​​that meet a certain condition, to highlight cells according to their value contained in it.

• Tables

• Coditional format

• Styles design

• Themes

It is one of the options that can be used for the conditional formatting tool.

• Headers

• Icon set

• column bar

• Cell format

The following image shows three formats that were placed, one of the formats that appears there is:

• If the grade is between 1 and 6.9 the text is italic

• If the rating is between 1 and 6.9 the background is red

• If the rating is between 1 and 6.9 the background is green.

• None of the above

It is one of the types of erasure in which it leaves the cell in its original state.

• Erase everything

• Clear format

• Erase style

• None of the above

It is one of the special pastes in which we can perform operations to use them in other cells.

• Transpose

• Values

• Format

• Formulas

We can uniquely identify a cell or a range of cells within an MS-Excel spreadsheet.

• References

• Formats

• Addresses

• Values