Ict Excel

The counta function does....

• returns the amount of non-blank cells in the spreadsheet

• returns the amount of of cells that complete a condition

• returns the amount of cells that have labels

• returns the amount of cells that only have values

The countif function does....

• returns the amount of of cells that complete a condition

• returns the amount of cells that have labels

• returns the amount of cells that only have values

A. Relative addressing allows formulas to correct themselves if one part of it changes

B.Relative adressing doesn't get used often

• B is true and A is false

• B and A are true

• B and A are false

• A is true and B is false

Which functions give the current date

• PMT

• Now()

• Today()

• DATE

what can a excel spreadsheet do?

• It can hold millions of sheets in a book

• Can covert units

• link data from 2 or more spreadsheet

• delete or add rows and columns anywhere

What number 2 called?

• function/formula bar

• range

• name box

• search bar

What formatting were use on the values?

• Decimal

• bold

• currency

• commas

What are line graph use for?

• to compare changes over time

• To show small parts of the total amount

• To do the conga

• to travel distances

A. A pivot table organize data into a neat tubular form

B. A pivot table can have a graph.

• B and A are correct

• B and A are wrong

• B is right and A is wrong

• B is wrong and A is right

What does M stand for in BODMAS

• multiplication

• Max

• Measurement

• miles