Page 195 - IT 402 v2.0 class 10
P. 195
Solved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
. onsolidate option is available under ............................. menu.
i. View ii. Tool
iii. Insert iv. ata
. Subtotals is available in ............................. menu.
i. ools ii. Format
iii. Insert iv. ata
. e can shift from one scenario to another by ............................. .
i. Navigator ii. Find and eplace
iii. ata Source iv. None of these
. o select random multiple cell hold down ............................. key as you click on each cell.
i. Alt ii. Shift
iii. trl iv. ll of these
5. hich of the following is more elaborate form of oal Seek S Sample aper
i. Scenario ii. Subtotal
iii. Solver iv. ll of these
. If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new
location a relative hyperlink will ............................. .
i. not work ii. work
iii. may work iv. None of these
. hich function cannot be performed through Subtotal in a Spreadsheet S Sample aper
i. Sum ii. roduct
iii. verage iv. ercentage
. 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
formula to calculate. S Sample aper
i. Row ii. Column
iii. utosum iv. ell eferenc
9. ............................. totals adds data arranged in an array that is a group of cells with labels for columns and or
rows hich step one must should follow before using the Subtotal option S Sample aper
i. onsolidate ii. ename ata
iii. Filter ata iv. Subtotal
10. ............................. means combining data in a spreadsheet from different worksheets into master worksheet
S Sample aper
i. yperlinks ii. onsolidating
iii. inking iv. Filter
. y default sheets tab are present at the ............................. of the spreadsheet. S Sample aper
i. Top ii. Bottom
iii. enter iv. ight
Advanced Features of Spreadsheet 193

