Spreadsheet – general concepts
. Main elements
Work environment
- Files and spreadsheets
- Opening files
- Saving files
- Using multiple files simultaneously
- Accessing recently used files
- Changing the name and position of a sheet
- Cells
- Inserting and editing text in cells
- Selecting a range of cells
- Quick cell navigation
- Inserting cells
- Copying and deleting cells
- AutoFill
- Cell text formatting
- Formatting rows and columns
- Selecting, inserting, and deleting rows and columns
- Column width and row height
- Hiding and displaying columns
- Formulas
- Absolute and relative references
- Calculation-related formulas
- Spreadsheet printing
- Defining the print area
- Print preview
- Header and footer
- Margins
- Functions
- Financial functions
- Statistical functions
- Function editing
- Charts
- Types of charts
- Entering data for charts
- Editing
- Drawing
- Creating drawings and text boxes
- Moving and grouping objects
- Sorting lists and data filters
