AnswersBusiness Information ManagementUnit Test

Unit Test — Unit test Answers

15 verified answers1 views
1
Free Preview

Where are the Add Level and Delete Level buttons located?

A
Filter options list
B
Sort & Filter group
C
Sort dialog box
D
Custom filter dialog box
2
Free Preview

Which method is an easy way to find a short description of a function?

A
In the Insert Function dialog box, click the function name to get a short description.
B
Open Help from the Backstage view to find a list of functions.
C
Insert the function and right-click it in the cell to access a description.
D
Use the Search tool to find a list of functions and their descriptions.
3

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.
4

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
>=
5

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.
6

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.
7

Which option represents the method for inserting a title or heading for a chart?

A
Under Chart Tools, click the Design tab and select Insert Chart Title in the Chart Layouts group.
B
Under Chart Tools, click the Layout tab and select Insert Chart Heading from the Background group.
C
Under Chart Tools, click the Layout tab, select Chart Title, and choose the relevant option for where to insert the title.
D
Under Chart Tools, click the Format tab and select Format Chart Title from the Headings group.
8

Which argument is not a default filter for data?

A
Does Not Equal
B
Above Average
C
Less Than
D
Top 50
9

Serena has just applied conditional formatting and realizes that she has made a mistake. Which action should she take to fix the mistake?

A
Clear the rule she created by going to the Conditional Formatting Rules Manager dialog box and deleting the rule.
B
Clear all rules that have been applied to the worksheet or selected range by clicking the Clear Rules button.
C
Use the Undo button or Ctrl+Z.
D
Right-click the area where the conditional formatting rule has been applied and select Clear Rule from the menu list.
10

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
11

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.
12

Where is the SUBTOTAL function located?

A
under the Formula tab on the ribbon in the Function Library group
B
under the Home tab on the ribbon in the QuickSum group
C
under the Insert tab on the ribbon in the Outlining group
D
under the Data tab on the ribbon in the Outlining group
13

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
14

Which function can NOT be performed using the Conditional Formatting option?

A
Insert icons that visually display the ranking or rating of values in a selected range.
B
Apply conditional formatting to dates that fall within specified date ranges.
C
Use conditional formatting to highlight any duplicate values or data in a worksheet.
D
Use conditional formatting to dynamically underline in red and green any language or spelling errors on a worksheet.
15

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

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

Did you find these answers helpful?

More from this Course

Quiz
25 verified answers

Unit Test

Quiz
18 verified answers

Unit Test

Instruction
14 verified answers

Topic Test