#1
Which function is used to calculate the average of a range of cells in Excel?
AVERAGE
ExplanationCalculates the average value of a specified range.
#2
Which chart type in Excel would you use to show trends over time?
Line chart
ExplanationDisplays trends or changes over time using a line connecting data points.
#3
In Excel, what function would you use to find the highest value in a range of cells?
MAX
ExplanationReturns the highest value in a specified range.
#4
Which chart type in Excel would you use to compare values across different categories?
Bar chart
ExplanationDisplays data using horizontal bars to compare values across categories.
#5
What is the purpose of the IF function in Excel?
To check if a condition is true or false
ExplanationEvaluates a condition and returns one value if true and another if false.
#6
In Excel, how can you create a formula that adds the values in cells A1 and B1?
=A1 + B1
ExplanationAdds the values in cells A1 and B1 using a formula.
#7
What does the function VLOOKUP do in Excel?
It returns a value from a vertical lookup table based on a matching criterion
ExplanationRetrieves a value from a specified range based on a given lookup criterion.
#8
What is the purpose of a pivot table in Excel?
To analyze and summarize data
ExplanationFacilitates the analysis and summarization of data in a structured format.
#9
What is the purpose of the CONCATENATE function in Excel?
To combine text from two or more cells into one cell
ExplanationJoins text from multiple cells into a single cell.
#10
What does the function COUNTIF do in Excel?
It counts the number of cells that meet a specific condition
ExplanationCounts cells that satisfy a given condition.
#11
In Excel, how can you freeze panes to keep rows and columns visible while scrolling?
Go to the View tab and click on Freeze Panes
ExplanationFreezes rows and columns to keep them visible when scrolling through a large worksheet.
#12
What does the function SUMIF do in Excel?
It sums the values in a range that meet a specific condition
ExplanationAdds up values in a range based on a specified condition.