Introduction
- Course Introduction and Overview
- Link to the exercise files
Typical Excel Assessment Test Questions
- Determine Excel Feature to use
- How to Calculate the average for the weekly sales
- 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)
- Download: Use Attached Files to practice Hands-On for this Section
- 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
- Download XLSX Files: Use Attached Files to practice Hands-On for this Section
- 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
