JOMAI.pdf

Spreadsheet Software Functions and References Answers 1. What type of cell referencing remains constant regardless of where it is copied? A. Relative references B. Dynamic references C. Mixed references D. Absolute references Answer: Absolute references (D) Absolute references are...

Spreadsheet Software Functions and References Answers 1. What type of cell referencing remains constant regardless of where it is copied? A. Relative references B. Dynamic references C. Mixed references D. Absolute references Answer: Absolute references (D) Absolute references are used when you want a cell reference to remain unchanged when formulas are copied. 2. What function checks whether a condition is met and returns different values for true or false? A. CountIF B. MATCH C. VLOOKUP D. IF Answer: IF (D) The IF function is specifically designed to check conditions and return specified values based on their truthfulness. 3. What does the CHOOSE function do in Excel? A. Calculates the average of specified values B. Returns a value from a list based on a position number C. Returns the position of a value in a range D. Returns the maximum value from a set Answer: Returns a value from a list based on a position number (B) The CHOOSE function leverages a position number to return a specific value from a predefined list. 4. What is the primary purpose of Excel Pivot Tables? A. To organize and summarize data in a spreadsheet B. To find the median of a set of values C. To insert common functions into formulas D. To create scenarios with multiple variables Answer: To organize and summarize data in a spreadsheet (A) Pivot Tables allow users to summarize, reorganize, and analyze data efficiently within Excel. 5. How many values can a single scenario accommodate in Excel? A. 256 values B. 64 values C. 16 values D. 32 values Answer: 32 values (D) Each scenario in Excel can support up to 32 variable values for analysis. 6. What is the role of the Goal Seek tool in Excel? A. To save and name scenarios B. To analyze data tables and summarize results C. To determine an input value for a desired output D. To check conditions for multiple criteria Answer: To determine an input value for a desired output (C) Goal Seek is utilized to backtrack and find the necessary input for achieving a specific output result. 7. Which function would you use to look for a value in the leftmost column of a table and return a corresponding value from another column? A. HLOOKUP B. AVERAGE C. INDEX D. VLOOKUP Answer: VLOOKUP (D) VLOOKUP is designed for vertical lookup, fetching values from specified rows in a table. 8. Which of the following functions is specifically used to count cells based on a singular criterion? A. MATCH B. COUNTIF C. AVERAGE D. SUM Answer: COUNTIF (B) CountIF function is focused on counting the cells that meet certain criteria within a specified range. 9. What type of cell referencing remains constant no matter where it is copied? A. Mixed References B. Absolute References C. Relative References Answer: Absolute References (B) Absolute references are used in spreadsheet functions to keep the reference fixed during copying. 10. What is the basic syntax for a function in spreadsheet software? Answer: equals sign followed by function name and arguments The basic syntax helps define how functions are structured in spreadsheet software. 11. Which function counts cells based on one criteria? A. CountIF B. SUM C. AVERAGE Answer: CountIF (A) CountIF is used specifically for counting cells that meet a defined condition. 12. The HLOOKUP function is used to find values in vertical columns. A. True B. False Answer: False (B) HLOOKUP performs horizontal lookups across rows, not vertical columns. 13. What does the MATCH function return? Answer: the position of a value in a given range The MATCH function is useful for finding the location of an item within a list. 14. What is a Pivot Table in Excel used for? A. To enter text data B. To summarize data C. To format cells Answer: To summarize data (B) Pivot Tables allow users to summarize and analyze complex data in a more manageable format. 15. What is the purpose of the Goal Seek feature? Answer: to find an input value that results in a desired output Goal Seek is a powerful tool for performing what-if analysis by changing a single variable. 16. How many values can a scenario in Excel accommodate at most? A. 16 B. 64 C. 32 Answer: 32 (C) A scenario can hold up to 32 different values as specified in Excel's guidelines. 17. A................................... allows you to automatically insert the most common function into your formula. Answer: AutoSum AutoSum simplifies the process of adding or averaging data in a spreadsheet. 18. What is a one-variable Data Table used for? Answer: to see how different values of one variable affect the results of formulas One-variable Data Tables help analyze the impact of changing a single variable within calculations. 19. Match the following functions with their description: 1. A. Returns a specific value in a INDEX two-dimensional range 2. B. Returns a value from a list CHOOSE based on position number 3. C. Checks whether a condition is VLOOKUP met and returns one of two values D. Looks for a value in the leftmost 4. IF column of a table Answer: VLOOKUP = Looks for a value in the leftmost column of a table INDEX = Returns a specific value in a two-dimensional range CHOOSE = Returns a value from a list based on position number IF = Checks whether a condition is met and returns one of two values