Q1. How do you create a new spreadsheet?
a) By selecting ‘New’ from the file menu
b) By opening an existing spreadsheet
c) By clicking ‘Print’
d) By saving a document
Show Answer
Correct Answer: a) By selecting ‘New’ from the file menu
Explanation: To create a new spreadsheet, you select ‘New’ from the file menu, which opens a blank spreadsheet for you to start working on.
Q2. What does a cell address in a spreadsheet refer to?
a) The row and column of a cell
b) The font style of a cell
c) The color of the cell border
d) The content of a cell
Show Answer
Correct Answer: a) The row and column of a cell
Explanation: A cell address in a spreadsheet refers to the combination of the row and column where the cell is located, such as A1 or B2.
Q3. How do you select a cell in a spreadsheet?
a) By clicking on it
b) By typing in it
c) By dragging the mouse over multiple cells
d) By using the ‘Find’ feature
Show Answer
Correct Answer: a) By clicking on it
Explanation: To select a cell in a spreadsheet, simply click on it with the mouse, making it active for data entry or manipulation.
Q4. What types of data can be entered into a spreadsheet cell?
a) Text, number, and date
b) Only text
c) Only numbers
d) Only dates
Show Answer
Correct Answer: a) Text, number, and date
Explanation: Spreadsheet cells can contain various types of data, including text, numbers, and dates, allowing for diverse data entry.
Q5. How can you adjust the print settings for a spreadsheet?
a) By using the ‘Page Setup’ option
b) By saving the spreadsheet
c) By using the ‘Find’ feature
d) By changing the font size
Show Answer
Correct Answer: a) By using the ‘Page Setup’ option
Explanation: To adjust print settings, use the ‘Page Setup’ option where you can configure margins, orientation, and other print-related settings.
Q6. What is the purpose of saving a spreadsheet?
a) To keep a record of your data and work
b) To adjust the cell height
c) To insert a new row
d) To format text
Show Answer
Correct Answer: a) To keep a record of your data and work
Explanation: Saving a spreadsheet ensures that your data and work are preserved and can be accessed or modified later.
Q7. How do you open an existing spreadsheet?
a) By selecting ‘Open’ from the file menu
b) By creating a new spreadsheet
c) By using the ‘Print’ option
d) By saving a new document
Show Answer
Correct Answer: a) By selecting ‘Open’ from the file menu
Explanation: To open an existing spreadsheet, select ‘Open’ from the file menu and choose the file you wish to access.
Q8. What is the method to close a spreadsheet?
a) By selecting ‘Close’ from the file menu
b) By saving the document
c) By printing the spreadsheet
d) By creating a new spreadsheet
Show Answer
Correct Answer: a) By selecting ‘Close’ from the file menu
Explanation: To close a spreadsheet, select ‘Close’ from the file menu, which will exit the current spreadsheet and return you to the previous view.
Q9. How can you modify or edit the content of a cell?
a) By clicking the cell and typing
b) By selecting ‘Format Cells’
c) By using ‘Page Setup’
d) By changing the font color
Show Answer
Correct Answer: a) By clicking the cell and typing
Explanation: To modify or edit the content of a cell, click on the cell and type the new information directly.
Q10. How do you format cell content?
a) By using the formatting options in the toolbar
b) By saving the document
c) By inserting a new row
d) By closing the spreadsheet
Show Answer
Correct Answer: a) By using the formatting options in the toolbar
Explanation: Cell content can be formatted using the formatting options in the toolbar, such as font style, alignment, and cell color.