Module 3 Microsoft Excel 2013 - Analyzing data, Proctecting

Which of the following is described as a mini toolbar used for the easy analysis of data? Choose one.

• Trust Center

• Quick Analysis Tool

• Footer

• Page Layout View

Which of these is a Format Style for a conditional formatting rule in Excel 2013?

• Data Bar

• 5 - Color Scale

• Gauge

• Graphic

By default in Excel 2013 all cells in a workbook are unlocked

• True

• False

For any selection of worksheet cells in Excel 2013 it is only possible to apply a single conditional formatting rule.

• True

• False

In Excel 2013 it is possible to move a worksheet to another open workbook but not to copy it there.

• True

• False

Which of these is NOT one of the standard Text Filters in Excel 2013?

• Contains

• Sounds Like...

• Does Not Contain

• Ends With...

In Excel 2013 a cell name can only be used in the worksheet in which it is defined.

• True

• False

When inviting people to share an Excel 2013 workbook on SkyDrive the access options are "Can edit" and "Can view".

• True

• False

The Sort dialog in Excel 2013 enables you to define a sort with 1 or more levels.

• True

• False

Protected workbook stop other uses editing, deleting or moving data.

• True

• False