______________ allows you to combine data from multiple worksheets into a single master worksheet.

• Data Consolidation

• Multiple Data

• Scenarios

• Goal Seek

________ series of worksheets or workbooks summarizes it into a single worksheet.

• Multiple Data

• Data Consolidation

• Scenarios

• Goal Seek

Which function cannot be performed through Subtotal in a Spreadsheet?

• Sum

• Product

• Average

• Percentage

Scenarios are a tool to test questions.

• Auto

• Goal Seek

• What-If

• Drop Down

When making a watermark or putting an image in the backdrop of a document, _______ comes in useful.

• Transparency

• Fill

• Filters

• Crop

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

• Auto Sum

• 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

A/An ______ hyperlink contains the full address of the destination file or web page.

• Relative

• Absolute

• Mixed

• Hybrid

Which of the following reflects the importance of Goal Seek?

• Subtotal

• Scenario

• Solver

• Consolidate

______ means combining data in a spreadsheet from different worksheets into master worksheet

• Hyperlinks

• Consolidating

• Linking

• Filter