Q1. What is the primary function of a spreadsheet?
a) To manage text documents
b) To create and manipulate tables of data
c) To design graphics
d) To write and execute code
Show Answer
Correct Answer: b) To create and manipulate tables of data
Explanation: The primary function of a spreadsheet is to create and manipulate tables of data, allowing users to organize, analyze, and visualize data in a structured format.
Q2. How is a cell address in a spreadsheet identified?
a) By its row number and column letter
b) By its row letter and column number
c) By its row and column name
d) By its cell number and sheet name
Show Answer
Correct Answer: a) By its row number and column letter
Explanation: A cell address in a spreadsheet is identified by its row number and column letter, such as A1, which specifies the cell’s location within the grid.
Q3. Which of the following is NOT a valid data type for a cell in a spreadsheet?
a) Text
b) Number
c) Date
d) Image
Show Answer
Correct Answer: d) Image
Explanation: While text, number, and date are valid data types for cells, images are not directly entered as cell data but can be inserted into the spreadsheet as objects.
Q4. How do you set up the page layout for printing a spreadsheet?
a) Use the ‘Page Layout’ tab and adjust settings
b) Use the ‘Print’ option directly
c) Change the cell formatting
d) Adjust the zoom level
Show Answer
Correct Answer: a) Use the ‘Page Layout’ tab and adjust settings
Explanation: The ‘Page Layout’ tab allows you to set up the page layout for printing by adjusting margins, orientation, and paper size.
Q5. What is the purpose of the ‘Save As’ function in a spreadsheet application?
a) To save the current file with a new name or format
b) To overwrite the existing file
c) To create a backup of the file
d) To close the file without saving
Show Answer
Correct Answer: a) To save the current file with a new name or format
Explanation: The ‘Save As’ function allows you to save the current file with a new name or format, which is useful for creating different versions of the file.
Q6. How can you open a previously saved spreadsheet file?
a) Use the ‘Open’ option from the File menu
b) Double-click the file from the file explorer
c) Drag and drop the file into the application
d) All of the above
Show Answer
Correct Answer: d) All of the above
Explanation: You can open a previously saved spreadsheet file using the ‘Open’ option from the File menu, double-clicking the file from the file explorer, or dragging and dropping the file into the application.
Q7. How do you delete a row in a spreadsheet?
a) Select the row and use the ‘Delete’ option from the context menu
b) Press the ‘Delete’ key after selecting the row
c) Use the ‘Clear Contents’ option from the Edit menu
d) Select the row and press ‘Ctrl + D’
Show Answer
Correct Answer: a) Select the row and use the ‘Delete’ option from the context menu
Explanation: To delete a row, select the row and use the ‘Delete’ option from the context menu, which removes the entire row from the spreadsheet.
Q8. What does the ‘AutoFill’ feature do?
a) Automatically fills cells with sequential data
b) Automatically adjusts column width
c) Fills cells with a predefined template
d) Automatically sorts data
Show Answer
Correct Answer: a) Automatically fills cells with sequential data
Explanation: The ‘AutoFill’ feature automatically fills cells with sequential data based on the pattern you drag across the cells, such as dates or numbers.
Q9. How can you format a cell to display text in bold?
a) Use the ‘Bold’ button in the toolbar
b) Use the ‘Font’ settings in the Format menu
c) Apply a bold font style
d) All of the above
Show Answer
Correct Answer: d) All of the above
Explanation: You can format a cell to display text in bold using the ‘Bold’ button in the toolbar, ‘Font’ settings in the Format menu, or by applying a bold font style.
Q10. What is the purpose of the ‘Freeze Panes’ feature?
a) To keep specific rows or columns visible while scrolling through a large dataset
b) To lock the spreadsheet from being edited
c) To save the spreadsheet in a frozen format
d) To protect cells from formatting changes
Show Answer
Correct Answer: a) To keep specific rows or columns visible while scrolling through a large dataset
Explanation: The ‘Freeze Panes’ feature keeps specific rows or columns visible while scrolling through a large dataset, making it easier to view and compare data.