Please enable JavaScript.

Coggle requires JavaScript to display documents.

Spreadsheet (Microsoft Excel) - Coggle Diagram

- - - - The standard Excel screen (the one that appears at startup) looks similar to the one presented below, although as we will see later, its appearance can be modified to suit the needs of each user.
        
        The different bars
        The title bar: contains the name of the document on which you are currently working. When a new book is created, it is temporarily named Book1, until it is saved and assigned a different name. On the far right are the minimize, restore, and close buttons.
        
        The menu bar
        Contains Excel operations, grouped in drop-down menus. Clicking on each of the options displays the contents related to that option.
        All the operations can be done from these menus, although the most common operations are carried out more quickly from the icons of the other bars that will be seen below.
        The icon with the cross, on the far right, closes the current book.
        
        How do they work? When Excel is opened the menus contain only the most frequently used commands. In this way the menus are simpler.
        To access the rest of the commands, you have to hover over the last button and you get the full menu, although those commands that didn't appear before are in a lighter color. That is to say, when using a command that is not in the initial menu, this command is incorporated from that moment on into the menu.
        On this same screen, if you opt for the "smart" behavior of the menus, you can also activate the Show complete menus after a few seconds box so that the complete menu is displayed without having to press the last button.
        
        Help
        To activate Excel Help, you can press F1 or click on the question mark on the menu bar. The options of this menu allow:
        a) Go to help: showing a screen where you can see help through an Index, search by words in Content or through the Help Wizard that allows you to ask questions in natural language.
        b) Show the Office assistant: it is an animated graphic that helps on certain occasions when it detects that help is needed, for example if it sees that we are going to create a spreadsheet it will offer us help for it, etc.
        c) Use What is this?: The cursor turns into an arrow with a question mark and when placed over an element on the screen it gives an explanation of the function of that element.
- - - - The intersection of a column and a row are called Cell and it is named with the name of the column to which it belongs and then the number of its row, for example the first cell belongs to column A and row 1 therefore the cell is called A1.
        At any time the cursor is positioned in a cell ready to work with it, said cell is called Active Cell and it is identified because it appears more highlighted than the others.
        Another very important concept in a spreadsheet is Range, which is a rectangular block of one or more cells that Excel treats as a unit. The ranges are vital in the Spreadsheet, since all kinds of operations are carried out based on ranges.
      - Fast Movements on the Sheet
        Only a small part of the sheet is visible in the document window at any given time. It will usually be occupied by a greater number of cells than are visible in the screen area and it is necessary to move through the document quickly.
- - - - Functions: A function is a special formula written in advance that accepts a value or values, performs calculations, and returns a result.
        All the functions have to follow a syntax and if this is not respected, Excel will show us an error message.