Excel Practice

Excel formulae are entered or edited in:

• The formula box

• The formula bar

• The formula space

• The formula area

The ABSOLUTE reference to cell G13 would be:

• G13

• ?G?13

• !G!13

• $G$13

In binary logic OR will evaluate to TRUE under the condition "TF" because it is:

• Strict, it requires 2 TRUE inputs

• Permissive, it only requires 1 TRUE input

• Permissive, it requires no TRUE inputs

• Strict, it requires 3 TRUE inputs

An ideal visualization would be:

• Simple

• Complex

• Byzantine

• Elaborate

Excel can create the following charts:

• Line

• Pie

• Scatter

• All listed answers

The Excel macro language is:

• C

• C++

• Python

• Microsoft Visual Basic

Excel macro workbooks use the standard .xlsx format.

• True

• False

Between ISERR and ISERROR, the function with broader conditions for a match is:

• ISERROR

• ISERR

• Trick question: Neither is a matching function

• Trick question: They are equally broad

In PowerQuery language, a reference to an existing column, COL, would be denoted with:

• COL

• [COL]

• (COL)

• {COL}

ETL stands for:

• Extract, Transform, Load

• Extract, Transform, Link

• Enable, Transform, Load

• Extract, Transmogrify, Load