MS Excel - Formulas and Functions

Which formula below will add the value of B2 to the value of C3

• =B2+C3

• =C3+B3

• =6+4

• =B+C

Which of the following option is a formula?

• =SUM(A1:A5)

• Add A1 - A5

• Subtract the numbers from A1 to A5

• A1 = A5

A worksheet is a(n) ___________

• Piece of graph paper

• Single page in a workbook

• Excel file

• All of the above

A selection of multiple cells is called a

• Group

• Range

• Reference

• Package

Using a cell address in a formula is known as:

• Formularizing

• Prefixing

• Cell referencing

• Cell mathematics

All formulas in Excel begin with the following symbol

• +

• =

• #

• %

In which view can you see the header and footer areas of a worksheet

• Normal view

• Page layout view

• Page break preview

• Header/Footer

Which is the active cell in the spreadsheet above?

• B2

• 2B

• 1D

• 1C

Cell reference for the range of cells G2 to M12 is _____

• G2.M12

• G2;M12

• G2:M12

• G2-M12

In Excel, you can sum a large range of data by simply selecting a tool button called __________________

• AutoFill

• AutoCorrect

• AutoSum

• Auto Format