Q1. You are working on a large Excel dataset and need to find all duplicate values in column A while keeping the first occurrence intact. What is the most efficient way to do this?
A.Use =COUNTIF(A:A, A2)>1 in a helper column and filter values
B. Use Find & Replace to manually locate duplicate values
C. Use Remove Duplicates from the Data tab and delete all duplicate values
D. Apply Conditional Formatting > Highlight Duplicates to visually mark duplicate values
Answer: A
Q2. You need to extract only the domain name from an email list in column A (e.g., converting john.doe@example.com into example.com). Which formula should you use?
A.=LEFT(A2, FIND("@", A2)-1)
B. =RIGHT(A2, LEN(A2)-FIND("@", A2))
C. =MID(A2, FIND("@", A2)+1, LEN(A2))
D. =SUBSTITUTE(A2, "@", "")
Answer: C
Q3. You have a dataset formatted as a table in Excel. You need to reference the "Total Sales" column without using absolute cell references. What is the best way to do this?
A.=SUM(SalesTable[Total Sales])
B. =SUM(A:A)
C. =SUM($A$2:$A$100)
D. =SUM(Total Sales!)
Answer: A
Q4. A manager wants to analyze monthly sales trends using a PivotTable. The dataset contains a Date column with daily sales transactions. What is the best way to group sales by month?
A.Apply a filter in the Date column and select only one month at a time
B. Create a helper column using =TEXT(A2, "MMMM") and use it in the PivotTable
C. Drag the Date field into the Rows section and use the Group feature to group by Month
D. Manually enter the month names in the PivotTable and adjust the data range
Answer: C
$ 39
Reviews
There are no reviews yet.