0 of 12 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 12 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
If you have a spreadsheet with a formula using cell references, where can you go to change the cell reference in the formula to an existing Named Range?
An example of a logical function that produces a True or False answer is:
To display the formulas in worksheet cells:
Filtering removes the data that doesn’t fit the filter criteria.
Use DSUM if you want to:
What is the first step in using the Subtotal feature in Excel?
Clean data in Excel databases refers to:
Conditional Formatting is found:
Which keyboard shortcut creates a default column chart?
When a chart is selected, three option buttons show up to the right of the chart and help you manipulate the chart’s appearance. These are called:
When determining how to set up a PivotTable, a good rule is to put your primary question in the:
In the PivotChart Fields pane, the Axis is similar to the __________ in the PivotTable Fields pane.