Ms. Excel Rev

Formulas in Excel always begin with a/an ___________________

• +

• =

• :

• /

A group of cells is known as a ____________ of cells.

Ms Excel is an example of a _______________ software.

• Database

• Web authoring

• Spreadsheet

• Desktop Publishing

+ / * - are known as _____________ in Excel.

Average is an example of a ___________ in excel.

• Function

• Formula

• Word

• work-out

The correct IF statement for cell B2 if pass mark is 50 will be?

• =if(B2>=50, "fail", "pass")

• =if(B2>=50, "pass, fail")

• =if(B2<=50, "pass", "fail")

• =if(B2>=50, "pass", "fail")

A single page in Ms. Excel is known as:

• a workbook

• a worksheet

• a cell address

• a formula

A Vlookup formula does not require one of the following. Which one?

• Row Number

• Lookup value

• Column number

• Table Array

When your cell is not wide enough for the result of a formula, one of the following options appear. Which one?

• N/A

• ########

• ++++++++

• Error

The ______________ command on the Home tab allows you to increase the row height of a cell in order to fit in data that is too large for a normal cell size.