NEW
Font size
WorksheetsModule 3 Microsoft Excel 2013 - Analyzing data, Proctecting
Total questions: 10
Worksheet time: 10mins
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
