Spell check is a sub-feature of Excel's proofing system. It checks for incorrect spellings, typos, and repeated words. Unlike Word, Excel doesn't display red underlines for corrections
VLOOKUP is an Excel function for finding values in tables by row. Formula format: =VLOOKUP(lookup_value, search_range, column_number, match type). Used by financial staff for price lookup and employee name finding
Create separate sheets for each table to be merged. Select columns to combine in dialog box. Review merged table for correct data combination
Drop-down lists help users work more efficiently in worksheets. List items should ideally be in Excel table format. Data can be converted to table using Ctrl+T
Worksheets can be moved by dragging tabs to desired locations. Copying requires holding CTRL while dragging or using Move or Copy command. Moving sheets may affect formulas and charts that reference data
Gridlines divide cells on Excel worksheets by default. Gridlines can be enabled or disabled by worksheet. Gridlines are different from customizable cell borders