Spreadsheet quiz

It collates the data from different ranges and places it in a worksheet.

• Consolidate

• Combining

• Subtotals

Which tab holds the 'what-if -analysis' option?

• Analysis

• Data tools

• Developer

It is used to set a goal to find the optimum value from 1 ore or more target variables.

• Scenario

• Goal seek

• Detective

It is the elaborate form of goal seek.

• Detective

• Solver

• Scenario

In the formula= Sum('Records of students'! B4:D4), 'Records of students' is a:

• Sheet name

• Range

• Database

Which of the following is a relative hyperlink?

• http://www.google.com

• /picture.jpg

• ///picture.jpg

The 'hyperlink' option is available in the which tab.

• Insert

• View

• Data

What is the keyboard shortcut to insert hyperlink in your worksheet?

• Ctrl + H

• Ctrl + L

• Ctrl + K

Which of the following tab contains the 'share workbook' option?

• Review

• Data

• View

Which of the following group in the review tab has the 'track changes' option?

• Proofing

• Comments

• Changes