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?
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