Chapter 6 Linking Spreadsheet Data Question Answer Class 10 IT A. Multiple choice questions 1. Insert Sheet dialog can be invoked from _______________. (a) sheet (b) insert (c) tools (d) Windows Answer:(a) sheet 2. ______________ refers to cell G5 of sheet named My Sheet. (a) $My Sheet.’G5’ (b) $My Sheet_’G5’ (c) $ ‘MySheet’.G5 (d)…
Chapter 5 Using Macros in Spreadsheet Question Answer Class 10 IT A. Multiple choice questions 1. Macro Recordings can be enabled from the ________ option in the menu bar. (a) Sheet (b) Data (c) Tools (d) Window Answer:(c) Tools 2. Which of the following is an invalid Macro Name? (a) 1formatword (b) format word (c)…
Chapter 4 Analyse Data using Scenarios and Goal Seek Question Answer Class 10 IT A. Multiple choice questions 1. Which of the following feature is not used for data analysis in spreadsheet? (b) Consolidating data (b) Goal Seek (c) Subtotal (d) Page layout Answer:(d) Page layout 2. Which of the following office tool is…
Chapter 3 Advanced Features of Writer Question Answer Class 10 IT A. Multiple choice questions 1. Which of the following is NOT true about Table of Contents, Index or Bibliography dialog box? (a) It has four tabs (b) On the Type tab, by default, the checkbox for Protected against Manual Changes option will be selected….