MICROSOFT EXCEL FOR ACCOUNTING EXAMINATION
QUESTIONS AND CORRECT
ANSWER&EXPLANATION|GRADED A+ STUDY GUIDE
SOUTHERN NEW HAMPSHIRE UNIVERSITY
1. Microsoft Excel is primarily used for:
A. Video editing only
B. Spreadsheet calculations and data analysis
C. Network security only
D. Graphic animation only
Answer: B
Rationale: Excel is widely used for calculations, analysis, and reporting.
2. Microsoft developed:
A. QuickBooks
B. Microsoft Excel
C. SAP ERP
D. Oracle Database
Answer: B
Rationale: Microsoft is the developer of Excel.
3. A workbook in Microsoft Excel consists of:
A. Multiple worksheets
B. Only one chart
C. One formula only
D. One database only
Answer: A
Rationale: Workbooks contain one or more worksheets.
4. A worksheet is made up of:
,A. Slides only
B. Rows and columns
C. Images only
D. Charts only
Answer: B
Rationale: Worksheets organize data into rows and columns.
5. A cell reference identifies:
A. Chart type only
B. Specific worksheet location
C. Entire workbook only
D. Formula category only
Answer: B
Rationale: Cell references identify data locations.
6. Cell A1 refers to:
A. Column 1 Row A
B. Column A Row 1
C. Worksheet A only
D. Formula category 1
Answer: B
Rationale: Excel references columns first, then rows.
7. Formulas in Microsoft Excel begin with:
A. #
B. =
C. @
D. %
Answer: B
Rationale: Formulas must begin with an equal sign.
8. The SUM function is used to:
, SUM(A1
)
A. Multiply numbers only
B. Add values together
C. Count text entries only
D. Format cells only
Answer: B
Rationale: SUM totals selected values.
9. The AVERAGE function calculates:
AVERAGE(A1
)
A. Highest value only
B. Arithmetic mean
C. Median only
D. Product of values
Answer: B
Rationale: AVERAGE computes mean values.
10. The MAX function returns:
A. Lowest value
B. Highest value
C. Average value
D. Text value only
Answer: B
Rationale: MAX identifies largest numeric value.
11. The MIN function identifies:
A. Highest value only
B. Lowest value
C. Average value only
D. Text length only
QUESTIONS AND CORRECT
ANSWER&EXPLANATION|GRADED A+ STUDY GUIDE
SOUTHERN NEW HAMPSHIRE UNIVERSITY
1. Microsoft Excel is primarily used for:
A. Video editing only
B. Spreadsheet calculations and data analysis
C. Network security only
D. Graphic animation only
Answer: B
Rationale: Excel is widely used for calculations, analysis, and reporting.
2. Microsoft developed:
A. QuickBooks
B. Microsoft Excel
C. SAP ERP
D. Oracle Database
Answer: B
Rationale: Microsoft is the developer of Excel.
3. A workbook in Microsoft Excel consists of:
A. Multiple worksheets
B. Only one chart
C. One formula only
D. One database only
Answer: A
Rationale: Workbooks contain one or more worksheets.
4. A worksheet is made up of:
,A. Slides only
B. Rows and columns
C. Images only
D. Charts only
Answer: B
Rationale: Worksheets organize data into rows and columns.
5. A cell reference identifies:
A. Chart type only
B. Specific worksheet location
C. Entire workbook only
D. Formula category only
Answer: B
Rationale: Cell references identify data locations.
6. Cell A1 refers to:
A. Column 1 Row A
B. Column A Row 1
C. Worksheet A only
D. Formula category 1
Answer: B
Rationale: Excel references columns first, then rows.
7. Formulas in Microsoft Excel begin with:
A. #
B. =
C. @
D. %
Answer: B
Rationale: Formulas must begin with an equal sign.
8. The SUM function is used to:
, SUM(A1
)
A. Multiply numbers only
B. Add values together
C. Count text entries only
D. Format cells only
Answer: B
Rationale: SUM totals selected values.
9. The AVERAGE function calculates:
AVERAGE(A1
)
A. Highest value only
B. Arithmetic mean
C. Median only
D. Product of values
Answer: B
Rationale: AVERAGE computes mean values.
10. The MAX function returns:
A. Lowest value
B. Highest value
C. Average value
D. Text value only
Answer: B
Rationale: MAX identifies largest numeric value.
11. The MIN function identifies:
A. Highest value only
B. Lowest value
C. Average value only
D. Text length only
