Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
All Courses
  • Free Training Courses
  • AI for Your Role
  • AI & Machine Learning
  • Cloud Tech
  • Data Science
  • DevOps
  • Dashboarding/BI
  • Database
  • WebDevelopment
  • Programming & Coding
  • MS Office & Workplace Productivity
  • QA & Test Automation
  • Professional & Career Development
  • Cyber Security

Courses

  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
  • Microsoft Azure for Beginners
  • AWS Cloud for Beginners
  • Oracle SQL Fundamentals
  • Tableau Fundamentals
  • Power BI Fundamentals
Explore All Programs

Courses

  • AI Essentials
  • AI for Administrative Professionals New Launch
  • AI for Managers & Team Leads
  • AI for Data Analytics & Power BI
  • AI for Software Developers
  • AI for Database & SQL Professionals
  • AI for Project Managers
  • AI for Marketing Professionals
  • AI for Sales Professionals
  • AI for HR Professionals
  • AI for Finance Professionals
  • AI for Customer Support Professionals
  • AI for QA & Test Engineers
  • AI for IT Support & System Admins
  • AI for Cybersecurity Analysts
  • AI for Job Seekers
Explore All Programs

Courses

  • Learn Claude Basics New Launch
  • Learn Claude Advanced New Launch
  • Applied Artificial Intelligence (AI) New Launch
  • AI for Workplace Productivity
  • Azure Fundamentals with AI
  • Advanced Microsoft Azure with AI
  • AI Implications for Business Strategy
  • Mastering ChatGPT & Generative AI Tools
  • Prompt Engineering
  • Agentic AI Solutions
  • AI Product Management
  • AI for Quality Control
Explore All Programs

Courses

  • AZ-900 Azure Fundamentals
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
Explore All Programs

Courses

  • DP-100 Data Science on Azure
Explore All Programs

Courses

  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Explore All Programs

Courses

  • Business Analytics: From Data to Insights New Launch
  • Power BI Advanced
  • Data Analytics with Excel
  • Tableau Beginner
  • Tableau Data Consumer
  • Alteryx & Tableau
  • Tableau Advanced
  • Tableau Certification prep
  • Power BI Beginner
  • Cognos Analytics
Explore All Programs

Courses

  • SQL Server for Beginners
  • SQL for Analysts
  • SQL Server Advanced
  • SQL Server T-SQL Programming
  • SSIS
  • Oracle SQL for Beginners
  • Oracle PL/SQL
  • Oracle SQL Advanced
  • Big Data with Hadoop: HDFS, MapReduce & Ecosystem Tools
  • MS Access
Explore All Programs

Courses

  • Angular Frontend Development
  • Spring 5 Framework
  • Full Stack Web Development
Explore All Programs

Courses

  • Learn Python
  • Python PCEP
  • Python PCAP
  • JavaScript & jQuery
  • Java Certification
  • Python for Data Science
  • Machine Learning with Python
Explore All Programs

Courses

  • Analyzing Data with Excel New Launch
  • Workplace Digital Skills
  • Excel Beginners to Advanced Trending Now
  • Excel for Finance
  • Excel for HR
  • Workplace Computer Skills
Explore All Programs

Courses

  • Selenium QA Automation (Java)
  • Selenium QA Automation (Python)
  • API Testing
  • QA Automation with Python (Advanced)
Explore All Programs

Courses

  • Scrum Master Certification
  • Lean Six Sigma Green Belt Certification
  • Business Analyst
Explore All Programs

Courses

  • Cyber Security Foundations for Beginners
  • Computer Networking for Cybersecurity
  • Windows & Linux Security Administration
  • Ethical Hacking & Penetration Testing
  • Artificial Intelligence (AI) in Cybersecurity
Explore All Programs
  • About Us
    • OCA Skill Sprint Method
    • Meet the Founder
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

 

  • info@ohiocomputeracademy.com
  • +1 866-648-7284
  • Home
  • About Us
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Find With Us
  • Home
  • Blogs
  • MS Excel
  • Excel Basics to Advanced Practice Questions

Excel Basics to Advanced Practice Questions

Are you interested in enhancing your Microsoft Excel proficiency? This blog presents a series of Excel Basics to Advanced practice questions. The purpose of this article is to provide practice exercises that can be beneficial for readers of the Excel Basics to Advanced book as well as those who haven’t explored its contents . The questions are organized chapter-wise, starting with Excel fundamentals and gradually progressing to more advanced topics.

Feel free to contact us for MS Excel Training.

New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.

Chapter1. MS Excel Fundamentals.

Ques1. How you will customize a tab in the ribbon?

Ques2. What option should be selected to keep specific area of the worksheet visible while scrolling vertically or horizontally.

Ques3. Refer to the dataset below, what options should be selected to view only the data where Segment = Home Office

Practice dataset displaying Segment, Region, and Product ID.

Chapter2. Formatting in Excel.

Ques4. Refer to the Sales values below. What option should be selected to display Sales > 500 in yellow. The resulting values should appear the way it is shown in the output.

Sample Sales data

Output. After implementing the solution, the output should appear like the one below:

Output of the Sales data after performing conditional formatting

Ques5. Refer to the Sales and Profit amounts given below. Display a scorecard to depict Low, Medium, and High Sales. Also display the Profit > 40% in Green. Your solution should match the provided output.

Sample Region and Sales data

Output. After implementing the solution, the output should appear like the one below:

Ques6. Refer to the dataset below. Color the Region in Yellow where Sales > 500.

Output. After implementing the solution, the output should appear like the one below:

Chapter3. Introduction to Formulas.

Ques7. When Autofill is performed, does Excel uses Relative referencing or Absolute referencing?

Ques8. Refer to the dataset below. The data contains Courses, Enrolment, Fee, Discount and Final fee. If enrolment occurs on the “Same Day”, an early bird discount of 10% (Cell D1) is applied.

Discount and Final Fee need to be calculated.

To calculate Discount, a formula is written in Cell D4 =IF(B4=”Same Day”,C4*D1,0). This formula is then auto filled in all the subsequent cells of column D.

This formula produces an error. (see below)

Explain why this error has occurred and how to fix this error. The correct output should appear like the one shown below:

Chapter4. Logical Functions.

Ques9. In what scenarios Logical functions are used in Excel.

Ques10. Our dataset contains Courses, Enrolments, and Timings. Each course has a different timing and it should be displayed for each of the course using Nested IF formula.

Excel timings are 10am – 12pm, Tableau timings are 12pm-2pm, AWS timings are 2pm-4pm, Programming timings are 4pm – 6pm, and Oracle timings are 6pm-8pm.

Write a Nested IF formula in Cell C2 and autofill it to get the timings for all the other courses. The output should match the one shown below:

write the same formula using the IFS function and provide comments on which one is easier to use and understand, Nested IF or IFS.

Chapter5. Text Functions.

Ques11. Refer to the dataset below. It contains Enrolment ID, which is a combination of Course ID, Student Name, and Date.

In the Course ID column, display four characters of Course ID, In column Student Name display six characters of Student Name, and in the Date column display the Dates. In column Course Date, combine Course ID and Date. In the Length of Name column, calculate the Length of Student Names.

Output. After implementing the solution, the output should appear like the one below:

Chapter6. DateTime Functions.

Ques12. Refer to the dataset below.

Add 7 days to the above date, add 4 months to the date, and calculate the Number of Working days between two date and Date + 7 columns.

Output. After implementing the solution, the output should appear like the one below:

Chapter7. Mathematical Functions.

Ques13. Refer to the Region and Sales values in the dataset below. Calculate the count of cells where Region = West and find the sum of Sales where Region = West.

The output should be as shown in the figure below i.e., Count is 5 and sum of Sales of $1,655.52:

Chapter8. Lookup and Reference.

Ques14. Refer to the dataset below, which comprises of two ranges. One range includes Courses, Enrollment, and an empty column for Instructors. The other range contains Courses and their corresponding Instructors. Write the VLOOKUP function to populate the values in the empty Instructor column by searching for values in the second range.

Output. After implementing the solution, the output should appear like the one below:

Ques15. Refer to the dataset below. Which function should be employed to find the Course associated with the Instructor = Smith?

The dataset and the output are provided below:

Chapter9. Pivot Tables and Charts.

Ques16. Refer to the dataset below. Create a Pivot table and chart as shown in the output.

Output. After implementing the solution, the output should appear like the one below:

Chapter10. Excel Tables.

Ques17. What is the advantage of using an Excel Table.

Ques18. What is the difference between Subtotal and Sum functions.

Chapter11. Introduction to Excel Macros.

Ques19. In which scenarios Excel Macros are used.

Ques20. How to modify the visual basic code for Macros

Ready to Take Your Excel Skills to the Next Level?

Go beyond practice questions with hands-on Excel training at Ohio Computer Academy. Learn Excel from beginner to advanced, including formulas, functions, PivotTables, and data analysis, through in-person classes in Dublin, Ohio, or live online instructor-led training.

Explore Our Excel Basics to Advanced Training Course

Like
Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.

0 Comments

Add Your Comment

Post a Comment

Required fields are marked *

✅ Thanks for adding your comment! It will appear after moderation.

0 Comments

Related Blogs
View All Blogs
Compare Two Columns in Excel with MATCH and ISNUMBER
Read More
Why MS Excel is important for an IT novice
Read More
MS Excel Practice Questions
Read More
Blog Gallery
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

Registered with the Ohio State Board of Career Colleges and Schools — School Registration No. 2395

About Us
  • Contact Us
  • Our Story
  • Training Gallery
  • Reviews
  • Books
  • Greater Columbus Training Center
Trainings/Services
  • Course Categories
  • Learning Paths
  • Frequently Asked Questions
  • AI Advantage
Contact Us
  • Phone:+1 866-648-7284
  • E-mail: info@ohiocomputeracademy.com
  • Address:

    Dublin, Ohio
    5900 Sawmill Road, Suite # 150, Dublin, OHIO 43017 USA

Thank you
Failed
Free Training Courses
  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
AI Courses
  • Claude Basics
  • Claude Advanced
  • AI for Workplace Productivity
  • Prompt Engineering
  • Agentic AI Solutions
  • AI for Quality Control
Cloud Tech
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Technical Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
DevOps
  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Dashboarding/BI
  • Tableau Beginner
  • Power BI Beginner
  • Data Analytics with Excel
Database
  • Oracle SQL for Beginners
  • SQL for Analysts
  • SQL Server for Beginners
MS Office & Workplace Productivity
  • Workplace Digital Skills
  • Excel for Finance
  • Excel for HR
  • Excel Beginners to Advanced
  • Workplace Computer Skills
Learning Hub
  • Begin Your IT Career
  • Generative AI & Workplace Productivity Foundations
  • Claude AI Learning Path
  • Data Visualization Foundations
  • Data Analytics Career Path
  • AI for Business & Data Applications
  • Programming Foundations & Development Path

© 2026 Ohio Computer Academy. All rights reserved.

  • Privacy
  • Terms & Conditions