QUIZ IN E-TECH

A spreadsheet program used to organize and perform calculations on data.

• Microsoft Word

• Microsoft Publisher

• Microsoft OneNote

• Microsoft Excel

A function that adds a range of cells

• ADD

• PLUS

• SUM

• TOTAL

A function that gets the average of a range of cells.

• AVERAGE

• SUM

• MEAN

• MEDIAN

Which among the following is not part of the syntax for AVERAGEIF?

• Average range

• Range

• Logical test

• Criteria

A function used to add a certain range of cells if a condition is met.

• SUMIF

• ADDIF

• TOTALIF

• PLUSIF

Microsoft Excel can perform mathematical equations.

• TRUE

• FALSE

Range, criteria, and logical test are part of the AVERAGEIF syntax.

• TRUE

• FALSE

Excel formulas always begin with a sign.

• TRUE

• FALSE

Excel can be used to create a database.

• TRUE

• FALSE

Column J and row 9 is also referred to as cell 9J.

• TRUE

• FALSE