ELECTRONIC SPREADSHEET (ADVANCED)
ELECTRONIC SPREADSHEET (ADVANCED) 1. What is the use of data consolidation? Data Consolidation is used to gather together our data from separate worksheets into a master worksheet. 2. Define Subtotal. SUBTOTAL is used to total/add data arranged in an array i.e., a group of cells with labels for columns and/or rows. 3. What is Scenario? Scenarios are a tool to test “what-if” questions. It is essentially a saved set of cell values used for calculations 4. What is Goal Seek? Goal seeking is the process of finding the correct input value when only the output is known. 5. What is Solver? Solver is a more elaborate form of Goal Seek. It deals with equations with multiple unknown variables. It is specifically designed to minimize or maximize the result according to a set of rules that has been defined. 6. Define cell reference. A cell reference refers to a cell or a range of cells on a worksheet and can be used to fi...