Topic 10:Spreadsheets

Beschreibung

Mindmap am Topic 10:Spreadsheets, erstellt von tia fenn am 11/02/2015.
tia fenn
Mindmap von tia fenn, aktualisiert more than 1 year ago
tia fenn
Erstellt von tia fenn vor etwa 10 Jahre
12
0

Zusammenfassung der Ressource

Topic 10:Spreadsheets
  1. A spreadsheet application such as excel can store all its data in a single file.This is called a workbook.
    1. A workbook is made up of one or more worksheets, A worksheet is a single tab in the spreadsheet workbook.
    2. Cells
      1. A cell reference always starts with a letter and ends with a number e.g. A5 or H28
        1. A range of cells is a set of cells in a row or column
          1. Data entered into cells can be different data types e.g. text, number, currency, date, percentage etc.
            1. Each cell can contain:
              1. Labels- any text in a cell describing the data in a row or column
                1. Data- any values that are entered for the use of calculation
                  1. Formulas and functions- mathematical calculations carried out automatically
                2. Formulas
                  1. Must start with an =
                    1. formulas perform calculation son the cell contents
                      1. formulas appear in the formula bar
                        1. The result of a formula is automatically recalculated every time the data on a spreadsheet changes
                          1. 4 main mathematical operations
                            1. + add
                              1. - substract
                                1. * multiply
                                  1. / divide
                                2. Funtions
                                  1. Must also start with an =
                                    1. Functions are part of spreadsheet software. They are specialised calculations built in to the spreadsheet software
                                      1. Function name describes what a function can do SUM, COUNT, AVERAGE, MIN, MAX, IF.
                                        1. =SUM(D2:F7)
                                      2. formatting
                                        1. The content of a cell can be formatted
                                          1. Font style, size, colour, border style, aligment, cell colour.
                                            1. multiple cells can be merged into one cell
                                            2. Cells are often formatted to reflect the data that is held I them. Data types include:
                                              1. currency, number,
                                            Zusammenfassung anzeigen Zusammenfassung ausblenden

                                            ähnlicher Inhalt

                                            Zeitformen
                                            JohannesK
                                            Deutsch Abitur 2016: Sprache
                                            Lena S.
                                            Reformation - Absolutismus
                                            Isabell Ilmer
                                            Verwitterung Transport und Sedimentation
                                            Weltraumkatze Fanroth
                                            Deutsche Grammatik A1-A2
                                            Marcus Hartmann
                                            Vetie - AVO 2018
                                            Fioras Hu
                                            Bildungspsychologie und Evaluation
                                            Daniel Martinovic
                                            Reprospass 4
                                            S J
                                            Vetie - Patho - 2014
                                            steff Müller
                                            Vetie - Lebensmittelkunde 2017
                                            Birte Schulz
                                            Vetie - Lebensmittel 2016
                                            Kim Langner