Week 12 - What is a spreadsheet?

 OBJECTIVE OF THE CLASS

Identify the essential elements of the spreadsheet work environment, its essential components and the key elements to start working on spreadsheets.

WHAT IS A SPREADSHEET?

It’s a grid shaped file where you can save information of many kinds such as texts, numbers, dates, links and you can also perform simple arithmetic calculations through operators or functions.It is also a tool with which we can organize and locate information, in addition to creating graphics of different types.
The main elements in a worksheet are cells, columns, and rows. Each of these has a unique name that allows us to identify
them. How do we know the name of each of these elements?

Don’t forget that columns are vertical sets of cells with letter names. Rows are horizontal sets of cells with number names.

PROCEDURES FOR SELECTING CELLS

Although the logical procedure to select in a spreadsheet is to drag with the mouse, I’ll indicate to you some other procedures that you have to know.

• By clicking on a cell or by using the arrow keys you can select a single cell.

• By dragging with the mouse or using Shift plus the arrow keys, you will select a range, that is, a set of

cells all together.

• By clicking on the names of the columns (letters) or rows (numbers) you will select them. You can also

drag over the names to select multiple columns or rows.

• To make separate ranges selections you can press the "Control" key to keep the previous selection.

CELL FORMATS

Although there are different types of formats that can be applied to the content of a cell, this time we will only know the basics.

• Font

• Filling

• Alignment and orientation

• Borders