BAES Excel Functions & IF Statements Re-Cap L2

Front

What do we call the way formula is written?

Back

Syntax

Front

Can formulas contain spaces?

Back

True

Front

=A1+5
Is this a function or a formula?

Back

Formula

Front

What does this error mean #### ?

Back

The column is too narrow to display the contents

Front

How would you find the highest number in a range of cells?

Back

Max

Front

Formula to count students scoring more than 75 in a spreadsheet range?

Back

Countif

Front

You want to create a formula so that cell C4 does not change when you replicate it. Which is correct? Options: =c4*c5, =$c$4*c5, =c$4*c5, =$c$4*$c$5

Back

=$c$4*c5

Front

How many parts are there to an IF statement/function?

Back

3

Front

What do you call the "question" part of an if statement?

Back

logical test

Front

What is the correct formula for the IF function in Excel?

Back

=IF (logical_test, value_if_true, value_if_false)

Answer explanation

There is no equal sign on the first one and no IF in the last choice.