Q51. How can you use the ‘HLOOKUP’ function in a spreadsheet?
a) To search for a value in the top row of a table and return a value in the same column from a specified row
b) To find the highest value in a range
c) To count the number of cells with text data
d) To sort data in descending order
Show Answer
Correct Answer: a) To search for a value in the top row of a table and return a value in the same column from a specified row
Explanation: The ‘HLOOKUP’ function searches for a value in the top row of a table and returns a value from the same column in a specified row.
Q52. What is the purpose of the ‘Transpose’ feature in a spreadsheet?
a) To switch rows and columns in a selected range
b) To rotate the data within a cell
c) To change the font style of the text
d) To merge multiple cells into one
Show Answer
Correct Answer: a) To switch rows and columns in a selected range
Explanation: The ‘Transpose’ feature switches rows and columns in a selected range, allowing you to rearrange data for different views.
Q53. How can you apply a custom number format to a cell?
a) Use the ‘Custom Format’ option from the Format Cells dialog box
b) Use the ‘Number Format’ options from the Home tab
c) Manually enter the format in the cell
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: You can apply a custom number format to a cell using the ‘Custom Format’ option from the Format Cells dialog box or by selecting from the ‘Number Format’ options in the Home tab.
Q54. How do you create a dynamic chart that updates automatically?
a) Use a data range that expands with new data
b) Manually update the chart data
c) Copy and paste the chart into a new sheet
d) Use static data in the chart
Show Answer
Correct Answer: a) Use a data range that expands with new data
Explanation: To create a dynamic chart that updates automatically, use a data range that expands with new data, allowing the chart to reflect changes in the dataset.
Q55. How do you add a trendline to a chart?
a) Select the chart, go to ‘Chart Tools,’ and choose ‘Add Trendline’
b) Manually draw a line on the chart
c) Use the ‘Trendline’ option from the Format menu
d) Add a line shape to the chart
Show Answer
Correct Answer: a) Select the chart, go to ‘Chart Tools,’ and choose ‘Add Trendline’
Explanation: To add a trendline to a chart, select the chart, go to ‘Chart Tools,’ and choose ‘Add Trendline,’ which provides options for fitting a trendline to the data.
Q56. How do you use the ‘MATCH’ function in a spreadsheet?
a) To find the position of a value within a range
b) To match data between two different ranges
c) To combine data from multiple cells
d) To calculate the total of a range of cells
Show Answer
Correct Answer: a) To find the position of a value within a range
Explanation: The ‘MATCH’ function finds the position of a value within a range, returning the relative position of the value in the dataset.
Q57. What is the purpose of the ‘DATE’ function in a spreadsheet?
a) To create a date value from individual year, month, and day values
b) To find the number of days between two dates
c) To calculate the age of a person based on their birthdate
d) To format a cell as a date
Show Answer
Correct Answer: d) Pottery
Explanation: Inscriptions, coins, and manuscripts are all sources of Ancient Indian history, but pottery is not considered a significant source.
Q58. How can you add a comment to a cell?
a) Right-click the cell and select ‘Insert Comment’
b) Use the ‘Add Comment’ option from the Home tab
c) Enter text directly into the cell
d) Use the ‘Comments’ feature from the Review tab
Show Answer
Correct Answer: a) Right-click the cell and select ‘Insert Comment’
Explanation: To add a comment to a cell, right-click the cell and select ‘Insert Comment,’ allowing you to add notes or explanations to the cell.
Q59. How do you create a hyperlink in a cell?
a) Right-click the cell and select ‘Hyperlink’
b) Use the ‘Insert Hyperlink’ option from the Insert tab
c) Manually type a URL into the cell
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: You can create a hyperlink in a cell by right-clicking the cell and selecting ‘Hyperlink,’ or by using the ‘Insert Hyperlink’ option from the Insert tab.
Q60. What is the function of the ‘CHART’ tool in a spreadsheet?
a) To create various types of charts for data visualization
b) To manage chart data
c) To format chart elements
d) To delete a chart from a worksheet
Show Answer
Correct Answer: a) To create various types of charts for data visualization
Explanation: The ‘CHART’ tool allows you to create various types of charts for visualizing data, helping to present data trends and comparisons effectively.