Q1. What is the primary purpose of opening a spreadsheet in an application like Microsoft Excel?
a) To view data in a graphical format
b) To perform calculations and manage data
c) To create multimedia presentations
d) To browse the internet
Show Answer
Correct Answer: b) To perform calculations and manage data
Explanation: Opening a spreadsheet allows users to enter, manipulate, and analyze data using various tools and functions within the application. Spreadsheets are designed primarily for data management and calculations.
Q2. In a spreadsheet, what does the cell address “B4” refer to?
a) The cell in the 2nd row and 4th column
b) The cell in the 4th row and 2nd column
c) The cell in the 2nd column and 4th row
d) The cell in the 4th column and 2nd row
Show Answer
Correct Answer: c) The cell in the 2nd column and 4th row
Explanation: In spreadsheet software, cell addresses are written as a column letter followed by a row number, so “B4” refers to the cell in the 2nd column (B) and the 4th row.
Q3. Which feature allows you to save your spreadsheet with a new name or in a different location?
a) Save As
b) Print
c) Import
d) Open
Show Answer
Correct Answer: a) Save As
Explanation: The “Save As” feature allows users to save the current document with a new name or in a different location, thereby creating a separate file from the original.
Q4. What is the default file extension for a workbook saved in Microsoft Excel 2016?
a) .xls
b) .xlsx
c) .docx
d) .pdf
Show Answer
Correct Answer: b) .xlsx
Explanation: Microsoft Excel 2016 and later versions use the .xlsx extension as the default file format for workbooks, which supports a wide range of features and functionalities.
Q5. How do you insert a new row into a spreadsheet?
a) Right-click the row number and select “Insert”
b) Click “Insert” from the menu bar
c) Drag the row number down
d) Click “Add Row” on the toolbar
Show Answer
Correct Answer: a) Right-click the row number and select “Insert”
Explanation: Right-clicking on a row number and selecting “Insert” from the context menu allows you to add a new row above the selected row in a spreadsheet.
Q6. To adjust the width of a column, which method is used?
a) Double-click the column header boundary
b) Right-click and select “Resize”
c) Drag the column header boundary
d) Use the “Format” menu option
Show Answer
Correct Answer: c) Drag the column header boundary
Explanation: To adjust the column width, you can drag the boundary on the right side of the column header to the desired width.
Q7. What does the AutoSum feature do in a spreadsheet?
a) Automatically creates a chart from selected data
b) Automatically calculates the sum of a range of numbers
c) Automatically formats cells with numeric data
d) Automatically saves the workbook at regular intervals
Show Answer
Correct Answer: b) Automatically calculates the sum of a range of numbers
Explanation: AutoSum is a feature that quickly calculates the sum of a selected range of cells, usually by placing the sum function in the cell directly below or next to the selected data.
Q8. What type of cell reference adjusts automatically when you copy a formula to another cell?
a) Absolute reference
b) Relative reference
c) Mixed reference
d) Fixed reference
Show Answer
Correct Answer: b) Relative reference
Explanation: Relative references in formulas adjust automatically based on the position of the cell to which the formula is copied. This means the cell references will change relative to the new location of the formula.
Q9. What does the formula “=A1+B1” compute?
a) The sum of cells A1 and B1
b) The difference between cells A1 and B1
c) The product of cells A1 and B1
d) The quotient of cells A1 and B1
Show Answer
Correct Answer: a) The sum of cells A1 and B1
Explanation: The formula “=A1+B1” adds the values in cells A1 and B1 and returns the result in the cell where the formula is entered.
Q10. Which function would you use to find the average of a range of numbers in Excel?
a) SUM()
b) AVERAGE()
c) MAX()
d) COUNT()
Show Answer
Correct Answer: b) AVERAGE()
Explanation: The AVERAGE() function calculates the arithmetic mean of a specified range of numbers, providing a measure of central tendency.