HNS Module 7 Exam: Operate Spreadsheet Applications

1. What is the primary purpose of a spreadsheet?

A. To create presentations B. To browse the internet C. To edit images D. To organize and calculate information

2. Spreadsheets are described as an essential tool for which fields?

A. Business and accounting B. Graphic design and video editing C. Game development and animation D. Social media management

3. What types of data can be found in a spreadsheet?

A. Only numeric values B. Numeric values, text, formulas, references, and functions C. Only images and videos D. Only formatted reports

4. What are the individual spaces that hold items of data in a spreadsheet program called?

A. Blocks B. Fields C. Spreadsheet cells D. Sections

5. For which type of data are spreadsheets considered ideal?

A. Only text documents B. Only graphical designs C. Only video files D. Financial data like budgets and taxes

6. How can teachers utilize spreadsheets in a school setting?

A. To track students and calculate grades B. To design classroom layouts C. To manage school advertisements D. To create student identification cards

7. What is the main capability of Excel as a spreadsheet program?

A. Only to display graphics B. Only to create presentations C. To browse the internet D. To store, organize, and analyze information

8. Which part of the Excel interface displays the currently selected cell?

A. Formula Bar B. Name Box C. Scroll Bars D. Column Label

9. What is the function of the Formula Bar in Excel?

A. To change font settings B. To view other parts of a worksheet C. To identify rows with a number D. To display and allow editing of numbers, text, or formulas in the selected cell

10. In Excel, which direction do columns run?

A. Vertically (top to bottom) B. Horizontally (left to right) C. Diagonally D. In a circular pattern

11. How are rows identified in an Excel worksheet?

A. With a letter B. With a number C. With a symbol D. With a color

12. What is the intersection of a row and a column in Excel called?

A. A block B. A range C. A cell D. A section

13. Where are the worksheets contained in a workbook displayed?

A. At the bottom-left of the screen B. At the top-right of the screen C. In the middle of the worksheet D. Above the Ribbon

14. What are Scroll Bars used for in Excel?

A. To select multiple cells B. To apply formatting C. To enter formulas D. To view other parts of a worksheet when it cannot fit on the screen

15. Which standard operator is used for exponents in Excel formulas?

A. + (plus sign) B. - (minus sign) C. * (asterisk) D. ^ (caret)

16. What is the ampersand symbol (&) used for in Excel?

A. Division B. Subtraction C. Concatenating text values D. Multiplication

17. What do Comparison or Logical Operators produce as a result?

A. Logical value True or False B. Numerical sum C. Text string D. Error message

18. Which reference operator is used to separate sheet names from cell references?

A. : (Colon) B. , (Comma) C. Single Space D. ! (Exclamation Mark)

19. How do relative references behave when a formula is copied to another cell?

A. They remain constant B. They change C. They become absolute D. They become mixed

20. What characteristic defines absolute references when copied or filled?

A. They always change B. They only change for columns C. They remain constant D. They become relative

21. How is an absolute reference designated in a formula?

A. By the addition of a dollar sign ($) before the column and row B. By enclosing it in parentheses C. By using an exclamation mark D. By typing "ABS" before the reference

22. What is a "function" in Excel?

A. A manual calculation method B. A predefined formula that performs calculations C. A type of cell reference D. A display setting

23. What are the basic parts of a function's syntax?

A. Function name only B. Equals sign and arguments C. Arguments only D. Equals sign, function name, and one or more arguments

24. Which function adds all the values of the cells in the argument?

A. SUM B. AVERAGE C. COUNT D. MAX

25. How does the AVERAGE function determine the average?

A. It only sums the cells B. It finds the highest value C. It calculates the sum of the cells and then divides that value by the number of cells D. It counts the number of cells

HNS Module 7 Exam: Operate Spreadsheet Applications

Exam Results