REPUBLIC OF THE PHILIPPINES

TECHNOLOGICAL UNIVERSITY OF THE

PHILIPPINES
COLLEGE OF INDUSTRIAL EDUCATION
PROFESSIONAL INDUSTRIAL EDUCATION
DEPARTMENT
Ayala Blvd, Ermita, Manila, 1000 Metro
Manila

INFORMATION SHEET 1.1.2

Advance Electronic Spreadsheet for managing information

I. Learning Objectives:

1. learn how to make and use formula in different situations in excel

2. Formulate and operate different formulas in excel
3. Use and apply all the acquired knowledge for making different tasks (tracking of monthly
budget, computing and making of grades)

II. Discussions

Microsoft Excel - Excel is a spread sheet developed by Microsoft for Windows, macOS, Android
and iOS. It features calculation, graphing tools, pivot tables, and a macro programming
language called Visual Basic for Applications. It has been a very widely applied spreadsheet for
these platforms. You can also use Microsoft Excel in tiling or multiple tiled pictures to make the
image much bigger when it is printed.
In 1978, Harvard Business School student Dan Bricklin developed a program called VisiCalc. It
was a relatively small program with few basic capabilities. It could only calculate data within a
matrix of 5 columns by 20 rows.

To make VisiCalc more powerful Bricklin hired Bob Frankston, who is also known as the co-
creator of VisiCalc. Frankston made the program fast and with better arithmetic. VisiCalc was an
instant success and the duo were able to sell around 1 million copies of the program.

Excel Program Window Worksheet

Parts of Excel Program Window Worksheet

Formula Bar – Formula Bar is toolbar at the top of the Microsoft Excel
spreadsheet window that you can use to enter or copy an existing formula in to
cells or charts. It is labeled with functions symbol (fx). By clicking the Formula Bar,
or when you type an equal (=) symbol in a cell, the
Formula Bar will activate. Formula bar is also use if you want to edit something on
your spread sheet.

Office Button – Office button is found in the top-left corner of the word and other
Microsoft Office .This is manipulate your file in an instance. When the Office
Button is clicked, many of the same options you’d see in the File menu, such as
New, Open, Save, print etc., can be found. Listed below are the commonly used
options found in the Office button menu and their function.

Office button menu function

· New – Create a new, blank file in the Office program (e.g., Word document,
Excel spreadsheet, PowerPoint slid deck, etc.).
· Open – Open an existing file on the computer.
· Save – Save changes to the currently open file.
· Save As – Save anew file with a desired file name and to a desired location on
the computer’s hard drive.
· Print – Print a hard copy of the currently open document on a printer.
· Close – Close the current open file.
· Share – Share the currently open document to other users through the use of
OneDrive, by sending through e-mail, posting to a blog.
· Options – Changes configuration settings for the Office program, including
display settings, spelling and grammar check settings, languages settings, and the
Ribbon configuration
Help Button – Help Button is like a help desk office where you can ask about
something on your excel of other Microsoft Offices. It is too small that will be
easily ignored. Actually the Help button says in the top right corner of the
window. The button looks like a question mark surrounded by a circle. The
following picture shows its position. Or you can use the shortcut key F11 to
enable the Help window.

Ribbon – The ribbon is the strip of buttons and icons located above the work area
that was first introduced in Excel 2007. The ribbon replaces the menus and
toolbars found in earlier version of excel.

- Above the ribbon are a number of tabs, such as Home, Insert, and Page Layout.
Clicking on a tab are a number of groups that display the commands located in
this section of the ribbon. For example, when Excel opens, the commands under
the Home tab are displayed. These commands are grouped according to their
function.

Name Box – Name box is a box to the left formula bar that displays the cell that is
currently selected in the spreadsheet. If a name is defined for a cell that is
selected, the Name Box displays the name of the cell. You can use the Name Box
to define a name for a selected cell as well. This may help you to easily identified
on what particular area in your excel you are and what are you going to modified.

Active Cell – Active cell is alternatively referred to as a cell pointer, current cell, or
selected cell, an active cell is a rectangular box that highlights the cell in a
spreadsheet. An active cell helps identify what cell is being worked with and
where data will be entered. Using Active cell this may help you also to copy a
particular formula of object on your ac tive cell by dragging it down or up.
Work Area – Work Area appears when using the exploration or list mode, is a
Microsoft Excel workplace where you place data items for the crosstab or list
reports that you design. After placing items in the Rows, Columns, Measure, and,
optionally, Context of the exploration, or Columns of the list, the data appears in
the cells of the worksheet. The whole excel itself is your workplace.

Sheet Tab – In Microsoft Excel, a sheet, sheet tab, or worksheet tab is used to
display the worksheet that a user is currently editing. By clicking a worksheet tab
(located at the bottom of the window), users may move between the various
worksheets. You can also customize or edit the name of your working sheet, this
is to identify what particular area or file you are dealing with.

Status bar – A status bar is horizontal window at the bottom of a parent window
in which an application can display various kinds of status information. The status
bar can be divided into parts to display more than one type of information. The
following screen shot shows the status bar in the Microsoft Windows Paint
application.

View Buttons – View buttons are a feature that lets you change how the
presentation or document appears.

Use the Analysis Tool Pak to perform complex data analysis

If you need to develop complex statistical or engineering analyses, you can save
steps and time by using the Analysis Tool Pak. You provide the data and
parameters for each analysis, and the tool uses the appropriate statistical or
engineering macro functions to calculate and display the results in an output
table. Some tools generate charts in addition to output tables.
The data analysis functions can be used on only one worksheet at a time. When
you perform data analysis on grouped worksheets, results will appear on the first
worksheet and empty formatted tables will appear on the remaining worksheets.
To perform data analysis on the remainder of the worksheets, recalculate the
analysis tool for each worksheet.

The Analysis ToolPak includes the tools described in the following sections. To
access these tools, click Data Analysis in the Analysis group on the Data tab. If the
Data Analysis command is not available, you need to load the Analysis ToolPak
add-in program.

III. Documentation
IV. Reflection

After studying more about MS Excel, I learned how to activate the Data Analysis and it’s
command. To activate the data analysis, First click File, then find and click Options, then find
and click Add-ins. After this you will see now the Analysis toolpack then select it then for the
last step click go and put check to analysis toolpack and then click ok. For using or getting
summary statistics, first prepare your desired value (using rand between(=randbetween
(top,bottom)) then click Data Analysis, Select Input Range and highlight the data(columns or
rows) then check the Summary Statistics and for the last step, select Output Range and select a
space on present worksheet to display the output of summary statistics then design it to
become more presentable. I also learned how to make and compute grades in using MS Excel
which is applicable to our career as future educator. All these things are my learning after
studying the basic of Microsoft Excel.