Verdexes
Hello Excel Fanatics! Here to help you become Instantly More Effective With Excel:
This channel has 100+ videos on Microsoft Excel spreadsheet tutorials, functions and tips - Vlookup, Sumifs, pivot tables, you name it. All the tools you need to make those data-driven decisions.
Origin: Did you know, in geometry, a vertex (or vertexes) is/are a point where two or more curves, lines, or edges meet? Well, a pleasure to meet you and welcome to Verdexes - Happy Learning!
If you buy from the Verdexes Merch Store, know that 25% of profits go towards the Wounded Warrior Project
If this sounds like something you fancy, subscribe and become a Fanatic!
#exceltips #excelpractice #exceltutorial #spreadsheets #excelfunctions #msexcel #excelformulas
Verdexes
You have a dataset with:
Column A → Product Name
Column B → Category
Column C → Revenue
You want to return the product name with the highest revenue within the category entered in cell F2.
Which formula correctly returns the product name?
#excelquiz #excelhelp #spreadsheets
2 months ago | [YT] | 2
View 0 replies
Verdexes
You have a dataset with:
Column A → Employee Name
Column B → Department
Column C → Salary
You want to return the highest salary in the department listed in cell F2
#excelquiz #excelhelp #spreadsheets
4 months ago | [YT] | 1
View 0 replies
Verdexes
You have a dataset with:
Column A → Customer Name
Column B → Region
Column C → Sales Amount
You want to calculate the total sales for the region in cell F2, but only for sales greater than 1,000 - which formula correctly does this?
#excelquiz #excelhelp #spreadsheets
4 months ago | [YT] | 1
View 0 replies
Verdexes
You have a list of transaction amounts in column B.
Some transactions are negative (refunds).
You want to calculate the total of only the positive values.
Which formula should you use?
#excelhelp #excelquiz #spreadsheets
4 months ago | [YT] | 1
View 0 replies
Verdexes
You have a list of dates in column A.
You want to flag all dates that fall in the new year (2026) with the text "New Year" and all others as "Prior Year".
Which formula should you use in cell B2?
#excelhelp #exceltrivia #spreadsheets
6 months ago | [YT] | 1
View 0 replies
Verdexes
6 months ago | [YT] | 1
View 0 replies
Verdexes
You have a list of dates in column A.
You want to return today’s date and automatically update it every time the file is opened.
Which formula should you use?
#excelquiz #excelhelp #interviewquestions
6 months ago | [YT] | 1
View 0 replies
Verdexes
You have a list of sales amounts in column B.
You want to calculate the total sales for values greater than 5,000.
Which formula correctly does this?
7 months ago | [YT] | 1
View 0 replies
Verdexes
Which formula should you use? You have a dataset where:
Column A = Employee ID
Column B = Department
Column C = Salary
You need to return the average salary for the department entered in cell E2.
#excelhelp #spreadsheets #excelquiz
7 months ago | [YT] | 1
View 0 replies
Verdexes
You have numbers in column B (cells B2:B20) - You want to count how many of those numbers are greater than 50.
Which formula should you use?
#excelquiz #excelhelp #spreadsheets
7 months ago | [YT] | 1
View 0 replies
Load more