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