- To color-code cells.
- To restrict the type of data or values that users enter into a cell.
- To automatically correct spelling errors.
- To analyze large datasets.
No category found.
- SUMIF()
- COUNTIF()
- IF()
- VLOOKUP()
- AutoSum
- AutoFilter
- AutoFill
- AutoCorrect
- It adjusts the column width to fit the text.
- It allows text to extend beyond the cell boundary.
- It wraps long text within a cell so that it appears on multiple lines.
- It rotates the text within the cell.
- Pie Chart
- Bar Chart
- Line Chart
- Scatter Plot
- To combine multiple text strings into one.
- To split the contents of one cell into separate columns.
- To change the font color of text.
- To wrap text within a cell.
- Ctrl + 9
- Ctrl + 0
- Ctrl + Shift + 9
- Ctrl + Shift + 0
- Ctrl + 9
- Ctrl + 0
- Ctrl + Shift + 9
- Ctrl + Shift + 0
- Sort
- Filter
- Remove Duplicates
- Data Validation
- Shift + F11
- Ctrl + F11
- Alt + F11
- F11
- It changes when a formula is copied to another cell.
- It remains constant when a formula is copied to another cell.
- It refers to a cell on another worksheet.
- It refers to a cell in a different workbook.
- Data Validation
- Conditional Formatting
- Sort
- Filter
- To combine cells and align text to the left.
- To combine cells and center the content in the new, larger cell.
- To separate merged cells.
- To apply a border to cells.
- Insert
- Page Layout
- Formulas
- Home
- Ctrl + O
- Ctrl + S
- Ctrl + N
- Ctrl + P
- UPPER()
- LOWER()
- PROPER()
- SMALL()
