Spreadsheet Level 1 Formula and Functions

Descrição

Definitions and examples of the simple formula and functions
Linda (tutor)
FlashCards por Linda (tutor), atualizado more than 1 year ago
Linda (tutor)
Criado por Linda (tutor) quase 12 anos atrás
288
6

Resumo de Recurso

Questão Responda
Formula: Subtraction =A1-B1
Formula: Multiplication = A1 * B1
Formula: Division = A1 / B1
Function: to find the lowest (smallest) contents of a range of cells =Min(A1 : F1)
Function: to find the largest contents of a range of cells =Max(A1 : F1)
Function: to find the Average contents of a range of cells =Average(A1 : F1)
The mathematical operator used to subtract cells in a formula
The mathematical operator used to divide cells in a formula. Use / on your keyboard
All formula and functions must start with =
The mathematical operator to add cells together in a formula
The mathematical operator used to multiply cells in a formula
Formula: Addition = A1 + B1

Semelhante

Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
Networks
Will8324
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
Business Aims and ICT Strategies
scrt
User Interfaces
Skeletor
General ICT Quiz
Jade Fantom