Advanced Spreadsheet

Download as pdf or txt
Download as pdf or txt
You are on page 1of 17

Advanced Spreadsheet

SESSION 1: Analyze data using SCENARIOS AND GOAL SEEK


Data Consolidation allows you to gather together your data from separate worksheets into a
master worksheet. In other words, the Data Consolidation function takes data from a series
of worksheets and summaries it into a single worksheet.
STEPS for Data Consolidation are :
1) Open the worksheet that contains the cell ranges to be consolidated.
2) Choose the Consolidate option under the Data menu.
3) Select Source data range and click Add. The selected range now appears on the
Consolidation ranges list.
4) Select additional ranges and click Add after each selection.
5) Specify where you want to display the result by selecting a target range from the Copy
results to box.
6) Select a function from the Function list. The Sum function is the default setting.
7) Select either Row labels or Column labels. The text in the labels must be identical in all the
specified Source range.
8) Click OK to consolidate the ranges.
NOTE : Use Data > Define Range to give name to a range

Creating Subtotals :
SUBTOTAL, totals/adds data arranged in an array—that is, a group of cells with labels for
columns and/or rows. Using the Subtotals dialog, you can select arrays, and then choose a
statistical function to apply to them. It is accessible from Data menu.
Steps to insert subtotal values into a sheet:
1) Ensure that the columns have labels.
2) In the Subtotals dialog , in the Group by box, select the column that you want to add the
subtotals to.
3) In the Calculate subtotals for box, select the columns that you want to subtotal.
4) In the Use function box, select the function.
5) Click OK.

Using “What If” Scenarios :


Scenarios are a tool to test “what-if” questions. Each scenario is named, and can be edited
and formatted separately. You can easily switch between different scenarios by using the
Navigator. For example, if you wanted to calculate the effect of different interest rates on an
investment, you could add a scenario for each interest rate, and quickly view the results.
Creating Scenarios :
1) Select the cells that contain the values that will change between scenarios.
2) Choose Tools > Scenarios.
3) On the Create Scenario dialog , enter a name for the new scenario. This name is displayed
in the Navigator and on the title bar of the scenario.
4) Optionally add some information to the Comment box.
5) Optionally select or deselect the options in the Settings section.
6) Click OK to close the dialog
NOTE : You can create several scenarios for any given range of cells

Goal Seek
Usually, you run a formula to calculate a result based upon existing values. By contrast Goal
Seek option under Tools menu, helps to find values which will produce the result that you
want. for example
Chief Financial Officer has a good idea of the company’s income in the first three quarters,
because of the contracts that are already signed. For the fourth quarter, however, no definite
income is available. So how much must the company earn in Q4 to reach its goal? Then Chief
Financial Officer runs a goal seek on the empty cell for Q4 sales and receives the answer

Solver :
Solver option under Tools menu amounts to a more elaborate form of Goal Seek. The
difference is that the Solver deals with equations with multiple unknown variables. It is
specifically designed to minimize or maximize the result according to a set of rules that you
define.

Session 2 : Link Data and Spreadsheets Using


Multiple Workbooks and Linking Cells
Spreadsheet allows you to link the cells from various worksheets to summarize data from
several sources. In this manner, you can create formulas using a combination of local and
linked information. Multiple sheets help to keep the information organized.
Inserting New Sheets
When you open a new spreadsheet, by default, it has a sheet named Sheet1. There are
several ways to insert a new sheet. The first step, in all cases, is to select the sheet that will
be next to the new sheet. Then do any of the following:
1. Select Insert > Sheet from the menu bar, or
2. Right-click on the tab and select Insert Sheet, or
3. Click in an empty space at the end of the line of sheet tabs.
Each method opens the Insert Sheet dialog box where you can choose to put the new sheet
before or after the selected sheet and how many sheets to insert.
Renaming Sheets
There are three ways you can rename a worksheet. You can do any of the following:

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.

Cell Reference : A cell reference refers to a cell or a range of cells on a worksheet


that can be used in a formula to calculate values.
Referencing Other Sheets
There are two ways to reference cells in other sheets :
1) By entering the formula directly using the keyboard. :

Typing the reference is simple once you know the format the reference takes. The reference
has three parts to it: Path and file name . Sheet name . Cell name
The general format for the reference is =’file:///Path &File Name’#$SheetName.CellName
2) By using the mouse.

Hyperlinks : Hyperlinks can be used in Calc to jump to a different location from


within a spreadsheet to other parts of the same file or to different files or even
to web sites.
Hyperlinks can be stored within your file as either relative or absolute
An absolute link will stop working only if the target is moved. A relative link will stop
working only if the start and target locations change relative to each other. For instance, 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 not break.
You can insert and modify links using the Hyperlink dialog. To display the dialog, click the
Hyperlink icon on the Standard toolbar or choose Insert > Hyperlink from the menu bar.

Linking To External Data :


You can insert tables from HTML documents, and data located within named ranges from an
OpenOffice.org Calc or Microsoft Excel spreadsheet, into a Calc spreadsheet You can do this
in two ways: using the External Data dialog or using the Navigator
Using the External Data dialog : Steps are
1. Open the Calc worksheet where the external data is to be inserted. This is the
target worksheet.
2. Select the cell where the upper left-hand cell of the external data is to be
inserted.
3. Choose Insert -> Link to External Data.
4. On the External Data dialog, type the URL of the source worksheet
5. In the Available tables/range list, select the named ranges or tables you want to
insert.
6. Click OK to close this dialog and insert the linked data.
Linking To Registered Data Sources :
You can access a variety of databases and other data sources and link them into Calc
worksheets. First you need to register the data source with OpenOffice.org. To register a
data source that is in *.odb format:
1. Choose Tools -> Options -> OpenOffice.org Base -> Databases.
2. Click the New button to open the Create Database Link dialog.
3. Enter the location of the database file, or click Browse to open a file browser and
select the database file.
4. Type a name to use as the registered name for the database and click OK.

SESSION 3: SHARING WORKSHEET DATA


Spreadsheet software allows the user to share the workbook and place it in the network
location where several users can access it simultaneously. This is required to either speed up
data entry or simply make things easier for collaboration purposes.
Setting Up A Spreadsheet For Sharing :
Open the spreadsheet document , choose Tools > Share Document to activate the
collaboration features for this worksheet. A dialog opens where you can choose to enable or
disable sharing.
To enable sharing, select the box at the top of the dialog, and then click OK. A message
appears stating that you must save the worksheet to activate shared mode. Click Yes to
continue. The word (shared) is then shown on the title bar after the worksheet’s title.
Saving A Shared Spreadsheet :
When you save a shared spreadsheet, one of several situations may occur:
• If the worksheet was not modified and saved by another user since you opened
it, the worksheet is saved.
• If the worksheet was modified and saved by another user since you opened it,
one of the following events will occur:
1. If the changes do not conflict, the worksheet is saved, the dialog below
appears, and any cells modified by the other user are shown with a red
border.
2. If the changes conflict, the Resolve Conflicts dialog is shown. You must
decide for each conflict which version to keep, yours or the other
person’s. When all conflicts are resolved, the worksheet is saved.
3. If another user is trying to save the shared worksheet and resolve
conflicts, you see a message that the shared spreadsheet file is locked
due to a merge-in in progress.
Note: Most spreadsheets software automatically turns off some features in shared
workbooks to simplify the workbook since multiple people can be working on the file at the
same time. For example, shared workbooks don‘t allow merging cells, conditional
formatting, or inserting pictures/graphs/etc
Record Changes :
Calc has the feature to track what data was changed, when the change was made, who made
the change and in which cell the change has occurred. for example
If you are the sponsor of a youth baseball team. The coach has submitted a budget to you
and you are concerned that the coach won’t see the changes you made, So you decided to
use Calc with the record changes feature turned on, so that the coach can easily see the
changes you have made.
How to turned on Record Changes feature ON :
1. Open the Shared Spreadsheet.
2. Select Edit > Changes > Record from the menu bar.
3. Begin editing the worksheet.
NOTE : A red colored border, with a dot in the upper left-hand corner, appears around a cell
where changes were made.
Viewing Changes :
Calc allows you to control what changes you see when reviewing a worksheet. To change the
available filters, select Edit > Changes > Show You can filter based on:
1. Date – Only changes made in a certain time range are displayed.
2. Author – Only changes made by a specific author are displayed.
3. Range – Only changes made in a specific range of cells are displayed.
4. Comment – Searches the content of the comments and only displays changes
which have comments.
5. Show accepted changes – Only changes you accepted are displayed.
6. Show rejected changes – Only changes you rejected are displayed
Adding Comment to a Change :
1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. Choose Edit > Changes > Comments.
4. Type your own comment and click OK.
NOTE : You can see the comment by hovering the mouse pointer over the cell.
Editing Comment :
1. Select the cell with the comment that you want to edit.
2. Select Edit > Changes > Comments.
3. Edit the comment and click OK.
Accepting or Rejecting Changes :
When you receive a worksheet back with changes. Now, as the original author, you can step
through each change and decide which change to accept and which one to reject. To begin
this process:
1. Open the edited worksheet.
2. Select Edit > Changes > Accept or Reject.
3. Calc steps through the changes one at a time. You can choose to accept or reject
each change
Merging Worksheets :
Sometimes, multiple reviewers return edited versions of a worksheet at the same time. In
this case, Calc provides the feature of merging worksheets
1. Open the original worksheet.
2. Select Edit > Changes > Merge Document.
3. A file selection dialog opens. Select a file you want to merge and click OK.

4. Accept or Reject Changes dialog opens and you can accept or reject the changes.
NOTE : Changes from different authors appear in different colors in the worksheet.

Comparing Documents :
When sharing worksheets reviewers may forget to record the changes they make. Calc can
find the changes by comparing worksheets.
In order to compare worksheets you need to have the original worksheet and the one that is
edited. To compare them:
1. Open the edited worksheet that you want to compare.

2. Select Edit > Compare Document.

3. An open worksheet dialog appears. Select the original worksheet and click Insert.
4. Calc finds and marks the changes

SESSION 4: CREATE AND USE MACROS IN


SPREADSHEET
Macro :
A macro is a saved sequence of commands or keystrokes that are stored for later use. Macros
are especially useful to repeat a task the same way over and over again

Using the macro recorder :


Use Tools > Macros > Record Macro to start the macro recorder. The Record Macro dialog is
displayed with a stop recording button. Click Stop Recording to stop the macro recorder.

Advantages of using Macro in Calc :


1. Macros automates the repetitive and routine tasks.

2. Macros speed up your process and reduce time.


SPREADSHEET : A spreadsheet is a grid which interactively manages and organizes data in
rows and columns. It is also called as Electronic Spreadsheet. It can also store, manipulate
and create graphical representations of data.
It is used for managing financial and accounting documents, creating data reports,
generating invoices, and for doing a variety of calculations on data etc.
Advantages of Spreadsheet : There are various advantages of spreadsheet software.
1. A spreadsheet software can create graphical representations of data.
2. It can be used to calculate and analyze the data for decision making.
3. It also provide built-in formulae and functions for common mathematical,
financial, statistical operations.
4. It is widely used for data analysis and accounting applications.
Examples of Spreadsheet software : Examples are
1. Microsoft Excel
2. LibreOffice Calc
3. OpenOffice Calc
4. Apple Inc. Numbers
LibreOffice Calc is used to perform the following activities accurately and efficiently.
1. Tabulation of data.
2. Simple mathematical calculations.
3. Complex calculations using formula and functions.
4. Arranging data in ascending and descending order.
5. Filtering the required data.
6. Check the validity of data.
7. Protection of data using passwords.
8. Saving for future use.
Starting LibreOffice Calc : LibreOffice Calc is the spreadsheet application of LibreOffice suite.
In Linux (Ubuntu) operating system, the LibreOffice gets installed by default. In Windows,
you need to download LibreOffice from its official website and install it on your computer.
Steps to open LibreOffice Calc in Window : In Windows, find the shortcut of LibreOffice on
Start menu or on the desktop. Double click the shortcut to open LibreOffice. Or Click the
window menu, select LibreOffice application, then click LibreOffice Calc.
Steps to open LibreOffice Calc in Linux : In Ubuntu Linux, find the Calc icon on application
launcher or search it by clicking on “Show Applications”.
Parts of LibreOffice Calc :
Following figure shows the parts of LibreOffice Calc. A brief explanation about the parts is
given below.

a. Title bar : The Title bar, located at the top, shows the name of the current spreadsheet.
The first created spreadsheet takes the name as Untitled 1, second is Untitled 2 and so on.
b. Menu bar : Menu bar is located just below the Title bar. It contains the menus with
commands for various tasks.
c. Toolbars : The Calc opens with the Standard and Formatting toolbars at the top of the
workspace by default. These toolbar provide a wide range of common commands and
functions. Placing the mouse cursor over any
icon displays a small box called a tooltip.
d. Worksheet : The worksheet in Calc is also referred to as spreadsheet. The spreadsheet can
have many sheets. Each sheet can have many individual cells arranged in rows and columns.
The sheet tab shows its default name as Sheet1, Sheet2, Sheet3, ….
e. Rows and columns : The sheet is divided into vertical columns and horizontal rows. Each
sheet can have
a maximum of 1,048,576 (220) rows and 1024 (210) columns. The rows are numbered as
1,2,3,4,… and columns are numbered as A, B, C, D, …., Z, AA, AB, AC, …., AZ …
f. Cell and cell address : The intersection of a row and column is called a cell. It is the basic
element of a
spreadsheet. It holds data, such as text, numbers, formulas and so on. A cell address is
denoted by its column (letter) and row number. For example, D4, E9, Z89 are the valid
example of cell address.
g. Active Cell : When we click on a cell it gets selected, and is ready to take data from the
user. This selected or activated cell is called an active cell. It is always highlighted, with a
thick border.
Key or Key
Result of Key or Combination
Combination

Arrow keys
Move a single cell in arrow direction
(←↑→↓)

Moves the cell to the end of the data range in a particular


Ctrl + Arrow Keys
direction

Home Moves to column A along the row where the active cell is

Ctrl + Home Moves the cell to A1 position

Ctrl + End Moves to bottom right cell of the data range

Page Up Moves the worksheet one screen up

Page Down Moves the worksheet one screen down

Let's Practice 1
Write the cell address of the following

• First row and first column _______________


• First column and last row _______________
• First row and last column _______________
• Last column first row ___________________
• Seventh column and tenth row _____________
• Tenth column and nineteenth row ____________
• The cell address LK89 is situated in row number ______________ and column letter _____________

SOLUTIONS :
Write the cell address of the following

• First row and first column A1


• First column and last row A1048576
• First row and last column AMJ1
• Seventh column and tenth row G10
• Tenth column and nineteenth row J19
• The cell address LK89 is situated in row number 89 and column letter __LK_
Range of cells: A block of adjacent cells in a worksheet which is highlighted or selected is
called a range of cells.

The column range is the number of cells spread across the column. The cell address is
represented by single column letter and multiple row number in a sequence.
for example C1 : C6, A9 : A18 etc.
The row range is the number of cells spread across the row. The cell address is represented
by single row number with different columns. for example C5 : H5, A2 : J2 etc.

The row and column range is the number of cells spread across the row and columns. This
range is a matrix with number of rows and number of columns. for example A3 : G5, D2 : H4
etc.

Let’s Practice 2
1. What is the address of the first cell represented by Range1?
2. What is the address of the last cell represented by Range1?
3. Write the cell range represented by Range1.
4. Write the cell range represented by Range 2.
5. What is the name of the cell range along a row?
6. What is the name of the cell range along a column?
7. Write the cell range represented by Range 3.
8. Give the number of cells in the cell range represented by Range 3.

Ans.

1. B5
2. D5
3. B5 : D5
4. F5 : F11
5. Range 1
6. Range 2
7. B7 : C12
8. 12
Entering data : The data to be entered in a worksheet can be the label, values or formula.
a) Label : Label is the any text entered by using a keyboard. It may combine with letters,
numbers, and special symbols. By default the labels are left aligned.
b) Values : The numerical data consisting of only numbers are called values. By default
values are right aligned.
c) Formulae : Any expressions that begins with an equals ‘=’ is treated as formula.
Mathematical operators used in formulae : Spreadsheet Software has the most powerful
features to calculate numerical data using formulae. LibreOffice Calc uses standard operators
for formulae, such as a plus(+), minus(-), multiplication (*), a division (/) for arithmetic
operation.
Mathematical Operators Operator precedence

Addition (+) First ( )

Subtraction (-) Second ^

Multiplication (*) Third /, *

Division (/) Third /, *

Exponentiation (^)
Electronic Spreadsheet Class 9 Notes
Note: The order of evaluation can be changed by using brackets.
Let's Practice 3

Evaluate the following equations using operator


precedence and then test the result in the spreadsheet.

1. 8-4/2 2. 5*5+8
3. 3+5*4 4. 2^5+8
5. 3+2^2 6. 5+6*2^2
7. 8/4*4 8. -4/2+2
9. 1+2^2-2 10. 4*3/2
Solution : You can easily solve the above expression by using simple Mathematics BODMAS rule
or you can also verify in spreadsheet by writing above expression after '=' sign in a cell and
then press enter key. for example
=8-4/2

Ans.
1. 6
2. 33
3. 23
4. 40
5. 7
6. 29
7. 8
8. 0
9. 3
10. 6
Note: Formula starts with ‘=’ sign and nothing should be written on the left side of the equal
sign (‘=’). If you
forgot to put the ‘=’ before the formula, it will be treated as a label.
Steps to rename sheet :
1. Select the menu Sheet → Rename Sheet.
2. Give appropriate name and click OK
Steps to save the worksheet : To save the worksheet
1. click on File → Save.
2. A Save dialog box will appear.
3. Select the location where you want to save the file.
4. Enter the name of the file say, ‘Bill’
5. Click on the Save button.
Steps to insert the column before any column : Position the cursor on any cell of the column
before which you want to insert the column and select Sheet → Insert Columns → Columns →
Columns left
Steps to insert the column after (right side) any column : Position the cursor on any cell of
the column after which you want to insert the column and select Sheet → Insert Columns →
Columns → Columns right.
Function : Functions are predefined formula in Calc which is used for tasks like finding the
sum, count, average, maximum value, and minimum values for a range of cells.
Commonly used basic functions in Calc
Function Syntax Use

Adds the values contained in a


SUM =SUM(Number1,Number2,…..)
range of cells.

Return the average of the values


AVERAGE =AVERAGE(Number1,Number2,….)
contained in a range of cell

Return the largest/Maximum


MAX =MAX(Number1,Number2,……) value contained in a range of
cells

Return the Smallest/Minimum


MIN =MIN(Number1,Number2,……) value contained in a range of
cells

Return the Counts of the


COUNT =COUNT(Number1,Number2,…..) number of cells within a range
of cells.
Formatting the worksheet : The cell data can be formatted using Format cells dialog box.
The Format cells dialog box can be opened using Format→cells using the Format menu, or
from context menu opened through right clicking the cell. Shortcut to open this Format Cell
dialog box is Ctrl+1. Various options of Format cell dialog box are shown below.
a) Formatting a range of cells with decimal places : Following are the steps to format a cell to
the required number of decimal places:
1. Select the range of cells.
2. Open the ‘format cells dialog’ box
3. Click the ‘Number’ tab
4. Select the ‘Number’
5. Change the decimal places as required
6. Click ‘OK’
b) Formatting a range of cells to be seen as labels : Follow the steps below in order to format
a range of cells as text.
1. Select the range of cells
2. Open the ‘format cells dialog’ box
3. Click the Number tab
4. Select Text
5. Click ‘OK’
6. Enter numbers
c) Formatting of a cell range as different date format : In a spreadsheet application, the user
can change Date in many different formats. To do these follow the below steps.
1. Select the range of cells.
2. Open the ‘Format cells dialog’ box
3. Click the ‘Number’ tab
4. Select the ‘Date’ category
5. Select the date format
6. Click ‘OK’
d) Formatting a range of cells to display times : Follow the steps below to format a range of
cells to display the time.
1. Select the cell range
2. Open the ‘format cells dialog’ box
3. Click the ‘Number’ tab
4. Select the ‘Time’ category
5. Select category Time should be displayed
6. Click ‘Ok’
e) Formatting alignment of a cell range : Follow the steps below to format the alignment of
range of cells.
1. Select the range of cells
2. Open the ‘format cells dialog’ box
3. Click the ‘Alignment’ tab
4. Select left, right or center
5. Click ‘OK’
Fill handle of a cell : The small black square in the bottom-right corner of the selected cell or
range is called a fill handle.

Referencing : Referencing is the way to refer the formula or function from one cell to the
next cell along the row or column. There are three types of referencing.
1. Relative referencing
2. Mixed referencing
3. Absolute referencing
1. Relative referencing : When you drag any formula in any row or column in any direction,
the formula gets copied in the new cell with the relative reference. for example A1, H15 etc.
2. Mixed referencing : In Mixed Referencing, the $ sign is used before row number or
column name to
make it constant. for example A$5, $C14.
3. Absolute referencing : In Absolute referencing, a $ symbol is used before the column
name as well as row number to make it constant in any formula. For example, $C$12, $D$5,
etc.
Identify the cell referencing in the following table:

Example Type of Refencing

A1 Relative

F45 Relative

D$4 Mixed

$A23 Mixed

$A$2 Absolute

Creation of Charts Using Spreadsheets : It is not easy to comprehend, compare, analyze or


present data when they are represented as numbers. But when data are presented in the
form of charts they become an effective tool to communicate. The various types of charts
are given below.

Types of Charts

Column Chart

Bar Chart

Line Chart

Pie Chart

XY Scatter Chart

Steps to create a column chart :


1. Select the range of data say A1:F7
2. Click on Insert → Chart
3. Select the type of chart ie Column chart
4. Click Finish
QUESTIONS:
Q1. How can we rename a worksheet?
Ans. There are three ways you can rename a worksheet
a. Double-click on one of the existing worksheet names.
b. Right-click on an existing worksheet name, then choose Rename from the resulting Context
menu.
c. 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.
Q2. What are the two ways of referencing cells in other worksheets?
Ans. Two ways to reference cells in other sheets: by entering the formula directly using the
keyboard or by using the mouse.
Q3. Differentiate between Relative and absolute hyperlinks.
Ans. Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet. An
absolute link will stop working only if the target is moved. A relative link will stop working only if
the start and target locations change relative to each other. For instance, 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 not break.
Q4. List the procedure involved in Linking HTML Tables to Calc Worksheet.
Ans. You can insert tables from HTML documents, and data located within named ranges from an
OpenOffice.org Calc or Microsoft Excel spreadsheet, into a Calc spreadsheet.
We can do this in two ways: using the External Data dialog or using the Navigator.
Using the External Data dialog
a. Open the Calc worksheet where the external data is to be inserted. This is the target worksheet.
b. Select the cell where the external data is to be inserted.
c. Choose Insert -> Link to External Data.
d. On the External Data dialog, type the URL of the source worksheet or click the […] button to
open a file selection dialog. Press Enter to get Calc to load the list of available tables.
e. In the Available tables/range list, select the named ranges or tables you want to insert. You can
also specify that the ranges or tables are updated every (number of) seconds.
f. Click OK to close this dialog and insert the linked data.
Electronic Spreadsheet
Q5. What is the purpose of adding comments?
Ans. Comments are mostly used in shared Calc sheet which is used to explain the changes made in
the sheet to the author of the sheet.
Q6. How can we add comments to the changes made?
Ans. Comments can be added as follows:
1. Make the change to the spreadsheet.
2. Select the cell with the change.
3. Choose Edit > Changes > Comments. The automatically-added comment provided by Calc
appears in the title bar of this dialog and cannot be edited.
4. Type your own comment and click OK.

After you have added a comment to a changed cell, you can see it by hovering the mouse pointer

over the cell.

Q7. What are Macros?

Ans. A macro is a saved sequence of commands or keystrokes that are stored for later use. Macros
are especially useful to repeat a task the same way over and over again.

Q8. How can we record a Macro?

Ans. Steps to record macro are as follows

a. Use Tools > Macros > Record Macro to start the macro recorder. The Record Macro dialog is

displayed with a stop recording button.

b. Perform the actions you want to be recorded in the document.

c. Click Stop Recording.

d. The Macro dialog appears, in which you can save and run the macro.

Fill in the blanks (Electronic Spreadsheet (Advanced))

1. At the bottom of each worksheet window is a small tab that indicates the name of the
worksheets in the workbook.

2. 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.

3. Spreadsheet software allows the user to share the workbook and place it in
the Network location where several users can access.

4. Spreadsheet software can find the changes by Comparing Sheets.

5. Macros are useful to repeat a task the same way over and over again.

You might also like