AnswersTX-Business Information Management BIM IAnalyzing Data

Analyzing Data — Unit test Answers

3 verified answers
1
Free Preview

Top/Bottom Rules allow a user to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. How many items will it allow the user to include in the rule?

A
the top or bottom 10 items or top or bottom 10% only
B
the top 10 items and top 10% only
C
the top or bottom 100 items only
D
any logical number of items or percentages in top or bottom value frames
2
Free Preview

Which phrase is a comparison operator for inserting a not equal to argument in an IF, COUNTIF or SUMIF function?

A
<=
B
Option
C
><
D
>=
3

Which method is used to edit a function that has been created and inserted into a cell?

A
Double-click the cell containing the function, and make amendments to the function within the cell.
B
Click the cell containing the function, and click in the Formula Bar to make amendments to the function.
C
Click the cell containing the function, and click on the fx symbol to the left of the Formula Bar to launch the Function Arguments dialog box where amendments can be made.
D
All of the above methods can be used to edit a function that has already been inserted into a cell.
4

Alex needs to create a function capable of counting item reference numbers that he is inserting into a spread sheet. The purpose of this function will be to keep track of inventory. How would Alex go about finding a function to do this?

A
Click the Home tab and use the Find & Select function to look for a function that counts items.
B
Access the Find dialog box using Ctrl + F to look for a function that counts items.
C
Press Shift + F3 to access the Insert Function dialog box to look for a function that counts items.
D
Enter the item reference numbers into the worksheet, and click the Sort button to count the items.
5

Walt has selected data in a worksheet and inserted a chart. However, the chart is inserted right on top of the data set, and he cannot see the data. How should Walt most efficiently fix this situation?

A
Cut and paste the chart to a different worksheet or to a different part of the current worksheet.
B
Delete the current chart and first select a blank sheet or space before inserting the chart again.
C
Right-click the chart and select Move Below Data Table from the menu list.
D
Click View and zoom into the worksheet so the chart is easily visible.
6

Where are the options to add or remove the background color of a chart located in Excel 2016?

A
under the Design tab in the Chart Layouts group
B
under the Design tab in the Chart Styles gallery
C
under the Format tab in the Shape Styles group
D
under the Layout tab in the Insert group
7

Which argument is not a valid filter?

A
Does not equal
B
This quarter
C
Filter by cell color
D
All of these are valid filter arguments.
8

Kyle is searching for the solver function but cannot seem to find it anywhere, not even under the Data tab in the ribbon.Where can it be found?

A
If it is not on the ribbon, it has not been activated; Kyle needs to activate it under Add-Ins in the Excel Options dialog box.
B
It is not under the Data tab because it is a formula; Kyle needs to look under the Formula tab on the ribbon in the Add-Ins group.
C
It is not a function that is usually displayed on the ribbon; Kyle can add it to the ribbon as a macro function.
D
Solver is a separate program; Kyle needs to launch it from his operating system's Start menu.
9

How can a user change the range of cells that a Conditional Formatting rule applies to?

A
Clear the rule first and reapply it as it cannot be modified.
B
In the Conditional Formatting Rules Manager dialog box, edit the cell range for the rule in the Applies To section.
C
Clear all rules that have been applied to the worksheet or selected range by clicking on the Clear Rules button.
D
Right-click the cell range and select Update Conditional Formatting Rule from the menu list.
10

What is the maximum number of cells a user can select for the Set Objective variable in the Solver Parameters dialog box?

A
A user can select only a single cell for the Set Objective variable.
B
A user can select up to three cells for the Set Objective variable.
C
A user can select any number of cells for the Set Objective variable.
D
A user can select as many active cells as a worksheet contains for the Set Objective variable.
11

Which type of chart is most useful when a user is trying to visually represent sets of data as parts of a whole, such as product categories within total sales?

A
doughnut chart
B
bubble chart
C
pie chart
D
area chart
12

Which phrase best describes a scenario in Excel 2016?

A
a type of what-if analysis that allows a user to define a single variable for a single function or formula
B
a type of what-if analysis that allows a user to define multiple variables for multiple functions or formulas
C
a type of chart analysis that allows a user to predict outcomes using data
D
a type of chart analysis that allows a user to set predetermined outcomes using data

Did you find these answers helpful?

More from this Course

Quiz
18 verified answers

Unit Test

Quiz
1 verified answers

Unit Test

Instruction
8 verified answers

Instruction