Introduction
  • Course Introduction and Overview
Typical Excel Assessment Test Questions
  • How to calculate total units sold by Jason
  • Tip to Prepare for Test: Find Sample Questions from Provider
  • What happens when you click on the area, highlighted by the green Arrow?
  • How can you limit Date Range Entry in Excel Column C and B
  • Tip: Smart Ways to Prepare and Pass the Test
  • Find Odd Excel Formulas and Functions
  • How to Restrict Users from Editing Worksheet
  • How to Display Data in Excel Cell Where Text has been Cut Off?
  • Tip: How to Learn New Material Faster
  • How to Display Value in Excel Cell?
  • How to Reference Formulas from Another Excel Worksheet?
  • How to Return Excel Value from Base Cell?
  • How to Select Custom Date Formatting Option in Excel?
  • Tip: Do Not Guess Answers During the Test
  • How Would You Add Chart into Excel Cell?
  • Which Excel Chart can Best Show Time Based Data?
  • Tip: How to Pass Excel Test During COVID-19
  • Which Excel Function Will return the largest Value?
  • How to display Product ID for the Product Name
  • Which Keyboard shortcut is used for Autosum?
  • Tip: Best Practices for Excel Employment Test Preparation
  • How to Fit a graph information into one cell
  • How to highlight duplicate values by using conditional formatting
  • How to increase decimals of the value which has percentage sign
  • If cell B2 contains a Text value which function returns TRUE
  • Tip: How to Plan Your Time During Excel Assessment Test
  • Row ___ causes adjacent rows to have different formatting
  • The ___ function calculates relative position of an item in a range or table
  • Which Keyboard shortcut is used to insert current date in Excel?
  • To create new sheet in excel you ___
  • How to Create a New Worksheet in Excel?
  • Tip: Smart Ways To Learn the Material
  • To create new tab in Excel you do this
  • What does clicking on green arrow do
  • What is the fastest way to copy format of one table to another table
  • When you are activating a graph which sequence add a trendline
  • Which Keyboard shortcut is used to wrap the text in Excel?
  • Which Excel format would you use to display date as January 2020
  • Which Excel formula can generate random numbers between 200 and 500
  • Which Excel formula will increment month to the next
  • Which Excel ribbon command can you use?
  • Which formula can make first letter in a word uppercase?
  • Which formula can separate first and last name?
  • Which formula would remove percentage sign?
  • Which function can remove unwanted spaces from cell?
  • Which Function returns leftmost 3 characters?
  • Take Practice Excel Assessment Test using Attached PDF Download
Hands On Excel Assessment Test (Basic/Intermediate)
  • Section Overview
  • Expand Columns to fit the content
  • Change Font Styles and Sizes
  • Using Formulas and Functions
  • Calculate Profit
  • Row Header formatting. Charts and Graphs
  • Formatting. Working with Worksheets
  • Page Orientation and Margins. Printing worksheet. Save as PDF
  • Quiz 3: Hands on Excel assessment test .
Intermediate Excel Hands-on Excel Assessment Test - Typical First Questions
  • Intermediate Hands-on Excel Assessment Test - Section Overview
  • Question 1: Please describe the data in Excel Tab
  • Tip: How to Effectively manage your time during Interview and Assessment Test
  • Question 2: Please create Unique ID to Identify Each Row for Executives
  • Question 3: How to Create Random Unique 6 Digit ID
  • Tip: How to Handle Interview and Assessment Test Stress and work under pressure
  • Question 4: Create Custom Row ID to uniquely identify each row
  • Question 5: How to Create Unique GUID id for each row
  • Quiz 4: Intermediate Excel Hands-On Assessment Test.
Consulting Interview Questions - VLOOKUP (Advanced)
  • Consulting Interview VLOOKUP Questions - Section Overview
  • How to use VLOOKUP to find a Row of Data, Containing Certain Value
  • Excel VLOOKUP Overview
  • Challenges we are facing to answer the question
  • Wild Card Concept in Excel
  • VLOOKUP Question: Solution
  • Variation of VLOOKUP Question
  • Quiz 5: Consulting Interview Questions
Advanced Excel Assessment Test and Interview Questions
  • Section Overview
  • How to Import data from PDF into Excel
  • Professionally Format imported data
  • Describe Imported Data
  • Change Tab name and Assign Data Types
  • Create Excel Table
  • Split Name Column into First and Last Name
  • Split Address using Power Query
  • Determine City based on Zip Code
  • Calculate State based on Zip Code
  • Create Pivot Table
  • Determine Total Sales using Pivot Table
  • Create Map which shows Sales by State
  • Which County in California has largest Sales by Volume
  • Tip: What is the best way to learn new features in Excel
  • Quiz 6: Advanced Excel Assessment Test and Interview Questions
Excel Assessment Test Questions for Analyst Job - Pass with 20 Practice Steps
  • Question 1: Expand Columns in Product Sales Tab. Review and Analyze Data.
  • Question 2: Identify Potential issues and Errors with Data
  • Question 3: Format SalesDate Comumn into Short Date Format