Skip to content

Practice Assessment Tests

Free Assessment Tests To Get You Prepared

Toggle menu
  • Home
  • Hiring Now
    • Government Jobs
    • Amazon
    • WalMart
    • Epic Systems
    • Honeywell
    • Delta Airlines
    • Progressive Insurance
    • CVS
    • IBM
    • Civil Service Jobs
      • TSA
      • USPS
  • Browse Tests
    • Leading Employers
      • Amazon
      • Costco
      • WalMart
      • Target
      • Home Depot
      • Epic Systems
      • P&G – Procter and Gamble
      • Phillip Morris
      • Accenture
      • Deloitte
      • KPMG
      • Vista Equity Partners
      • Insurance Companies
        • AllState Insurance
        • Cigna Insurance
        • Farmers Insurance
        • Progressive Insurance
        • Geico Insurance
        • Centene Insurance
        • Liberty Mutual Insurance
        • American Family Insurance
        • Insurance Claim Adjustor
        • Insurance Underwriter
    • Popular Jobs
      • TSA Officer
      • Airline Pilot
      • Flight Attendant
      • Manager and Supervisor
      • Admin Assistant
      • Accountant
      • Cabin Crew
      • Customer Service Representative
      • General Manager
      • Call Center Agent
      • Correction Officer
      • Bus Driver
      • Customs and Border Protection
      • Public Sector Worker
      • Port Authority
      • Sales Representative
      • Security Guard
      • FBI Special Agent
      • FBI Intelligence Analyst
    • Public Sector
      • Government jobs
        • New York City – NYC DCAS
        • New York State (NYS)
        • City of Toronto
        • Texas
        • California
          • Southern California
      • Civil Service Jobs
        • TSA
        • USPS Postal Worker
        • Emergency Responder
        • Police Officer
        • Correction Officer
        • Probation Officer
        • Traffic Enforcement Agent
      • Military
        • USA Army (ASVAB)
        • British Army
        • Canadian Forces
    • Airlines
      • American Airlines (Flight Crew)
      • American Airlines (Pilot)
      • Delta (Flight Crew & Pilots)
      • Delta Mechanic (BMAR)
      • United Airlines (Pilot)
      • United Airlines (Virtual Job Tryout)
      • Air Traffic Controller (ATSA)
      • Air Traffic Controller (FEAST)
      • Air Traffic Controller (NAV Canada)
      • Wonderlic for Flight Attendants
    • Retail
      • Amazon
      • Aldi
      • AutoZone
      • Costco
      • Dollar General
      • Dollar Tree
      • Home Depot
      • Kroger
      • Lowes
      • Publix
      • Pizza Hut
      • IKEA
      • Target
      • TJ Maxx
      • Trader Joe’s
      • WalMart
      • Whole Foods
    • Financial Services
      • Citigroup (Citi)
      • Wells Fargo
      • Bank of America
      • CapitalOne
      • Morgan Stanley
      • Edward Jones
      • Royal Bank of Canada (RBC)
      • AlixPartners
      • Synchrony Financial
    • Consulting
      • KPMG
      • PwC
      • EY (Ernst & Young)
      • Accenture
      • Deloitte
      • Robert Half
      • McKinsey
      • BCG
      • Bain & Company
    • Consumer Companies
      • CVS Pharmacy
      • Walgreens
      • Coca-Cola
      • TJ Maxx
      • Publix Super Markets
      • Philip Morris
      • FedEx
      • Valero
    • Energy Companies
      • Shell
      • ExxonMobil
      • Chevron
      • Phillips 66
      • DuPont
      • Marathon Petroleum
      • Nucor
      • NuStar
      • Dow Corning
      • Valero
    • Technology
      • Amazon
      • Applied Materials
      • AT&T
      • Comcast
      • Facebook (Meta)
      • Google (Alphabet)
      • IBM
      • Microsoft
      • NVIDIA
      • Spectrum
      • TekSystems
      • Teleperformance
      • Teletech
      • Tesla
      • Verizon
    • Industrial Companies
      • ExxonMobil
      • DuPont
      • Caterpillar
      • GE (General Electric)
      • Dow Corning
      • Reynolds
      • Honeywell International
      • Boeing
      • GoodYear
    • Automotive
      • Ford Motor Company
      • Toyota
  • Assessment Vendors
    • CCAT
      • Crossover CCAT
    • SHL
      • SHL Verify G+ General Ability
      • SHL OPQ32 Personality Test
      • Interpret SHL Test Results
    • Korn Ferry
      • Korn Ferry Leadership
      • Korn Ferry Talent Q
    • Wonderlic
    • Ramsay
    • Hogan
      • Hogan Business Reasoning (HBRI)
      • Hogan Personality Inventory (HPI)
    • Caliper Profile
    • Talogy Cubiks
    • JobTestPrep
    • Indeed
    • eSkill
  • By Test Type
    • Excel Test
    • Cognitive Test
    • Customer Service Skills
    • Personality Test
    • Mechanical Aptitude Test
    • Situational Judgement
    • Problem Solving
    • Attention to Details
    • Analytical Reasoning Test
    • Communication Skills
    • Leadership Assessment
    • Microsoft Office
      • Microsoft Excel
      • Microsoft Word
      • PowerPoint
      • Office Value Pack [50% OFF]
    • Typing Test
    • Data Entry Test
    • Electrical Aptitude
    • On-Demand Assessment
    • Virtual Job Tryout
  • By Job Title
    • Manager and Supervisor
    • Customer Service
    • Admin Assistant
    • Data Analyst
    • Business Analyst
    • Project Manager
    • Software Engineer
    • Government Employee
    • TSA Officer
    • Accountant
    • Bookkeeper
    • Elevator Mechanic
    • Machine Operator
    • Sales Representative
    • General Manager
    • Crew Flight Attendant
    • Bus Driver
    • Traffic Enforcement
    • Probation Officer
    • USPS Mail Delivery
    • Police Officer
    • Correction Officer
    • Firefighter
    • Civil Service Employee
  • By Industry
    • Airline Industry
    • Automotive Industry
    • Civil Services
    • Government Jobs
    • Information Technology (IT)
    • Financial Services
    • Consulting
    • Consumer Goods
    • Energy Industry
    • Hospitality
    • Insurance
    • Healthcare
    • Logistics & Supply Chain
    • Manufacturing
    • Pharmaceutical
    • Retail
    • Staffing Agencies
    • Transportation
    • Oil & Gas Industry
    • Utility Industry
  • Academic
    • MAP (NWEA)
      • Kindergarten & 1st Grade
      • 2nd Grade
      • 3rd Grade
      • 4th Grade
      • 5th Grade
      • 6th Grade
      • 7th & 8th Grade
      • 9th & 12th Grade
      • Family Membership
      • Teacher Membership
    • CAT4
      • Level X — Year 2
      • Level A – Year 4
      • Level B – Year 5
      • Level C – Year 6
      • Level D – Year 7
      • Level E – Year 8
      • Level F – Year 9 & 10
      • Level G – Year 11+
    • CogAT
      • Kindergarden — Level 5/6
      • 1st Grade — Level 7
      • 2nd Grade — Level 8
      • 3rd Grade — Level 9
      • 4th Grade — Level 10
      • 5th Grade — Level 11
      • 6th Grade — Level 12
    • Renaissance STAR Test
      • Early Literacy
      • Grades 1-2
      • Grades 3-4
      • Grades 5-6
      • Grades 7-8
    • iReady
      • Kindergarten
      • 3rd Grade
      • 4th Grade
      • 7th Grade
      • 8th Grade
      • Math Scores
      • Reading Scores
    • STAAR
      • 3rd Grade
      • 4rd Grade
      • 5rd Grade
      • 6rd Grade
      • 7rd Grade
      • 8rd Grade
    • SCAT
      • Elementary (2nd–3rd Grade)
      • Intermediate (4th & 5th Grade)
      • Advanced (6th–8th Grade)
    • NNAT
      • Kindergarten
      • Grade 1
      • Grade 2
      • Grade 3
    • OLSAT
      • Pre-K-K
      • 1st Grade
      • 2nd Grade
      • 3rd Grade
      • 4th-5th Grades
      • 6th-8th Grades
      • 9th-12th Grades
    • NNAT-OLSAT
      • Bundle A
      • Bundle B
      • Bundle C
      • Bundle D
      • Bundle E
    • ATI TEAS
      • Reading
      • Math
      • Science
      • Version 7
      • English Language Usage
    • NLN PAX
    • MAP & CogAT
      • 2nd Grade
      • 3rd Grade
      • 4th Grade
      • 5th Grade
  • Ebooks
    • Excel Test
    • Ace Job Interview
  • Contact Us

Excel VLOOKUP Tutorial XLSX and ZIP Source Files Download

Download Files Used in the Video

There are 2 Excel Assessment work files included in this free download. Please click on the link below to download the files.

  • VLOOKUP Tutorial Source Files .v1.77.20190929.zip - XLSX File to follow along with the video
  • VLOOKUP Tutorial Source Files .v1.77.20190929.xlsx.zip - Zip Archive of XLSX file

 

 

 

Popular Tests

  • CCAT
  • Excel Test
  • CritiCall
  • TSA Test
  • General Ability
  • Microsoft Office
  • Caliper Profile
  • Korn Ferry Leadership
  • Korn Ferry Talent Q
  • Situational Judgement (SJT)

Now Hiring

  • Amazon
  • TSA
  • Crossover
  • Procter and Gamble
  • Epic Systems
  • WalMart
  • Target
  • Costco
  • Home Depot
  • Aldi
  • Marriott
  • EY (Ernst & Young)
  • Government Jobs
  • Civil Service Jobs

Employment Skills

  • Cognitive Skills
  • Attention to Details
  • Problem Solving
  • Customer Service
  • Personality
  • Leadership
  • Communication
  • Situational Judgement
  • Mechanical Aptitude
  • Electrical Aptitude

Follow

  • YouTube
  • LinkedIn
  • TikTok

(C) 2024 Online Training for Everyone LLC. All Rights Reserved

  • DMCA Policies
  • Terms and Conditions
  • Privacy Policy
  • Advertisers and Paid Collaboration
  • Disclaimer

Social Media

  • YouTube
  • LinkedIn
  • TikTok
  • Facebook
  • Instagram

Now Hiring

  • Government Jobs
  • Amazon
  • Crossover
  • Procter and Gamble
  • Epic Systems
  • WalMart
  • Target
  • Costco
  • Home Depot
  • Aldi
  • Marriott
  • EY (Ernst & Young)
  • Civil Services Jobs

Employment Skills

  • Cognitive Skills
  • Attention to Details
  • Problem Solving
  • Customer Service
  • Personality
  • Leadership
  • Communication
  • Situational Judgement
  • Mechanical Aptitude
  • Electrical Aptitude

Popular Tests

  • CCAT
  • Amazon
  • CritiCall
  • TSA Test
  • Epic Systems
  • General Ability
  • Microsoft Office
  • Caliper Profile
  • Korn Ferry Leadership
  • Korn Ferry Talent Q

Assessment Vendors

  • CCAT
  • SHL
  • Korn Ferry
  • Ramsay
  • Hogan
  • Caliper Profile
  • Talogy Cubiks
  • Wonderlic

Assessments By Industry

  • Civil Services
  • Retail
  • Financial Services
  • Information Technology (IT)
  • Insurance
  • Consulting
  • Consumer Goods
  • Healthcare
  • Hospitality
  • Airline Industry
  • Energy Industry
  • Logistics & Supply Chain
  • Manufacturing
  • Oil & Gas Industry
  • Government
  • Pharmaceutical
  • Utility Industry
  • Staffing Agencies
  • Transportation
  • Automotive

Microsoft Office

  • Excel Test
  • Word Test
  • PowerPoint Test
  • Office Pack (50% OFF)
© 2026 Practice Assessment Tests. Proudly powered by Sydney