DeskReady
Sign inSign up free

Spreadsheet

Practice for Excel tests

Formulas, IF, VLOOKUP and XLOOKUP, text and dates, filters, charts and PivotTables.

0%
Start the course →Shortcut drills51 tasks · 3 free · unlock all

Formulas

0/7
  1. 1Total a column with SUMFreeStart →
  2. 2Find an average with AVERAGEFree
  3. 3Find the highest and lowest with MAX and MINFree
  4. 4Count entries with COUNTJob Test Prep
  5. 5Count filled cells with COUNTAJob Test Prep
  6. 6Round numbers with ROUNDJob Test Prep
  7. 7Find the top scores with LARGEJob Test Prep

Cell references

0/4
  1. 8Multiply and fill a formula downJob Test Prep
  2. 9Use an absolute referenceJob Test Prep
  3. 10Calculate percent of totalJob Test Prep
  4. 11Build a table with mixed referencesJob Test Prep

Logical functions

0/9
  1. 12Label results with IFJob Test Prep
  2. 13Assign grades with a nested IFJob Test Prep
  3. 14Test two conditions with ANDJob Test Prep
  4. 15Test either condition with ORJob Test Prep
  5. 16Count matching rows with COUNTIFJob Test Prep
  6. 17Total matching rows with SUMIFJob Test Prep
  7. 18Count with two conditions: COUNTIFSJob Test Prep
  8. 19Add with two conditions: SUMIFSJob Test Prep
  9. 20Hide errors with IFERRORJob Test Prep

Lookups

0/5
  1. 21Look up a value with VLOOKUPJob Test Prep
  2. 22Fill a VLOOKUP downJob Test Prep
  3. 23Look up in any direction with XLOOKUPJob Test Prep
  4. 24Find a position with MATCHJob Test Prep
  5. 25Combine INDEX and MATCHJob Test Prep

Text

0/6
  1. 26Join text from two cellsJob Test Prep
  2. 27Pull characters with LEFTJob Test Prep
  3. 28Pull characters with MIDJob Test Prep
  4. 29Fix capitalization with PROPERJob Test Prep
  5. 30Remove extra spaces with TRIMJob Test Prep
  6. 31Extract a first name with LEFT and FINDJob Test Prep

Dates

0/4
  1. 32Format datesJob Test Prep
  2. 33Count the days between datesJob Test Prep
  3. 34Pull the year and month from a dateJob Test Prep
  4. 35Build a date with DATEJob Test Prep

Formatting

0/5
  1. 36Apply the Currency formatJob Test Prep
  2. 37Show values as percentagesJob Test Prep
  3. 38Format a header rowJob Test Prep
  4. 39Merge and center a titleJob Test Prep
  5. 40Highlight values with Conditional FormattingJob Test Prep

Data

0/4
  1. 41Sort a table, largest to smallestJob Test Prep
  2. 42Filter a tableJob Test Prep
  3. 43Remove duplicate rowsJob Test Prep
  4. 44Update text with Find and ReplaceJob Test Prep

Charts

0/2
  1. 45Create a column chartJob Test Prep
  2. 46Show parts of a whole with a pie chartJob Test Prep

PivotTables

0/2
  1. 47Total by group with a PivotTableJob Test Prep
  2. 48Count by group with a PivotTableJob Test Prep

Rows and columns

0/3
  1. 49Insert a missing rowJob Test Prep
  2. 50Delete an unused columnJob Test Prep
  3. 51Freeze the header rowJob Test Prep