MS Excel 2013

Which function is used to add the values of several cells?

• Average

• Max

• Min

• Sum

When you type a formula, you always start by typing the __________ sign.

• /

• ^

• =

• +

If a column displays #####, it means

• The column is not wide enough.

• Division by zero

• The column has text value instead of a numeric value.

• Wrong cell reference

Which symbol is used for absolute referencing?

• %

• $

• &

• *

Which one is not a type of cell referencing?

• Relative

• Absolute

• Mixed

• General

Which function is used to count the number of numeric values in a range?

• CountNumbers( )

• COUNT( )

• SUM( )

• TOTAL( )

A reference where a formula refers to its own value

• mixed reference

• absolute reference

• circular reference

The AutoSum button is present in the _________ group on the HOME tab.

• Styles

• Editing

• Font

• Alignment

The _________ function finds the average of a set of values in a column or row.

• Max

• Min

• Sum

• Average

The _________ character is used for the concatenation of strings.

• ampersand (&)

• asterisk (*)

• dollar ($)

• percent (%)