Brushing Up on Worksheets

Brushing Up on Worksheets

By Joenalyn V Leon _ Our Lady of Caysasay Academy

Objectives:

1. Identify what an MS Excel is.

2. Determine the different features in MS excel and

Some text here about the topic of discussion

2. Identify the uses of MS Excel.

Open Ended

What is MS ExceL?

​name derived from the word “cell” which is the basic part of the a spreadsheet

A cell can hold data which can be letters or numbers.

Microsoft Office Excel

üperform the calculation, analysis, and visualization of data and information.

üorganize and process data by the use of columns and rows with formulas and some cool features

Microsoft Office Excel

In MS Excel 2010, row numbers range from 1 to 1048576. There are total 1048576 rows, and columns range from A to XFD and there are total 16384 columns.

Microsoft Office Excel

MS Excel Features

Fill in the Blank

This part allows you to type text in the box.

Fill in the Blank

Shortcut key for Hyperlink

Fill in the Blank

Which tab in MS Excel allows you to insert pictures/graphics?

Fill in the Blank

Which tab holds the freeze/unfreeze panes?

Fill in the Blank

Tab which allow you create charts

Keyboard Shortcuts

Fill in the Blank

Shortcut key that brings you to the starting page of a Spreadsheet

Fill in the Blank

Shortcut key that brings you to the end page of a Spreadsheet

Fill in the Blank

Shortcut key to edits the active cell’s content without overwriting

Fill in the Blank

Shortcut key that navigates the cells instead of using a mouse

Fill in the Blank

Shortcut key that overwrites the cell’s previous entry after typing your data on that cell

Open Ended

What are the uses of MS Excel?

​Uses of MS Excel

​üfor making forms and tabular documents

üfor accounting purposes (employee payroll)

for importing/exporting database data to Excel (graphing data

üfor Macros to make programs embedded in an Excel document

üfor storage of data and making a simple database​

MS Excel can be shared to Internet by: 

üAttaching to e-mails

üUploading to an FTP or web server

üLinking the .xlsx document from an HTML webpage

üInserting into an HTML document​

​What are your learnings for today's lesson?

​

Just click the link below to put your answer:​

​

https://padlet.com/joe0304deleon/xbsg8aoipmneav6e

​