Electronic Spreadsheet Quiz

______________ series of worksheets or workbooks summarizes it into a single worksheet

• Multiple Data

• Data Consolidation

• Scenarios

• Goal Seek

Scenarios are a tool to test questions.

• Auto

• Goal Seek

• What-if

• Drop Down

It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want a formula to calculate.

• Row

• Column

• Autosum

• Cell Reference

. __________, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows Which step one must follow before using the Subtotal option?

• Consolidate.

• Rename Data

• Filter Data

• Subtotal

An __________ link will stop working only if the target is moved while a __________ link will stop working only if the start and target locations change relative to each other.

• absolute, fixed

• Relative, Absolute

• absolute, relative

• permanent, absolute

Rohit received a 25 out of 30 grade in English and a 22 out of 30 grade in Math. To calculate the score in IT, he needs to acquire an overall score of 85 percent. Provide him with the best selection from the list below.

• Macro

• Solver

• Goal Seek

• Sub Total

You can use ________ to combine data from multiple worksheets into a master worksheet.

• Data Consolidation

• Goal Seek

• Solver

• Total data

In the consolidate window, which of the following functions are available?

• Max

• Min

• Count

• All of the above

The default name of the first scenario created in Sheet1 of Calc is ________

• Sheet1_Scenario1

• Sheet1_Scenario_1

• Sheet_1_Scenario1

• Sheet_1_Scenario_1

Which feature of Calc helps to see the changes made in the shared worksheet?

• Comparing worksheets

• Duplicating worksheets

• Checking worksheets

• None of the above