NEW
Font size
WorksheetsEDA Viva Questions
Total questions: 40
Worksheet time: 40mins
Which of the following is the correct way to ensure the ID column acts as a primary key in Excel?
Apply Conditional Formatting
Sort IDs in ascending order
Apply a filter
Use Remove Duplicates on ID
Which feature is used to remove duplicate rows from a dataset in Excel?
Sort
Data Validation
AutoSum
Remove Duplicates
When importing a .csv file into Excel, which delimiter is commonly used?
Semicolon
Space
Colon
Comma
Which tool allows you to copy the style of one cell to another?
Conditional Formatting
Data Validation
Fill Handle
Format Painter
If you want dates in the format 28-Jul-2025, which option should be chosen?
General → Number Format
Text Format
Time Format
Custom Date Format (DD-MMM-YYYY)
Which of the following formulas correctly calculates the average of cells B2 to B21?
=MEAN(B2:B21)
=AVG(B2:B21)
=SUM(B2:B21)/B2
=AVERAGE(B2:B21)
What will the formula =IF(B2>=50, "Pass", "Fail") return if the value in B2 is exactly 50?
Fail
Error
Blank
Pass
In Conditional Formatting, if you want to highlight duplicate values, which is correct?
Home → Sort & Filter → Filter → Duplicates
Data → Remove Duplicates → Duplicate Highlight
Insert → Conditional Formatting → Duplicate
Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values
Suppose you want to automatically generate IDs like URK24CS1201, URK24CS1202… Which Excel formula can be used?
=TEXT(ROW(A1),"0000")
=ROW(A1)&"URK24CS"
=CONCAT("URK24CS",ROW(A1))
="URK24CS"&TEXT(ROW(A1)+1200,"0000")
Which of the following best explains the purpose of applying “Number Formatting” in Excel?
To change the data itself
To remove decimal values permanently
To sort values in ascending order
To standardize the display format of numeric data (currency, percentage, fraction, etc.)
Which of the following functions can be used to classify sales into “High” or “Low” based on a condition?
SUMIF
COUNTIF
AVERAGEIF
IF
Which function is used when multiple conditions must all be true?
OR
NOT
IFS
AND
The formula =COUNTIF(G2:G14,">2000") will:
Count sales less than 2000
Count cells equal to 2000
Sum sales greater than 2000
Count sales greater than 2000
Which function is used to return the minimum value based on a condition?
MIN
SMALL
IFS
MINIFS
If you want to assign a grade based on multiple numeric conditions like 90–100 = A, 80–89 = B, you should use:
IF
SWITCH
COUNTIFS
IFS
Which function will correctly calculate the average price in the East region when sales > 2000?
=AVERAGEIF(G2:G14, ">2000")
=AVERAGE(F2:F14, G2:G14)
=SUMIFS(F2:F14, B2:B14,"East", G2:G14, ">2000")
=AVERAGEIFS(F2:F14, B2:B14,"East", G2:G14, ">2000")
Which of the following is the correct use of XLOOKUP?
=XLOOKUP("Sarah", G2:G14, C2:C14)
=XLOOKUP(G2:G14, "Sarah", C2:C14)
=XLOOKUP(C2:C14, G2:G14, "Sarah")
=XLOOKUP("Sarah", C2:C14, G2:G14)
The formula =CORREL(E2:E14,G2:G14) is used to:
Find covariance
Find variance
Find regression line
Find correlation between Units and Sales
What will =SWITCH(B2,"East",1,"West",2,"North",3,"South",4) return if B2 = "South"?
3
South
Error
4
If you want to find the 90th percentile of unit prices in F2:F14, which formula should be used?
=RANK.EQ(F2:F14,0.9)
=PERCENTILE.INC(F2:F14,0.9)
=LARGE(F2:F14,0.9)
=PERCENTILE.EXC(F2:F14,0.9)
Which type of chart is most suitable to compare sales of different products in the same month?
Line Chart
Scatter Chart
Pie Chart
Column Chart
Which chart type is best used to show parts of a whole (percentage contribution)?
Area Chart
Bar Chart
Histogram
Pie Chart
If you want to represent data distribution (e.g., frequency of test scores), which chart should you use?
Line Chart
Bubble Chart
Combo Chart
Histogram
Which chart is used to track project schedules and tasks over time?
Line Chart
Area Chart
Bubble Chart
Gantt Chart
Which of the following chart types allows visualization of the relationship between two numerical variables?
Bar Chart
Pie Chart
Column Chart
Scatter Chart
What does the size of bubbles represent in a Bubble Chart?
Categories
Time
Data labels
Third numeric variable
In a Combo Chart (Combination Chart), you can combine:
Only two line charts
Only scatter and histogram
Bar chart with pie chart
Line chart with column chart
Which chart would be the most appropriate to show the trend of sales over 12 months?
Pie Chart
Histogram
Scatter Chart
Line Chart
If you want to highlight both magnitude and trend over time (like cumulative rainfall), which chart is best?
Scatter Chart
Gantt Chart
Bubble Chart
Area Chart
Which of the following correctly explains the difference between a Bar Chart and a Column Chart?
Both show data horizontally
Column shows percentages; Bar shows counts
Bar chart is only for categorical data
Column is vertical; Bar is horizontal
Which of the following is the correct formula to fetch an employee’s salary from a Salary table using Employee ID?
=VLOOKUP(A2, SalaryTable!A:B, 2, TRUE)
=LOOKUP(A2, SalaryTable!A:B, 2)
=VLOOKUP(SalaryTable!A:B, A2, 2, FALSE)
=VLOOKUP(A2, SalaryTable!A:B, 2, FALSE)
In VLOOKUP, when should you use the argument TRUE instead of FALSE?
When exact match is required
When fetching text values only
When fetching numeric values only
When approximate match is allowed
Which tool in Excel allows you to combine sales data from multiple monthly files into one table?
PivotTable
Format Painter
Data Validation
Power Query
Which of the following is NOT a step in cleaning data using Power Query?
Remove duplicates
Trim text and change case
Replace null values
Use AutoSum
Which function can consolidate sales data across sheets named North, South, and East?
=AVERAGE(North:East!B2)
=COUNT(North:East!B2)
=VLOOKUP(North:East!B2)
=SUM(North:East!B2)
If a student has scored 85 marks and a grade table (90=A, 80=B, 70=C) is used with =VLOOKUP(85, GradeTable!A:B, 2, TRUE), what grade will be returned?
A
C
Error
B
In a product price table, which formula correctly calculates the final price after discount?
=B2 * C2 + D2
=B2 * (1 - D2)
=C2 * (1 - B2)
=B2 * C2 * (1 - D2)
Power Query “Merge Queries” is conceptually similar to which database operation?
Sorting
Filtering
Grouping
Joining tables
Which 3D formula would you use to calculate the average monthly expense for categories across sheets named Jan, Feb, Mar?
=SUM(Jan:Mar!B2)
=COUNT(Jan:Mar!B2)
=IF(Jan:Mar!B2,"Avg")
=AVERAGE(Jan:Mar!B2)
In a company performance dashboard with 3 branches, which formula correctly gives the maximum number of customers across branches?
=SUM(Branch1:Branch3!B4)
=AVERAGE(Branch1:Branch3!B4)
=VLOOKUP(Branch1:Branch3!B4)
=MAX(Branch1:Branch3!B4)
