QUIZ 3 EMPTECH - PEARL

A program designed to create spreadsheets which can later be used to analyze statistical data.

• MS Word

• MS Powerpoint

• MS Publisher

• MS Excel

A function used to compute for the summation of the number of a range.

• Sum

• Average

• Formula

• Average Range

It is an expression which calculates the value of a cell.

• Sum

• Average

• Formula

• Average Range

A function used to compute the average of the number of a range.

• Sum

• Average

• Formula

• Average Range

A spreadsheet allows users to organize data in rows and columns and perform calculations on the data .These rows and columns collectively called as _______

• Worktop

• Work paper

• Worktable

• Worksheet

The place where info is held in a spreadsheet.

• Cell

• Active Cell

• Row

• Column

A value or label that determines if a cell is part of the range to be averaged.

• Criteria

• Range

• Orientation

• Accounting Number Format

Arithmetic symbol when multiplying a syntax or function in spreadsheet

• #

• +

• /

• *

First  character you type in introducing   a function or syntax

• =

• /

•  *

• +

A syntax used to count the cells with specified content within a range.

• SUMIF

•  SUM

• COUNTIF

•  COUNT