SkiDev Inc. SkillTrack

Track your skills. Build your roadmap

SkiDev Inc. Quiz For Excel

SkiDev Excel Quiz – Unlock Opportunities!

Test your skills in Excel, SQL, BI tools & more!
Instant quiz report | Free career counseling | Get noticed by our hiring team
Take the quiz now!

Page 1 of 30

You are copying the formula =$B2*C$2 from cell D2 to E3. What will the resulting formula in E3 be? =$B2*C$2 =$B3*D$2 =$B3*C$2 =C3*C$2 =B3*D2

Page 2 of 30

You’re using the formula =IFERROR(VLOOKUP(A2, Table1, 2, FALSE), "Not Found"). What happens if A2 contains a value not in Table1? It returns #N/A It returns "Not Found" It returns 0 It returns FALSE It breaks the formula

Page 3 of 30

You want to summarize sales by region and filter for only the “East” and “West” regions. What is the most efficient way? Use VLOOKUP to filter the data Apply a manual filter to the source data Add a filter field in the Pivot Table and check "East" and "West" Use conditional formatting to highlight regions Create multiple pivot tables for each region

Page 4 of 30

What is the correct syntax to return a value from column C where column A matches the value in E2? =VLOOKUP(E2, A:C, 3, FALSE) =INDEX(C:C, MATCH(E2, A:A, 0)) =MATCH(E2, A:A, 0) =INDEX(A:A, MATCH(E2, C:C, 0)) =IFERROR(A2, C2)

Page 5 of 30

In Power Query, which action will combine data from multiple Excel files in the same folder into one table? Use VLOOKUP in each file Manually copy and paste data Use “Append Queries” after combining from Folder Use Data Validation Use IFERROR with external references

Page 6 of 30

You have a column with values like “ John ”. What is the best formula to clean this up? =CLEAN(A2) =TRIM(A2) =LEFT(A2,4) =SUBSTITUTE(A2, " ", "") =MID(A2,2,3)

Page 7 of 30

To highlight cells in column B that are greater than the average of column B, what formula should be used in Conditional Formatting? =B2>AVERAGE($B$2:$B$100) =AVERAGE(B:B)>B2 =IF(B2>AVERAGE(B:B),TRUE,FALSE) =B2>B3 =AVERAGE(B:B)=TRUE

Page 8 of 30

Which feature makes an Excel dashboard interactive, allowing users to filter pivot chart data dynamically? Conditional Formatting Data Validation Slicer Freeze Panes Filter Function

Page 9 of 30

What is the best method to keep an Excel table automatically updated from a connected external CSV file? Manually open and paste data Use TEXTJOIN to link CSV data Use Power Query with “Refresh” option Use CONCATENATE Use IFERROR(VLOOKUP(...))

Page 10 of 30

You want to determine what value in cell B2 will make the formula =B2*C2 equal 10. What Excel tool should you use? Data Validation Goal Seek Solver Scenario Manager Conditional Formatting

Page 11 of 30

You want to extract all unique department names from column A. Which formula gives you a spill range with distinct values? =SORT(A:A) =UNIQUE(A:A) =INDEX(A:A, MATCH(0, COUNTIF($B$1:B1, A:A), 0)) =FILTER(A:A, A:A"") =VLOOKUP(A:A, A:A, 1, FALSE)

Page 12 of 30

In Power Query, which step would you use to split a full name column (e.g., “John Doe”) into first and last name? Use CONCATENATE Apply "Split Column" by Delimiter Use LEFT and FIND formulas Use Text to Columns in Excel Use IFERROR to separate values

Page 13 of 30

You want to find the sales value from column C where Region="West" and Product="Shoes". Which formula will work? =VLOOKUP("West", A:C, 3, FALSE) =INDEX(C:C, MATCH(1, (A:A="West")*(B:B="Shoes"), 0)) =XLOOKUP("West", A:A, C:C) =IF(A:A="West", INDEX(C:C, MATCH(B:B, "Shoes", 0)), "") =SUMIFS(C:C, A:A="West", B:B="Shoes")

Page 14 of 30

Which DAX function would you use in Power Pivot to calculate cumulative sales? SUM(Sales) CALCULATE(SUM(Sales), FILTER(...)) RANKX(Sales) LOOKUPVALUE(Sales) RELATED(Sales)

Page 15 of 30

Which chart is most eƯ ective for visualizing monthly trends across multiple product categories? Pie chart Stacked column chart Scatter plot Gauge chart Donut chart

Page 16 of 30

You want to create a dropdown in Excel where City options change based on the selected State. What should you use? VLOOKUP INDIRECT with Named Ranges Conditional Formatting Data Validation without helper data FILTER function

Page 17 of 30

Why use named ranges in dashboard design? To reduce Excel size To eliminate formula use To simplify formulas and improve reusability To enable multi-user access To export data faster

Page 18 of 30

What does the Scenario Manager allow you to do in Excel? Automate data cleaning Visualize formulas Evaluate multiple input sets and compare outputs Refresh external connections Import CSV data

Page 19 of 30

You convert a range to a Table (Ctrl + T). What benefit does this provide in formulas? Reduces formula errors by locking cells Applies absolute referencing Allows structured references like Table1[Sales] Hides unused rows Converts formulas to macros

Page 20 of 30

You want to add a drop-down in your Excel dashboard that changes charts dynamically. Which control should you use? Data Validation only Pivot Filter Slicer Form Control Combo Box linked to named ranges Developer Button

Page 21 of 30

You need to extract a dynamic 2D range that starts from cell A1 and spans a number of rows in B1 and columns in C1. What formula will you use? =OFFSET(A1, B1, C1) =INDEX(A1#, B1, C1) =INDEX(A1:Z100, SEQUENCE(B1), SEQUENCE(C1)) =CHOOSE({1,2}, A1:A10, B1:B10) =INDIRECT("A1:C10")

Page 22 of 30

In Power Query M language, how do you add a new column that returns "Senior" if Age > 40, "Mid" if between 30-40, otherwise "Junior"? =IF(Age>40, "Senior", "Mid", "Junior") =if [Age]>40 then "Senior" else if [Age]>30 then "Mid" else "Junior" =IF([Age]>40, "Senior", IF([Age]>30, "Mid", "Junior")) =SWITCH([Age], >40, "Senior", >30, "Mid", "Junior") =IIF([Age]>40, "Senior", "Junior")

Page 23 of 30

Which Excel feature enables recursive/iterative calculations, such as compounding interest across rows? Goal Seek Circular Reference with iterative calculation enabled Data Validation Flash Fill XLOOKUP with spill ranges

Page 24 of 30

Which DAX formula correctly calculates previous month's sales in a measure? CALCULATE(SUM(Sales[Amount]), MONTH(TODAY()) - 1) PREVIOUSMONTH(Sales[Date]) CALCULATE(SUM(Sales[Amount]), PREVIOUSMONTH(Sales[Date])) TOTALYTD(Sales[Amount], Sales[Date]) RANKX(ALL(Sales[Date]), Sales[Amount])

Page 25 of 30

In a dashboard, to show a KPI card that turns red if actual < target, which combination should be used? IF(A2<B2, "Red", "Green") + conditional formatting =VLOOKUP(A2, B2, 2, FALSE) KPI icon set with default settings Manual cell fill Data Validation + MIN formula

Page 26 of 30

You want to retrieve the department head using Region and Team from a table. What's a valid advanced method? =XLOOKUP(Region, Table[Region], Table[Head]) =INDEX(Table[Head], MATCH(1, (Table[Region]=F2)*(Table[Team]=F3), 0)) =VLOOKUP(F2&F3, Table[Region]&Table[Team], 3, FALSE) =FILTER(Table[Head], Table[Region]=F2) =CHOOSE(Table[Team], Table[Head])

Page 27 of 30

Which combination allows building a multi-year sales dashboard with slicers for year and timeline filters for month? Two slicers on regular ranges Timeline and slicer connected to Pivot Table from data model Conditional formatting on years Pivot Table from normal range with filters Data Validation lists + helper rows

Page 28 of 30

To pull live exchange rates from an API into Excel for analysis, which method is appropriate? Flash Fill from sample rates Import from Web using Power Query INDIRECT referencing API Data Validation with external file VLOOKUP from a CSV export

Page 29 of 30

You’ve defined a named formula: Top5 =LARGE(Sales, {1,2,3,4,5}). What does =SUM(Top5) return? An error Sum of all sales Sum of bottom 5 values Sum of top 5 values Only the top 1 value

Page 30 of 30

You want to fetch total from a sheet whose name is in A1. Cell B1 contains the address of the total cell (like "B10"). Which formula works? =INDIRECT(A1&B1) =INDIRECT("'"&A1&"'!"&B1) =VLOOKUP(B1, A1, 1, FALSE) =GETPIVOTDATA(A1, B1) =CHOOSE(A1, B1)

Please provide your contact information to proceed.

Select

Consent *

Yes, I agree with the privacy policy and terms and conditions.

Please do not fill in this field.

Frequently asked questions

Q. Who should take the SkiDev Inc. Quiz (Excel)?

This quiz is designed for aspiring and experienced data analysts who want to assess their analytical skills, problem-solving abilities, and industry knowledge.

Q. How difficult is the quiz?

The quiz ranges from moderate to advanced difficulty, challenging both beginners and experienced professionals in data analytics.

Q. How long does the quiz take to complete?

On average, the quiz takes around 30-45 minutes to complete, depending on your speed and familiarity with the topics.

Q. Will I receive a certificate or score report?Will I receive a certificate or score report?

Yes. Once you complete the quiz, you will receive:

A detailed performance report (in the class)
A personalized growth roadmap (in the class)
Access to one-on-one doubt-clearing sessions with working professionals currently handling live projects, to clarify any concepts or approaches you struggled with.

Q. What is the structure and marking scheme of the quiz?