Créer une activité
Jouer Relier Colonnes

Sort

Wednesday, 13 of March 2019

alphanumeric keypad

A1

9:05am

/

-

Autosum

(A3:A7)

numlock

numeric keypad

$

+

F1 to F12

Conditional formatting

=SUM

0.000

=MIN

=

1, 11, 21, 31, 41, 51

Hello

January

=MAX

=AVG

*

this is a function of a spreadsheet that will allow you to place the values in ascending order

is a number to three decimal places

toggles numeric keypad between movement controls and numbers

is the range of cells included in a formula from A3 to A7

Are the function keys at the top of the keyboard

Multiplication

indicates it is currency numerical data type

is the function for finding the maximum value in a range of cell values

is the keypad on the right of the keyboard and is either movement or numeric entry

is the part of the keyboard with numbers and letters

this function will automatically add up the values in a range

is an example of filling with a 10 step value

is the function for finding the average value in a range of cell values

is the function for finding the minimum value in a range of cell values

divide

is the time data type

is the text data type

minus

Is the function for adding up a selection or range of cell values

is the first part of every formula

is a text data type that can be filled to get every month

This will colour code the data according to how high or low it is

is the date data type

is the first cell in a spreadsheet

add