Q31. What is the purpose of using the “Sort” feature in Excel?
a) To arrange data in a specific order, such as ascending or descending
b) To remove duplicate data entries
c) To summarize data using a pivot table
d) To change the cell font style
Show Answer
Correct Answer: a) To arrange data in a specific order, such as ascending or descending
Explanation: The “Sort” feature organizes data in a specified order, such as alphabetically or numerically, making it easier to analyze and interpret.
Q32. What does the “Paste Special” option allow you to do?
a) Paste data with specific formatting or attributes
b) Paste data from one workbook to another
c) Paste only the values from a copied range
d) Paste data without overwriting existing content
Show Answer
Correct Answer: a) Paste data with specific formatting or attributes
Explanation: “Paste Special” offers various options for pasting data, including pasting only values, formats, or formulas, providing greater control over how data is inserted.
Q33. To quickly move to the last cell with data in a column, you should press:
a) Ctrl + Home
b) Ctrl + End
c) Ctrl + Arrow Key
d) Ctrl + Page Up
Show Answer
Correct Answer: c) Ctrl + Arrow Key
Explanation: Pressing Ctrl + Arrow Key moves the cursor to the edge of the data region in the direction of the arrow, quickly navigating to the last cell with data.
Q34. How can you create a series of dates in a column?
a) Enter the first date, drag the fill handle, and select “Fill Series”
b) Use the “AutoFill” feature and choose “Date Series”
c) Enter dates manually in each cell
d) Use the “Series” function from the “Data” menu
Show Answer
Correct Answer: a) Enter the first date, drag the fill handle, and select “Fill Series”
Explanation: Entering the first date in a cell, dragging the fill handle, and selecting “Fill Series” allows you to create a sequence of dates automatically.
Q35. What is the “VLOOKUP” function used for in Excel?
a) To search for a value in the first column of a range and return a value in the same row from a specified column
b) To find the maximum value in a range of cells
c) To count the number of cells containing numbers in a range
d) To replace values in a range with new values
Show Answer
Correct Answer: a) To search for a value in the first column of a range and return a value in the same row from a specified column
Explanation: The VLOOKUP function searches for a value in the first column of a range and returns a value from a specified column in the same row, useful for data retrieval.
Q36. Which option would you use to combine data from multiple cells into one cell?
a) CONCATENATE()
b) SUM()
c) AVERAGE()
d) SPLIT()
Show Answer
Correct Answer: a) CONCATENATE()
Explanation: The CONCATENATE() function (or CONCAT in newer versions) combines data from multiple cells into a single cell, allowing you to merge text or values.
Q37. How can you make a cell’s content bold in Excel?
a) Use the “Bold” button in the Home tab
b) Right-click the cell and choose “Bold”
c) Press Ctrl + B
d) Use the “Font Style” menu
Show Answer
Correct Answer: a) Use the “Bold” button in the Home tab
Explanation: Clicking the “Bold” button in the Home tab applies bold formatting to the selected cell’s content, making the text appear thicker and more prominent.
Q38. Which of the following is NOT a valid type of chart in Excel?
a) Radar Chart
b) Histogram
c) Tree Map
d) Box Plot
Show Answer
Correct Answer: d) Box Plot
Explanation: While Radar Charts, Histograms, and Tree Maps are valid chart types in Excel, Box Plot is not directly supported; however, Box Plots can be created using other means or tools.
Q39. What is the purpose of the “SUMIF” function?
a) To sum cells based on a single condition
b) To count cells based on a single condition
c) To average cells based on a condition
d) To find the smallest number in a range
Show Answer
Correct Answer: a) To sum cells based on a single condition
Explanation: The SUMIF function adds the values in a range based on a specified condition, providing a way to total values that meet certain criteria.
Q40. What is the use of the “IF” function in Excel?
a) To test a condition and return different values based on whether the condition is true or false
b) To find the highest value in a range
c) To count the number of cells with text
d) To format cells based on values
Show Answer
Correct Answer: a) To test a condition and return different values based on whether the condition is true or false
Explanation: The IF function evaluates a condition and returns one value if the condition is true and another value if it is false, allowing for conditional logic within formulas.