Can you explain what a ribbon is?

Do you know the three types of cell references?

Do you know how to convert a number to a currency?

An Excel folder with a resume inside.

Lucas Gouveia / How-To Geek |olesia_g/ Shutterstock

There are three types of cell references in Excelrelative, absolute, and mixed.

Arelativereference (the default reference jot down in Excel), refers to the relative position of the cell.

Anabsolutereference does not change if you copy the formula into another cell.

An Excel workbook with five key elements highlighted with arrows and the numbers one to five.

Amixedreference combines relative and absolute references at the same time.

Likewise, if you typedApr 14, Excel would read this as a date.

Another way to filter and sort your data is by formatting your data into a table.

An Excel worksheet with the Data Type box highlighted and the drop-down opened, showing the data type options.

Finally, you could sort and filter a specific series of data by selecting and right-clicking your data.

Then, choose between the Filter and Sort options in the menu that appears.

The pivot table option is accessed through the Insert Tab on the ribbon.

The Filter option in Excel is highlighted.

They also help you to avoid errors that might have occurred had you completed the tasks manually.

An Excel spreadsheet with data selected, and the Filter and Sort options displayed by right-clicking the selected data.

An Excel sheet containing data, and the PivotTable option in the Insert tab on the ribbon is highlighted.