Q21. How can you format a cell to display a date?
a) By using the ‘Number Format’ options and selecting ‘Date’
b) By changing the font style
c) By adjusting cell width
d) By using the ‘AutoFill’ feature
Show Answer
Correct Answer: a) By using the ‘Number Format’ options and selecting ‘Date’
Explanation: To format a cell to display a date, use the ‘Number Format’ options and select ‘Date,’ which adjusts the cell to display dates in various formats.
Q22. What does the ‘Page Setup’ option allow you to configure?
a) Page margins, orientation, and paper size
b) Cell font size
c) Row height
d) Column width
Show Answer
Correct Answer: a) Page margins, orientation, and paper size
Explanation: The ‘Page Setup’ option allows you to configure page margins, orientation (portrait or landscape), and paper size for printing the spreadsheet.
Q23. How do you delete a column from a spreadsheet?
a) By right-clicking the column header and selecting ‘Delete’
b) By changing the cell content
c) By adjusting cell height
d) By saving the document
Show Answer
Correct Answer: a) By right-clicking the column header and selecting ‘Delete’
Explanation: To delete a column, right-click the column header and select ‘Delete,’ removing the entire column from the spreadsheet.
Q24. How can you insert a chart into a spreadsheet?
a) By selecting ‘Insert’ > ‘Chart’
b) By using ‘Page Setup’
c) By adjusting cell height
d) By saving the document
Show Answer
Correct Answer: a) By selecting ‘Insert’ > ‘Chart’
Explanation: To insert a chart, select ‘Insert’ from the menu and then ‘Chart,’ which allows you to choose and create a chart based on the selected data.
Q25. What does the ‘AutoSum’ feature do?
a) Automatically adds up the values in a selected range
b) Calculates the average of a range of cells
c) Finds the maximum value in a range
d) Counts the number of cells with numeric data
Show Answer
Correct Answer: a) Automatically adds up the values in a selected range
Explanation: The ‘AutoSum’ feature quickly adds up the values in a selected range of cells, automatically inserting the SUM formula.
Q26. What is the function of the ‘Paste Special’ option?
a) To paste data with specific attributes or formatting
b) To copy data from one cell to another
c) To cut data from a selected cell
d) To delete data from a cell
Show Answer
Correct Answer: a) To paste data with specific attributes or formatting
Explanation: ‘Paste Special’ allows you to paste data with specific attributes, such as values only or formatting, instead of pasting everything from the clipboard.
Q27. How can you adjust the width of a column?
a) By dragging the boundary of the column header
b) By using ‘Page Setup’
c) By changing the cell color
d) By saving the document
Show Answer
Correct Answer: a) By dragging the boundary of the column header
Explanation: To adjust the width of a column, drag the boundary of the column header left or right until the desired width is achieved.
Q28. How do you format text within a cell?
a) By using formatting options like font style and alignment
b) By saving the document
c) By changing the cell height
d) By inserting a new row
Show Answer
Correct Answer: a) By using formatting options like font style and alignment
Explanation: To format text within a cell, use the formatting options available, such as font style, alignment, and color, to change the appearance of the text.
Q29. How can you use formulas to perform basic arithmetic operations?
a) By entering formulas like =A1+B1 for addition
b) By using ‘Page Setup’
c) By saving the document
d) By adjusting cell width
Show Answer
Correct Answer: a) By entering formulas like =A1+B1 for addition
Explanation: Formulas in a spreadsheet can be used for basic arithmetic operations, such as =A1+B1 for addition, allowing you to perform calculations directly in cells.
Q30. What is the result of the formula =A1-A2 if A1 contains 10 and A2 contains 5?
a) 5
b) 15
c) 50
d) 10
Show Answer
Correct Answer: a) 5
Explanation: The formula =A1-A2 subtracts the value in cell A2 from the value in cell A1. If A1 is 10 and A2 is 5, the result is 5.