MICROSOFT EXCEL DATA ANALYSIS EXAMINATION QUESTIONS AND CORRECT ANSWER WITH EXPLANATION GRADED A+ STUDY GUIDE

MICROSOFT EXCEL DATA ANALYSIS EXAMINATION
QUESTIONS AND CORRECT ANSWER WITH
EXPLANATION GRADED A+ STUDY GUIDE SOUTHERN
NEW HAMPSHIRE UNIVERSITY

1. Microsoft Excel is primarily used for:

A. Data analysis and spreadsheet management
B. Video editing
C. Hardware repair
D. Networking only
Answer: A
Rationale: Excel is a spreadsheet and data analysis tool.



2. A worksheet in Excel is made up of:

A. Rows and columns
B. Folders and files
C. Networks
D. Programs
Answer: A
Rationale: Basic structure of spreadsheets.



3. A cell in Excel is:

A. Intersection of a row and column
B. Entire sheet
C. File folder
D. Chart area
Answer: A
Rationale: Basic data unit.



4. Excel formula always starts with:

,A. = sign
B. + sign
C. # sign
D. @ sign
Answer: A
Rationale: Formulas begin with "=".



5. A function in Excel is:

A. Predefined formula
B. Manual calculation
C. Hardware tool
D. Network tool
Answer: A
Rationale: Built-in calculation method.



6. SUM function is used to:

A. Add values
B. Multiply values
C. Divide values
D. Encrypt values
Answer: A
Rationale: Performs addition.



7. AVERAGE function calculates:

A. Mean value
B. Maximum value
C. Minimum value
D. Count only
Answer: A
Rationale: Arithmetic mean.



8. MAX function returns:

, A. Largest value
B. Smallest value
C. Middle value
D. Random value
Answer: A
Rationale: Highest number.



9. MIN function returns:

A. Smallest value
B. Largest value
C. Average value
D. Count value
Answer: A
Rationale: Lowest number.



10. COUNT function is used to:

A. Count numeric values
B. Add values
C. Multiply values
D. Encrypt data
Answer: A
Rationale: Counts numbers.



11. COUNTA function counts:

A. Non-empty cells
B. Only numbers
C. Only text
D. Empty cells
Answer: A
Rationale: Counts all filled cells.



12. COUNTIF function is used for: