Spreadsheet

Function that adds range of cells in Excel

• TOTAL

• SUM

• ADD

• PLUS

Create a dropdown list in a cell for selecting options like "Approved," "Pending," or "Rejected"

• Data Validation

• Sort and Filter

• Conditional Formatting

• Pivot Table

Feature to freeze the top row so it stays visible while you scroll down the sheet.

• Conditional Formatting

• Pivot Table

• Freeze Pane

• Data Validation

Combine text from multiple cells into a single cell

• Join

• Concatenate

• Merge

• Copy Paste

Quickly summarize large dataset.

• Sort and Filter

• Pivot Table

• Conditional Formatting

• Data Validation

Create a color gradient to visually represent values from lowest to highest in a range.

• Data Validation

• Charts and Graph

• Formula

• Conditional Formatting

A visual representation of data or information

• Chart

• Painting

• Spreadsheet

• Cell