What formula would I use to add selection of cells together?, =COUNT, =MAX, =AVERAGE, =SUM, =MIN, =MULT, What formula would I use to find the smallest value?, =COUNT, =MAX, =AVERAGE, =SUM, =MIN, =MULT, Which formula would I use to find out how many values are stored?, =COUNT, =MAX, =AVERAGE, =SUM, =MIN, =MULT, What is B4 an example of?, Cell, Row, Cell Reference, Column, What is B an example of?, Cell, Row, Cell Reference, Column, If I want to copy a formula down to other cells, which function do I use?, Copy and Paste, Replicate, Repeat, Absolute Cell Reference, Which formula allows you to find the average number in a range of cells?, =SUM, =MIN, =AVERAGE, =COUNTA, What should text look like in a cell if we have 'wrapped' it correctly?, All on one line, 'Upstairs/Downstairs' and best fit for cell, Every word on a seperate line, Doesn't really matter as long as you click 'wrap', What symbol would you expect to see in your cell reference if you have done an absolute cell reference correctly?, £, &, ^, $, What is the fastest way to apply an absolute cell reference?, F4, F8, F6, F2, How can we easily remember how to do a % change formula?, COO, NOO, ROO, ZOO, Which of the following correctly demonstrates a 'ROO'?, =(R-O)/O, =(R-O)+O, =(R-O)*O, =(R-O)-O

N5 Spreadsheets

af
Trykke
Integrere

Rangliste

Visuel stil

Indstillinger

Skift skabelon

Gendan automatisk gemt: ?