Applying formatting styles based on the criteria or data

Home Tab–>Styles Group–>Conditional Formatting

Sorting
re-arrange the existing data in the excel table

Filtering
showing the data only matches the specified criteria by hiding rest.

Home Tab–>Editing Group
(or)
Data Tab–>Sorting&Filtering

=RANDBETWEEN(Low, High)

Charts
used to create different types of Charts based on the selected data in the table.

Insert Tab–>Charts

Insert Chart in a new sheet: F11

Contextual Tabs of Chart:
Chart Design
Chart Format

Components of Chart:
1. Chart Area
2. Plot Area
3. Category Axis
4. Value Axis
5. Grid lines
6. Chart Title
7. Axis Title
8. Legend