1. Which of the following best describes a spreadsheet?
A) A database management system
B) A tool for creating and managing text documents
C) A software application for organizing, analyzing, and storing data in
tabular form
D) A program for managing images and videos
Answer: C) A software application for organizing, analyzing, and
storing data in tabular form
Rationale: A spreadsheet allows users to enter, manipulate, and
analyze data in rows and columns, typically using formulas and
functions.
2. What is the default file extension for a Microsoft Excel
workbook?
A) .xls
B) .xlsx
C) .xlsm
D) .csv
Answer: B) .xlsx
Rationale: The default file extension for an Excel workbook created in
recent versions (Excel 2007 and later) is .xlsx.
3. What does the SUM function in Excel do?
A) Adds a series of numbers or cell values
B) Calculates the average of a set of numbers
C) Multiplies a series of numbers
D) Returns the highest number in a range
Answer: A) Adds a series of numbers or cell values
Rationale: The SUM function adds all the values within a specified
range or series of numbers.
,4. Which of the following formulas would you use to calculate the
average of values in cells A1 through A5?
A) =SUM(A1:A5)
B) =AVERAGE(A1:A5)
C) =MEAN(A1:A5)
D) =MID(A1:A5)
Answer: B) =AVERAGE(A1:A5)
Rationale: The AVERAGE function calculates the mean of the values
in the specified range.
5. What is the purpose of a cell reference in Excel?
A) To format a cell with color or borders
B) To point to a location of data in a worksheet for use in formulas
C) To create a new worksheet
D) To merge multiple cells into one
Answer: B) To point to a location of data in a worksheet for use in
formulas
Rationale: A cell reference refers to the address of a cell, which is used
in formulas to retrieve data from other cells.
6. Which of the following is an example of an absolute cell
reference?
A) A1
B) $A$1
C) A$1
D) $A1
Answer: B) $A$1
Rationale: An absolute cell reference includes dollar signs ($), which
, lock the reference to a specific cell, regardless of where the formula is
copied.
7. What does the IF function in Excel do?
A) Checks whether a condition is true or false, and returns different
values based on the result
B) Adds two numbers together
C) Returns the highest value in a range
D) Calculates the sum of values in a specified range
Answer: A) Checks whether a condition is true or false, and returns
different values based on the result
Rationale: The IF function tests a condition and returns one value if
true and another if false.
8. What is the main purpose of a pivot table in Excel?
A) To perform complex calculations
B) To organize and summarize large amounts of data
C) To create charts and graphs
D) To format cells and text
Answer: B) To organize and summarize large amounts of data
Rationale: Pivot tables help users summarize, analyze, and present
data in a more readable format.
9. How do you start a formula in Excel?
A) By typing an equal sign (=)
B) By typing a plus sign (+)
C) By typing a dollar sign ($)
D) By typing a question mark (?)
A) A database management system
B) A tool for creating and managing text documents
C) A software application for organizing, analyzing, and storing data in
tabular form
D) A program for managing images and videos
Answer: C) A software application for organizing, analyzing, and
storing data in tabular form
Rationale: A spreadsheet allows users to enter, manipulate, and
analyze data in rows and columns, typically using formulas and
functions.
2. What is the default file extension for a Microsoft Excel
workbook?
A) .xls
B) .xlsx
C) .xlsm
D) .csv
Answer: B) .xlsx
Rationale: The default file extension for an Excel workbook created in
recent versions (Excel 2007 and later) is .xlsx.
3. What does the SUM function in Excel do?
A) Adds a series of numbers or cell values
B) Calculates the average of a set of numbers
C) Multiplies a series of numbers
D) Returns the highest number in a range
Answer: A) Adds a series of numbers or cell values
Rationale: The SUM function adds all the values within a specified
range or series of numbers.
,4. Which of the following formulas would you use to calculate the
average of values in cells A1 through A5?
A) =SUM(A1:A5)
B) =AVERAGE(A1:A5)
C) =MEAN(A1:A5)
D) =MID(A1:A5)
Answer: B) =AVERAGE(A1:A5)
Rationale: The AVERAGE function calculates the mean of the values
in the specified range.
5. What is the purpose of a cell reference in Excel?
A) To format a cell with color or borders
B) To point to a location of data in a worksheet for use in formulas
C) To create a new worksheet
D) To merge multiple cells into one
Answer: B) To point to a location of data in a worksheet for use in
formulas
Rationale: A cell reference refers to the address of a cell, which is used
in formulas to retrieve data from other cells.
6. Which of the following is an example of an absolute cell
reference?
A) A1
B) $A$1
C) A$1
D) $A1
Answer: B) $A$1
Rationale: An absolute cell reference includes dollar signs ($), which
, lock the reference to a specific cell, regardless of where the formula is
copied.
7. What does the IF function in Excel do?
A) Checks whether a condition is true or false, and returns different
values based on the result
B) Adds two numbers together
C) Returns the highest value in a range
D) Calculates the sum of values in a specified range
Answer: A) Checks whether a condition is true or false, and returns
different values based on the result
Rationale: The IF function tests a condition and returns one value if
true and another if false.
8. What is the main purpose of a pivot table in Excel?
A) To perform complex calculations
B) To organize and summarize large amounts of data
C) To create charts and graphs
D) To format cells and text
Answer: B) To organize and summarize large amounts of data
Rationale: Pivot tables help users summarize, analyze, and present
data in a more readable format.
9. How do you start a formula in Excel?
A) By typing an equal sign (=)
B) By typing a plus sign (+)
C) By typing a dollar sign ($)
D) By typing a question mark (?)
