spreadsheets

Question 1

Formula

Answer 1

Formulas are extremely useful features.They make automatic calculations that update when the data does.

Question 2

common symbols in formulas and calculations

Answer 2

. + add
. - subtract
. * multiply
. / divide

Question 3

logical operators

Answer 3

A logical operator is a symbol or word used to connect two or more expressions such the value of the compound expression produced depends only on that of the original expression and on the meaning of the operator.

Question 4

Formatting

Answer 4

A well formatted spread sheet is easy to read. Spreadsheet programs have plenty of formatting features.

Question 5

formatting examples

Answer 5

Colum height and width.
Font
border
fill
alignment
number

Question 6

Functions

Answer 6

. Sum- adds value in selected cells
. Min- finds smallest value
. Max- finds largest value
.average- finds the average value
.count- counts how many of the selected called have numbers in them