INFORMATION TECHNOLOGY-402
CLASS-X
SESSION-2020-21
UNIT 2:
Electronic Spreadsheet ( Advance)
Book
Exercise
SESSION 1: Analyse data using scenarios
and goal seek
Q1 What do you mean by consolidate?
Ans:
Consolidate provides a graphical interface for copying data from one range of cells to
another, then running one
of
a dozen functions on the data. During consolidation, the contents of cells from several sheets can be combined in one place.
Q2 Define Scenarios.
Ans: Scenarios are a tool to test “what-if” questions. Use Tools > Scenarios to enter variable contents—scenarios—in the same cell. Each scenario is named, and can be edited and formatted separately, and chosen
from a drop-down list in the Navigator and the title bar of the scenario. When you print the spreadsheet, only the contents of the currently active scenario are printed.
Q3 Explain Multiple Operations.
Ans:
Multiple Operations is a planning tool for “what if” questions. Unlike a scenario, the Multiple Operations tool does not present the alternate versions in the same cells or with a drop-down list. Instead, the Multiple Operations tool creates a formula array: a separate set of cells that give all the alternative results for the formulas used. Although the tool is not listed among the functions, it is really a function that acts on other functions, allowing you to calculate different results without having to enter and run them separately.
Q4 Write the use of Goal Seek.
Ans: Goal Seek reverses the usual order for a formula. Usually, you run a formula to get the result when certain arguments are entered. By contrast, with Goal Seek,
you
work with a completed
formula
to see what values you need in an argument
to get
the
results that you want.
SESSION 2: Link Data and Spreadsheets
Q1 Write steps to insert sheet.
Ans: Select the
Or, select Home > Insert > Insert
Sheet
Q2 Write the steps to rename a worksheet.
Ans: There are three way to rename a woksheet:
1)
Double-click on
one of the existing worksheet names.
2)
Right-click on an
existing worksheet name, then choose Rename from the resulting Context menu.
3)
Select the
worksheet you want to rename (click on the worksheet tab) and then select the
Sheet option from the Format menu. This displays a submenu from which you
should select the Rename option.
Q3 What is cell reference?
Ans: A cell reference 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.
Q4
Define hyperlink.
Ans:
In computing, a hyperlink, or simply a link,
is a reference to data that the user can follow by clicking or tapping. A hyperlink points to a
whole document or to a specific element within a document. Hypertext is text
with hyperlinks. The text that is
linked from is called anchor text.
SESSION 3: Share and review
a spreadsheet
Fill in
the blanks:
3. Spreadsheet software allows the
user to share the workbook and place it in the network location
where several users can access it simultaneously
SESSION 4: Create and use
Macros in spreadsheet
Q1 What is Macro ?
Ans:
A macro is like an
algorithm or a set of actions that we can use or run
multiple times. A macro helps in
automating or repeating tasks by recording or storing our input sequences like
mouse strokes or keyboard presses. Once this input is stored, it makes up a macro which is open
to any possible changes.
Q2
Write the steps to enter macro in speadsheet.
Ans: Running the macro
Use Tools > Macros > Run Macro to
open the Macro Selector dialog. Select the newly created macro and
click Run. Select your macro and click Run. There are other
methods to run a macro
Q3 Write
steps for Writing formula/ equations in MS Word.
Ans: Writing equations in the MS –word while
typing the equations or mathematical expression can be easily done using
Equation option on Symbols Group under Insert Tab.
No comments:
Post a Comment