AnswersTX-Business Information Management BIM IAnalyzing Data

Analyzing Data — Unit test Answers

1 verified answers
1
Free Preview

Which option represents the location of the Goal Seek function?

A
Goal tab
B
Data tab, Forecast group
C
Formulas tab, Forecast group
D
Insert tab on the ribbon
2
Free Preview

Which statement describes how to insert the IF, COUNTIF, or SUM function into a cell?

A
Use the Insert tab and select the appropriate function from the Functions group.
B
Type an = sign in the cell, followed by the name of the function and the relevant arguments.
C
Right-click the cell to access the context menu to insert the function.
D
Use the View tab and choose the correct function from the displayed list.
3

Which formatting option(s) can be set for Conditional Formatting rules?

A
light red fill with dark red text, yellow fill with dark yellow text, and green fill with dark green text
B
light red fill with dark red text
C
light red fill, light yellow fill, and light green fill
D
Any of these formatting options as well as number, border, shading, and font formatting can be set.
4

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

Where are options to add a border around the outside of a chart found?

A
Design tab in the Chart Layout gallery
B
Format tab in the Shape Styles group
C
Layout tab in the Background group
D
Insert tab in the Format gallery
6

Where is the option to set Conditional Formatting rules found?

A
Insert tab in the Formatting group
B
Page Layout tab in the Styles group
C
Home tab in the Styles group
D
Formulas tab in the Formatting group
7

What is the quickest way to remove all filters that have been applied to a worksheet?

A
Click each filter and select Clear Filter.
B
Click the Filter button in the Sort & Filter group.
C
Select the worksheet and click Clear Filter.
D
Select the worksheet and click Delete All Filters.
8

Which function category is not in Excel 2016?

A
Financial
B
Text
C
Date and Time
D
Conditional Formatting
9

Which ribbon tab is home to the Function library used to insert functions into worksheets?

A
Home
B
Insert
C
Formulas
D
Data
10

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

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

Did you find these answers helpful?

More from this Course

Quiz
8 verified answers

Unit Test

Instruction
8 verified answers

Instruction

Instruction
8 verified answers

Getting Started with Access