Q11. What does the ‘Cut’ function do in a spreadsheet?
a) Removes the selected data and places it on the clipboard
b) Copies the selected data
c) Pastes data from the clipboard
d) Deletes the selected data without placing it on the clipboard
Show Answer
Correct Answer: a) Removes the selected data and places it on the clipboard
Explanation: The ‘Cut’ function removes the selected data from its original location and places it on the clipboard, allowing it to be pasted elsewhere.
Q12. How do you paste data from the clipboard into a cell?
a) By using the ‘Paste’ function
b) By using the ‘Cut’ function
c) By using the ‘Find’ feature
d) By saving the document
Show Answer
Correct Answer: a) By using the ‘Paste’ function
Explanation: To paste data from the clipboard into a cell, use the ‘Paste’ function, which places the data at the current cell location.
Q13. What does ‘Paste Special’ allow you to do?
a) Paste data with specific formatting options or attributes
b) Paste data from the clipboard
c) Cut data from the selected cell
d) Copy data from one cell to another
Show Answer
Correct Answer: a) Paste data with specific formatting options or attributes
Explanation: ‘Paste Special’ allows you to paste data with specific formatting options, such as values only, formats, or formulas, according to your needs.
Q14. How can you change the height of a row?
a) By dragging the boundary of the row header
b) By using ‘Page Setup’
c) By changing the font size
d) By saving the document
Show Answer
Correct Answer: a) By dragging the boundary of the row header
Explanation: To change the height of a row, drag the boundary of the row header up or down until the desired height is achieved.
Q15. How do you insert a new row into a spreadsheet?
a) By right-clicking a row number and selecting ‘Insert’
b) By changing the cell content
c) By saving the document
d) By printing the spreadsheet
Show Answer
Correct Answer: a) By right-clicking a row number and selecting ‘Insert’
Explanation: To insert a new row, right-click a row number where you want the new row to appear and select ‘Insert.’
Q16. What is the purpose of the ‘AutoFill’ feature?
a) To automatically fill cells with data based on a pattern or series
b) To adjust cell height
c) To change the font style
d) To save the spreadsheet
Show Answer
Correct Answer: a) To automatically fill cells with data based on a pattern or series
Explanation: The ‘AutoFill’ feature allows you to automatically fill cells with data based on a pattern or series, such as dates or numbers.
Q17. Which function calculates the total of a range of cells?
a) SUM
b) AVERAGE
c) MAX
d) COUNT
Show Answer
Correct Answer: a) SUM
Explanation: The ‘SUM’ function calculates the total of a range of cells by adding up all the numeric values within the specified range.
Q18. What does the ‘COUNT’ function do?
a) Counts the number of cells containing numeric data
b) Calculates the average of a range of cells
c) Finds the maximum value in a range
d) Adds up all the values in a range
Show Answer
Correct Answer: a) Counts the number of cells containing numeric data
Explanation: The ‘COUNT’ function counts the number of cells in a range that contain numeric data, excluding text and blank cells.
Q19. How can you find the maximum value in a range of cells?
a) By using the ‘MAX’ function
b) By using the ‘MIN’ function
c) By using the ‘AVERAGE’ function
d) By using the ‘COUNT’ function
Show Answer
Correct Answer: a) By using the ‘MAX’ function
Explanation: The ‘MAX’ function finds the maximum value in a range of cells, returning the highest number from the specified range.
Q20. What does the ‘AVERAGE’ function calculate?
a) The average value of a range of cells
b) The total sum of a range of cells
c) The number of cells with numeric data
d) The minimum value in a range
Show Answer
Correct Answer: a) The average value of a range of cells
Explanation: The ‘AVERAGE’ function calculates the mean value of a range of cells by summing the values and dividing by the number of cells.