Page 204 - IT 402 v2.0 class 10
P. 204
. In alc to create the reference with the mouse:
a oth Spreadsheets need not be open b Select the cell in which the formula is going to be entered
c here is no need of symbol d ell reference is not re uired
ns. b
14. ............................. can be used in alc to ump to a different location from within a spreadsheet and can lead to other
parts of the current file to different files or even to websites.
a ables b oal Seek
c uto Sum d yperlinks
ns. d
5. Statement I: he data from the consolidation ranges and target range are saved when you save the worksheet.
Statement II: If you later open a worksheet in which consolidation has been defined this data will not be available
again.
onsider above two statements identify the correct one.
a Statement I is wrong b Statement II is wrong
c oth the Statements I and II are wrong d oth the Statements I and II are correct
ns. b
. In Spreadsheets
Statement I: o consolidate by row labels or column labels the label must be contained in the selected source ranges.
Statement II: he text in the labels must be identical so that rows or columns can be accurately matched.
Statement III: If the row or column label does not match any that exist in the target range it will be appended as
a new row or column.
onsider the above three statements identify the correct one.
a Only Statements I and II are correct b Only Statements II and III are correct
c Only Statement II is correct d ll the Statements are correct
ns. d
. ohan has 5 that he wants to invest in two mutual funds for one year. Fund is a low risk fund with
interest rate and Fund is a higher risk fund with interest rate. hich feature of spreadsheets alc will be
help him to decide
a Solver b Subtotal
c inking sheets d Macros
ns. a
18. ............................. is one of the functions available in the spreadsheet to perform addition of selected
numbers in the sheet.
ns. S M
. utosum automatically selects the values around the cells either ............................. or ............................. .
Ans. rowwise, columnwise
. iven the following Spreadsheet write the appropriate Formula xpression Function to be used for a to e :
202 Touchpad Information Technology-X

