- Alt + =
- Ctrl + =
- Shift + =
- F2
Category: computer skills
- #DIV/0!
- #NAME?
- #VALUE!
- #SUCCESS!
- Looks for a value in the leftmost column of a table, and returns a value in the same row from a column you specify.
- Looks for a value in the top row of a table, and returns a value in the same column from a row you specify.
- Adds values vertically.
- Validates data entry.
- Ctrl + + (plus)
- Ctrl + – (minus)
- Ctrl + Shift + + (plus)
- Ctrl + Shift + – (minus)
- Ctrl + + (plus)
- Ctrl + – (minus)
- Ctrl + Shift + + (plus)
- Ctrl + Shift + – (minus)
- SUM()
- JOIN()
- CONCATENATE()
- TEXT()
- Ctrl + PgUp
- Ctrl + PgDown
- Ctrl + Tab
- Shift + Tab
- Ctrl + PgDown
- Ctrl + PgUp
- Ctrl + Tab
- Shift + Tab
- Sort
- Filter
- Conditional Formatting
- Subtotal
- 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.
- 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
