Q31. How can you format cells to display currency values?
a) Use the ‘Number Format’ option from the Home tab and select ‘Currency’
b) Manually add currency symbols to each cell
c) Use the ‘Custom Format’ option and enter currency symbols
d) Both a and c
Show Answer
Correct Answer: d) Both a and c
Explanation: To format cells to display currency values, you can use the ‘Number Format’ option from the Home tab and select ‘Currency,’ or use the ‘Custom Format’ option to enter currency symbols.
Q32. How do you remove a border from a cell?
a) Use the ‘Borders’ option from the Format menu and select ‘None’
b) Right-click the cell and choose ‘Remove Border’
c) Use the ‘Clear Formatting’ option
d) Manually delete the border lines
Show Answer
Correct Answer: a) Use the ‘Borders’ option from the Format menu and select ‘None’
Explanation: To remove a border from a cell, use the ‘Borders’ option from the Format menu and select ‘None,’ which clears the border formatting.
Q33. What is the purpose of the ‘Cell Referencing’ feature in formulas?
a) To refer to the contents of other cells in calculations
b) To link cells in different worksheets
c) To create hyperlinks between cells
d) To format cells based on their contents
Show Answer
Correct Answer: a) To refer to the contents of other cells in calculations
Explanation: The ‘Cell Referencing’ feature in formulas allows you to refer to the contents of other cells in calculations, enabling dynamic updates when cell values change.
Q34. How do you use the ‘Find and Replace’ feature?
a) Open the ‘Find and Replace’ dialog from the Home tab to search and replace text or numbers
b) Manually search for and replace data
c) Use the ‘Find’ function only
d) Use the ‘Replace’ function only
Show Answer
Correct Answer: a) Open the ‘Find and Replace’ dialog from the Home tab to search and replace text or numbers
Explanation: The ‘Find and Replace’ feature allows you to search for specific text or numbers and replace them with new values using the ‘Find and Replace’ dialog from the Home tab.
Q35. How do you create a pie chart in a spreadsheet?
a) Select the data range and use the ‘Insert Pie Chart’ option from the Insert tab
b) Manually draw a pie chart using shapes
c) Use the ‘Pie Chart’ option from the View tab
d) Import a pie chart from another application
Show Answer
Correct Answer: a) Select the data range and use the ‘Insert Pie Chart’ option from the Insert tab
Explanation: To create a pie chart, select the data range and use the ‘Insert Pie Chart’ option from the Insert tab to visualize the data distribution in a pie chart format.
Q36. What does the ‘INDEX’ function do in a spreadsheet?
a) Returns the value of a cell located at the intersection of a specified row and column
b) Finds the highest value in a range
c) Counts the number of cells in a range
d) Calculates the total of a range of cells
Show Answer
Correct Answer: a) Returns the value of a cell located at the intersection of a specified row and column
Explanation: The ‘INDEX’ function returns the value of a cell located at the intersection of a specified row and column in a given range.
Q37. How can you use the ‘LEFT’ function in a spreadsheet?
a) To extract a specified number of characters from the beginning of a text string
b) To find the leftmost value in a range
c) To sort data in ascending order
d) To format cells with left alignment
Show Answer
Correct Answer: a) To extract a specified number of characters from the beginning of a text string
Explanation: The ‘LEFT’ function extracts a specified number of characters from the beginning of a text string, useful for text manipulation and formatting.
Q38. How do you use the ‘CONCATENATE’ function in a spreadsheet?
a) To join two or more text strings into one string
b) To calculate the average of a range of numbers
c) To sort text in alphabetical order
d) To find the length of a text string
Show Answer
Correct Answer: a) To join two or more text strings into one string
Explanation: The ‘CONCATENATE’ function joins two or more text strings into one string, useful for combining data from multiple cells.
Q39. How can you adjust the alignment of text within a cell?
a) Use the ‘Alignment’ options from the Format menu
b) Use the ‘Wrap Text’ feature
c) Manually adjust text positioning
d) Use the ‘Text Direction’ option
Show Answer
Correct Answer: a) Use the ‘Alignment’ options from the Format menu
Explanation: To adjust the alignment of text within a cell, use the ‘Alignment’ options from the Format menu, where you can set horizontal and vertical alignment.
Q40. How do you use the ‘MAX’ function in a spreadsheet?
a) To find the maximum value in a range of cells
b) To calculate the average of a range
c) To sum up a range of numbers
d) To count the number of cells with numeric values
Show Answer
Correct Answer: a) To find the maximum value in a range of cells
Explanation: The ‘MAX’ function finds the highest value in a range of cells, useful for identifying the maximum value in a dataset.