Excel Formats Formulae -HT -FEB20-21

Which should a formula begin with?

• =

• +

• (

• @

________ are horizontal.

• Rows

• Columns

_____ are vertical. 

• Rows
• Columns

Choose the incorrect formula.

• =A2+A4

• AB3+Y5

• =AB3+y5

• =a2+a3

The sign * is used for:

• Multiplication

• Addition

• Subtraction

• Division

What is the cell reference of the highlighted cell shown in the image?

• A7

• N7

• AN17

• AN7

Which response best completes the following statement: A formula is used to

• perform calculations like addition, subtraction, multiplication and division

• find averages

• Look Up data

• perform calculations like addition only

The sign / is used for:

• Multiplication

• Addition

• Subtraction

• Division

How do you type

the sign '&'

using the keyboard?

• press key 4

• Press key combinations shift 4

• Press key 7

• Press key combinations shift 7

Excel allows you to

• read stories

• work with table of data

• invent ideas

• create a presentation