Excel Spreadsheet

Description

GCSE Computer Science Mind Map on Excel Spreadsheet, created by 12brandon.m on 09/12/2015.
12brandon.m
Mind Map by 12brandon.m, updated more than 1 year ago
12brandon.m
Created by 12brandon.m over 8 years ago
36
2

Resource summary

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)
                                                                            Show full summary Hide full summary

                                                                            Similar

                                                                            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