[RB3-Ch3] Working with Spreadsheet

To find the square root of 4 using the SQRT function, we follow the syntax __________________.

• =SQRT(4)

• =Power(5)

• =(Square)

• =(Exp)

The PRODUCT function can be accessed from the ________________ group on the formulas tab.

• Any group

• Function Library

• Insert

• Home

  A ________________ chart enables us to view changes in data over time.

• Pie
• Bar
• Line

• Graph chart

To calculate 54, we use the _______________ function.

• Plus
• Minus
• Multiply
• POWER

A ___________________ chart is useful for showing the properties of monthly expenses.

• Pie

• Bar
• Line

• Grey chart

Conditional formatting enables important data to be highlighted.

• True

• False

In conditional formatting, data can be set off in different colors.

• True

• False

The POWER function consists of three numbers in the syntax.

• True

• False

The PRODUCT function can only be used with three numbers.

• True

• False

The options for charts can be accessed from the home tab.

• True

• False