Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data: Sl Name Surname Position Full Name Age Annual Salary 2 John Smith Manager John Smith 35 85,000 3 Jimmy Michaels Salesperson Jimmy Michaels 26
| Data: | ||||||
| Sl | Name | Surname | Position | Full Name | Age | Annual Salary |
| 2 | John | Smith | Manager | John Smith | 35 | 85,000 |
| 3 | Jimmy | Michaels | Salesperson | Jimmy Michaels | 26 | 60,000 |
| 4 | Michelle | Levine | Manager | Michelle Adams | 37 | 80,000 |
| 5 | Levi | Johnson | Tech | Levi Johnson | 40 | 75,000 |
| 6 | Jenna | Masterson | Salesperson | Jenna Masterson | 26 | 60,000 |
| Questions: | Marks | |
| Find the age of below people by using vlookup | 6 | |
| Name | Age | |
| John | ||
| Michelle | ||
| Jimmy | ||
| Jenna | ||
| Levi | ||
| How many managers and Tech working in this organization. Find by using countifs | 5 | |
| Position | Number | |
| Tech | ||
| Manager | ||
| Find position wise total annual salary by using sumifs | 6 | |
| Position | Total Annual Salary | |
| Manager | ||
| Salesperson | ||
| Tech | ||
| Find the average salary of salesperson by using average formula | 2 | |
| Average Salary of salesperson: | ||
NB: DO SHOW THE FORMULAS YOU HAVE USED
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Municipal Budget Crunch A Handbook For Professionals
Authors: Roger L. Kemp
1st Edition
0786463740, 978-0786463749
