Spreadsheet

Results 1 - 13 of about 13
Introduction to Spreadsheet Concepts
A spreadsheet (or spreadsheet program) is software that permits numerical data to be used and to perform automatic calculations on...
Beginners > Spreadsheet
Spreadsheets - The Excel Interface
Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the...
Beginners > Spreadsheet
Spreadsheets - Worksheets
Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered...
Beginners > Spreadsheet
Worksheet - Cells
A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined...
Beginners > Spreadsheet
Spreadsheets - Cell Selection
Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the...
Beginners > Spreadsheet
Spreadsheets - Data Entry
A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the...
Beginners > Spreadsheet
Spreadsheet - Formulas
The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other...
Beginners > Spreadsheet
Spreadsheet - Expressions
Expressions allow the spreadsheets to perform simple calculations using values from many cells. There are generally many types of...
Beginners > Spreadsheet
Spreadsheet - Arithmetic expressions
Arithmetic expressions are simple expressions built with arithmetic operators and constants or references to cells. Operands are the...
Beginners > Spreadsheet
Spreadsheets - Conditional expressions
Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated...
Beginners > Spreadsheet
Spreadsheet - Text Operators
Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The...
Beginners > Spreadsheet
Spreadsheet - Functions
Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: ...
Beginners > Spreadsheet
Spreadsheets - Mathematical Functions
Function Description ABS() This function returns the absolute value of a number. It therefore returns the number, if it is...
Beginners > Spreadsheet