Third Term Excel

Excel

In relation to the formula in cell D2, we can state that:

• is a multiplication between the values B1 and C1

• is a multiplication between values B2 and C2

• is a division between the values B1 and C1

• it is a division between the values B2 and C2

What is a RANGE in Excel?

• It is a group of columns and rows

• It is a group of mathematical operations

• It is a set of contiguous cells that can be selected to perform an equal operation with all of them.

• It is a logical function of Excel

Formulas in Excel must begin with

• =

• /

• *

• -

Colon in a formula is for working with ranges

• True

• False

What is Excel?

• A program to manage databases

• A program for writing texts

• A program for drawing

• A program for performing mathematical and statistical calculations

A ____ is the intersection of a row and a column

Which of the following formulas is the correct one to sum 10 cells?

• =Sum(A1;A10)

• Sum(A10:A1)

• =Sum(A1:A10)

• =Sum(A1..A10)

The function showing a maximum value

• Average

• Max

• Min

• AutoSum

Columns are identified by numbers.

• True

• False