Excel Spreadsheet

Descrição

GCSE Computer Science Mapa Mental sobre Excel Spreadsheet, criado por 12brandon.m em 09-12-2015.
12brandon.m
Mapa Mental por 12brandon.m, atualizado more than 1 year ago
12brandon.m
Criado por 12brandon.m mais de 8 anos atrás
36
2

Resumo de Recurso

Excel Spreadsheet
  1. Home
    1. Font
      1. basic typing
        1. type in numbers and letters
          1. change the layout of cells
            1. edit text
            2. alignment
              1. edit the position of text or unmbers in cell
              2. number
                1. change the format of numbers
                  1. currency
                    1. general
                      1. percentage
                    2. Editing
                      1. edit the cells format
                        1. use a function to change the cells properties
                          1. Fill- continue with a set pattern for multiple cells
                            1. find and search
                              1. clear- delete everything in that cell
                          2. Insert
                            1. Tables
                              1. add tables to make work look professional and to add clarity to work as it will be easier to use
                              2. illistartions
                                1. charts
                                  1. are used to add a clear final presentation of the data used in spreadsheet
                                    1. bar charts, line charts, pie charts , scatter charts.
                                    2. add pictures and logos to spreadsheet
                                    3. Links
                                      1. use hyper links to link your spreadsheets to other attachments which make it easier than searching up the website or finding the attachment
                                        1. saves space on your spreadsheet
                                      2. Page Layout
                                        1. Pre defined Themes and formatting tool bars
                                          1. can add different effects
                                            1. looks prettier
                                            2. use different fonts
                                              1. different colours
                                              2. page setup
                                                1. different size margins to fit your size of spreadhsheet whilst keeping it clean
                                                  1. change the options for your spreadsheet
                                                    1. change the background
                                                    2. Print
                                                      1. have different options on how to print your work such as in different sections
                                                  2. Formulas
                                                    1. =AVERAGE
                                                      1. =SUM
                                                        1. =HIGHEST
                                                          1. =LOWEST
                                                            1. IF STATEMENT
                                                              1. Autosum
                                                                1. use suitable formulas for different purposes
                                                                  1. data with functions in automatically update when data is chanhed
                                                                  2. Data
                                                                    1. import
                                                                      1. import data to create specific spreadsheets by using different functions
                                                                      2. export
                                                                        1. use data from spreadsheet and other sources and create new spreadsheets from this
                                                                          1. use web to search up sources
                                                                        2. Operating systems providers
                                                                          1. microsoft excel
                                                                            1. numbers (apple)

                                                                            Semelhante

                                                                            Computing Hardware - CPU and Memory
                                                                            ollietablet123
                                                                            SFDC App Builder 2
                                                                            Parker Webb-Mitchell
                                                                            Data Types
                                                                            Jacob Sedore
                                                                            Intake7 BIM L1
                                                                            Stanley Chia
                                                                            Software Processes
                                                                            Nurul Aiman Abdu
                                                                            Design Patterns
                                                                            Erica Solum
                                                                            CCNA Answers – CCNA Exam
                                                                            Abdul Demir
                                                                            Abstraction
                                                                            Shannon Anderson-Rush
                                                                            Spyware
                                                                            Sam2
                                                                            HTTPS explained with Carrier Pigeons
                                                                            Shannon Anderson-Rush
                                                                            Data Analytics
                                                                            anelvr