Chapter -7

Spreadsheet Software
Exercises
A. State true or false.
a. An electronic spreadsheet is used to write an application. (False)
b. A worksheet is divided into different rows and columns. (True)
c. Numbers are aligned to the left within a cell. (False)
d. Built-in functions make a formula short. (True)
e. SUM() is used to find the product of values of the cells. (False)
f. F3 is pressed to edit the content of a cell. (False)
g. Formulas cannot be copied. (False)
h. % symbol is used to calculate percentage. (True)
i. Ctrl+C is a shortcut for copy. (True)
j. 1A is the address of the first cell of the worksheet. (False)

B. Fill in the blanks.

a. An Excel file is referred to as a workbook.
b. The intersection of a row and column is called a cell.
c. The cell which has a dark border around it is the active cell.
d. A formula is a sequence of values, cell references, names, functions, or
operators that produces a new value.
e. Fill handle is a small square box at the bottom right corner of the active
cell.
f. f. Every formula begins with the equals sign (=).
g. Ctrl+O is pressed as a shortcut key to open a workbook.
h. AVERAGE() is used to find the average of numeric values in a range of
cells.
i. To find the maximum value of numeric values in a range of cells, MAX()
function is used.

C. Answer the following questions.

What is an electronic spreadsheet program? Give examples.
An electronic spreadsheet program is a software application used for organizing,
analyzing, and storing data in a tabular format. It allows users to input data into
cells, perform calculations, create charts, and generate reports based on the entered
data. Examples of electronic spreadsheet programs include Microsoft Excel,
Google Sheets, Apple Numbers, and LibreOffice Calc.
b. Explain the automatic recalculation feature of those electronic spreadsheets.
The automatic recalculation feature in electronic spreadsheets ensures that
formulas and functions are updated dynamically whenever the data in the
spreadsheet changes. This means that if any cell referenced in a formula is
modified, the affected formulas and functions will recalculate automatically
without requiring manual intervention. This feature helps maintain accuracy and
efficiency in data analysis and ensures that users always have up-to-date results.
c. Write short notes on Title bar, Menu bar, Toolbar, Formula bar, and Status
bar.
 Title Bar: The title bar is located at the top of the spreadsheet window and
displays the name of the current workbook or document.
 Menu Bar: The menu bar contains a series of menus such as File, Edit,
View, Insert, Format, etc., which provide access to various commands and
functions within the spreadsheet program.
 Toolbar: The toolbar typically contains icons or buttons that provide quick
access to commonly used commands or functions, such as formatting tools,
font styles, and alignment options.
 Formula Bar: The formula bar displays the contents of the currently
selected cell, including any formulas or data entered into the cell. It also
allows users to edit the contents of the cell directly.
 Status Bar: The status bar is located at the bottom of the spreadsheet
window and provides information about the current status of the spreadsheet,
such as cell mode (e.g., Edit mode), sum of selected cells, and other relevant
details.
d. What are the workbook and worksheet?
In electronic spreadsheet programs like Microsoft Excel, a workbook is the main
file that contains one or more worksheets. Each worksheet is an individual
spreadsheet within the workbook where users can enter, manipulate, and analyze
data. Workbooks help organize related data sets, while worksheets allow users to
work with specific datasets or perform different types of analyses within the same
file.

Workbook Worksheet
 The entire file containing  A single sheet within a spreadsheet
multiple sheets or worksheets. file.
 Contains one or more  Contains rows, columns, and cells.
worksheets.
 Manages different sets of data  Handles specific data or
or analysis within a single file. calculations.

e. What is a cell? How do you refer to a particular cell?

A cell in an electronic spreadsheet is the intersection of a row and a column and is
the basic unit for storing and manipulating data. Each cell is uniquely identified by
its column letter and row number, such as A1, B2, C3, etc. Users refer to a
particular cell by specifying its cell address, either by clicking on it directly or by
typing its address into the reference box.
f. What is an active cell?
An active cell in an electronic spreadsheet is the currently selected cell, typically
indicated by a highlighted border or cell outline. It is the cell where any data entry,
editing, or manipulation actions will occur. Users can navigate through the
spreadsheet using the keyboard or mouse, and the active cell changes accordingly
to reflect the user's current position within the worksheet.
g. What is the block of cells?
A block of cells in an electronic spreadsheet refers to a contiguous group of cells
selected together for a specific purpose. Users can select multiple cells
simultaneously by clicking and dragging the mouse cursor over the desired range
of cells or by using keyboard shortcuts. Blocks of cells are commonly used for
applying formatting, performing calculations, or copying data across multiple cells
simultaneously. They allow users to manipulate data efficiently and perform
actions on a larger scale within the spreadsheet.
h. What are the constant values?
Constant values in a spreadsheet are fixed values that do not change, such as
numbers, text, or dates, used in calculations or data analysis.
h. What is a formula? With which symbol does the formula begin?
A formula in a spreadsheet is a mathematical expression used to perform
calculations or manipulate data. Formulas always begin with the equals sign (=) in
electronic spreadsheets, indicating to the software that what follows is a calculation
to be performed rather than text or data.
j. What are the advantages of using built-in functions in MS Excel?
The advantages of using built-in functions in MS Excel listed in point form:

 Built-in functions offer pre-defined operations, making complex

calculations easier to perform without the need for writing lengthy
formulas.
 These functions are designed to handle calculations accurately, reducing
the risk of errors in data analysis.
 By automating tasks, built-in functions save time and effort, allowing
users to focus on interpreting results rather than performing manual
calculations.
 Users can quickly analyze data and generate reports, improving overall
efficiency in data-related tasks.
 With the help of built-in functions, users can complete tasks more
efficiently, leading to improved productivity in data management and
analysis.
j. Write the functions and the syntax of the following built-in functions:
SUM(), AVERAGE(), MIN(), MAX().
 SUM(): Adds up all the numbers in a range of cells. Syntax:
=SUM(number1, [number2], ...).
 AVERAGE(): Calculates the average of numbers in a range of cells. Syntax:
=AVERAGE(number1, [number2], ...).
 MIN(): Returns the smallest number in a range of cells. Syntax:
=MIN(number1, [number2], ...).
  MAX(): Returns the largest number in a range of cells. Syntax:
=MAX(number1, [number2], ...).
m. What is the use of the fill handle?
The fill handle in MS Excel is a small square box located at the bottom right
corner of the active cell. It is used for quickly copying data or formulas to adjacent
cells by dragging the fill handle across the desired range of cells. This feature helps
streamline repetitive tasks such as filling a series of numbers, dates, or applying a
formula to a range of cells.