Chapter 5 Range Management

1. Chapter 5 Range Management • Objective -Learn the concept of range • Goals -The students will apply the procedures of range selection to the spreadsheet. -The students will use different ways of entering data to a range. -They will learn to copy, cut, and paste a range. -The students will designate names to ranges.

2. 5.1 Introduction A range is a group or block of specific cells to facilitate their processing. In a spreadsheet, a range may be only the selection of cells or else it can perform operations through its reference. Block Begins A1:A6 Range Block Ends

3. 5.2 Selection To select a range, it is necessary to define first the beginning and the end of the block we want to manipulate. Therefore, place the pointer device of the mouse at the beggining of the block; click once and drag the mouse toward the desired direction until reaching the end. Notice that the range selected was carried out by highlighting the whole block.

4. Complete Column Selection A complete column can be selected just by clicking once on the heading (A, B, C,… etc.) • Complete Row Selection To select a complete row, click once with the mouse on the heading (1, 2, 3,… etc.) • Complete Sheet Selection You can select the whole sheet only by clicking with the mouse on the complete sheet selection button. • Selection of Range formed by Non Adjacent Blocks To several blocks, it is necessary to hold the Control key pressed (during the whole operation), and then proceed to highlight each onne of the blocks that will form the range.

5. Spreadsheet conceptThe Spreadsheet is the computerized versión ofthe pape' sheets prinied withhorizontal and vertica! iines to be divided ¡n rows and coiutnns. These tools areused manually by accountants and their function is to organize Ítems intoaccountable quantities. These are known as spreadsheetsAt present, the term Spreadsheet describes just the basic aspecí of íneapplication because it has evoived togeíherwiíh persona! compi-iters e>isíing 3great variety of commerciai producís that intégrate tooic- for the creaüon oigraphs, basic drawings, predefined functions, data base macros managemení,among others.The common feature for any software developed as a Spreadsheet is iisstructure through which it can achieve the perfect organization plan íhat makesits operation possible.Next, we.wiH meníion three important basic aspecís to undersíand th'ssoftware,1, The structure of rows and coiumns delimits the workng área inío spacescalled cells. See figure 1.1.Figure 1 1 Spreadshee! structur'?Culumnas --5.3 Data Entries A range simplifies the entry of data in two ways: • Capturing data in a selected range. • Filling in automatically. • Repetitive Entry To make a repetitive entry, first capture the initial data. This can be any kind if data. Then proceed to select the range, including the captured value, with the following sequence: Edit, Fill, where a menu will be displayed with the following options, among others: Downward, To the right, Upward, To the left.

6. 5.4 Copying a Range Copying a range is the action ehwre a duplicate of the range is transported to the briefcase. Once selected the block to be copied, click once in the copy button in the tool bar or follow the sequence Edit, Copy. This action helps us copy the selection cells into the briefcase.

7. 5.5 Moving a Range Cutting or moving a block of cells means to make themdisappear from their original place to transfer them to the briefcase. This operation is carried out first with the selection of the block to be moved and then with the sequence: Edit, Cut or else with the Cut button in the Tool bar. The briefcase shall remain occupied until we place the block in another place in the sheet. This can be done with the paste option in the edit menu or else activating the Paste button in the tool bar.

8. 5.6 Erasing a Range This operation can be carried out following the sequence: Edit, Erase, once the cell block has been selected. When you want to recover the range, just click once in the undo button or else in the edit menu choose undo erase.

9. 5.7 Assigning a Name to a Range Assigning a name to a range or cell means to call it in another way that facilitates its reference. You must take into account that the name may have up to 255 characters. The first must not be a numerical character; punctuation marks must not be used; and the name must not be assigned to two different ranges. An alternate process will be: Select the block of cells that will receive the new name. Click once in the displayable arrow in the Name box ofthe formula bar. Write the name and press Enter.

10. Chapter 6 - Functions • Objective -Use predefined functions built in the spreadsheet. • Goals -The students will be able to define a function. -The student will acquire the necessary knowledge to work with functions in the spreadsheet.

11. 6.1 General Concepts • Definition of Function A function is a predefined formula that carries out calculations using specific values called arguments. Arguments can be numbers, text, logical values such as TRUE or FALSE, matrixes, error values such as #N/A or cell references.

12. 6.2 Format of a Function Functions are made up by two elements which are: • Name • Argument The syntax indicates the way a function must be written to be recognized by the built-in software. As any formula, it begins with the sign = (equal to), then it is followed by the name of the function, followed by an opening parenthesis, the arguments separated by commas, and a closing parenthesis. Syntax: =FUNCTION(argument 1, argument 2, …, argument n) Example: =ADDITION(B4, A2: A10, 78)

13. Introducing Functions There are two ways to introduce funtions ina cell. The first one is writting directly in the cell, the name and its arguments. The problem with this option is that you must know very well the syntax of the function to make no mistakes. The second one is the menu, Insert, the option Function, and the dialogue window Paste function. You can access this window also from the tool bar through the button called paste function.