Q41. What does the ‘IF’ function do in a spreadsheet?
a) Performs a logical test and returns one value if true and another if false
b) Adds up values in a range
c) Finds the minimum value in a range
d) Counts the number of cells with text
Show Answer
Correct Answer: a) Performs a logical test and returns one value if true and another if false
Explanation: The ‘IF’ function performs a logical test and returns one value if the condition is true and another value if the condition is false.
Q42. How can you create a chart from a range of data?
a) Select the data range and use the ‘Insert Chart’ option
b) Use the ‘Create Chart’ option from the Data menu
c) Manually draw a chart
d) Import a chart from another file
Show Answer
Correct Answer: a) Select the data range and use the ‘Insert Chart’ option
Explanation: To create a chart, select the data range and use the ‘Insert Chart’ option, which allows you to choose from various chart types to visualize the data.
Q43. What does the ‘COUNTIF’ function do in a spreadsheet?
a) Counts the number of cells that meet a specific condition
b) Calculates the total of a range of cells
c) Finds the maximum value in a range
d) Counts all cells with numeric values
Show Answer
Correct Answer: a) Counts the number of cells that meet a specific condition
Explanation: The ‘COUNTIF’ function counts the number of cells that meet a specific condition, allowing for conditional counting within a range.
Q44. How can you format a cell to display a date?
a) Use the ‘Number Format’ option and select ‘Date’
b) Manually enter date formats
c) Use the ‘Custom Format’ option
d) Both a and c
Show Answer
Correct Answer: d) Both a and c
Explanation: To format a cell to display a date, you can use the ‘Number Format’ option and select ‘Date,’ or use the ‘Custom Format’ option to enter specific date formats.
Q45. How do you use the ‘ROUND’ function in a spreadsheet?
a) To round a number to a specified number of decimal places
b) To find the average of a range of numbers
c) To count the number of cells with numeric data
d) To calculate the total of a range of cells
Show Answer
Correct Answer: a) To round a number to a specified number of decimal places
Explanation: The ‘ROUND’ function rounds a number to a specified number of decimal places, useful for controlling the precision of numerical data.
Q46. How do you change the font size of text in a cell?
a) Use the ‘Font Size’ option from the Home tab
b) Use the ‘Format Cells’ dialog box
c) Manually adjust text size using drag handles
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: You can change the font size of text in a cell using the ‘Font Size’ option from the Home tab or the ‘Format Cells’ dialog box.
Q47. What is the function of the ‘TEXT’ function in a spreadsheet?
a) Converts a numeric value to text in a specified format
b) Finds the length of a text string
c) Searches for text within a cell
d) Counts the number of text entries in a range
Show Answer
Correct Answer: a) Converts a numeric value to text in a specified format
Explanation: The ‘TEXT’ function converts a numeric value to text in a specified format, allowing for customized display of numbers as text.
Q48. How can you hide a column in a spreadsheet?
a) Select the column, right-click, and choose ‘Hide’
b) Use the ‘Hide’ option from the Format menu
c) Use the ‘Group’ feature
d) Both a and c
Show Answer
Correct Answer: d) Both a and c
Explanation: You can hide a column by selecting the column, right-clicking and choosing ‘Hide,’ or by using the ‘Group’ feature to collapse the column.
Q49. What is the purpose of the ‘SPLIT’ function in a spreadsheet?
a) To divide text into separate cells based on a delimiter
b) To split data into multiple sheets
c) To divide numerical values into specified ranges
d) To create a split chart from a dataset
Show Answer
Correct Answer: a) To divide text into separate cells based on a delimiter
Explanation: The ‘SPLIT’ function divides text into separate cells based on a specified delimiter, useful for separating data into multiple columns.
Q50. How can you quickly find the minimum value in a range of cells?
a) Use the ‘MIN’ function
b) Use the ‘AutoSum’ feature
c) Sort the data in ascending order
d) Use the ‘Find’ function
Show Answer
Correct Answer: a) Use the ‘MIN’ function
Explanation: The ‘MIN’ function quickly finds the minimum value in a range of cells, providing the lowest value in the dataset.