Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

business analytics and technology > final > Flashcards

final Flashcards

1
Q

SUM is a built-in formula that adds the values in a selected range. (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The Formula bar displays the result of the formula and a cell displays the formula. (T/F)

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The Format Painter copies formatting attributes and styles from one cell to another cell or range. (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which of the following is the name used to describe a group of cells?

  • range
  • columns
  • rows
  • vector
A

Range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which of the following simplifies the process of entering the months of the year in a worksheet?

Headings option
Fill Handle tool
Freeze Panes option
AutoSum button

A

fill handle tool

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

To select non-adjacent cells, columns, or rows, which key must you press?

A

Ctrl

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

We should use cell addresses in formulas, rather than explicit numbers, because

A

the formulas can automatically update if a number in a cell used by the formula is changed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

In a function, the information inside the parentheses after the function name is called its

A

argument(s)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Excel recognizes patterns and can complete most series with the ___________________.

A

fill handle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

When you cut or copy data, they are stored

A

on the windows clipboard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The term syntax refers to the required parts of a formula and the rules controlling the order of the parts. (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Column and row references do not change, when you copy a relative cell address. (T/F)

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Range names describe a cell or group of cells and make it easier to interpret a formula. (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Arguments are the pieces of information within parentheses in functions that determine what value a function returns. (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

The TODAY and NOW functions have only one argument. (T/F)

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

When the table array argument of the VLOOKUP function is named, we have to insert dollar signs ($) right before and right after the name to keep the table in a fixed location. (T/F)

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly?

A

F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Which of the following functions counts the number of cells in a range that contain any data type, text, or numbers?

A

COUNTA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which of the following functions counts the number of cells in a range based on specified criteria?

A

COUNTIF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which of the following refers to a group of editing options on the Formulas tab that you can use to review and correct errors in formulas?

A

formula auditing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Each group of data points or values used in a graph is a data series (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

In a pie chart, a data series is a slice of a pie. (T/F)

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Sparklines are miniature charts in a cell or cell range that illustrate trends and patterns without adding a separate chart object or sheet. (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

The Data Analysis command is located on the Data tab (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Which of the following explains the symbols, textures, or colors used to differentiate data series?

A

legend

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

What can pie charts graph?

A

a single data series

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

A(n) ___________ chart is used to display trends over time or categories, when order is important

A

line

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

A(n) _________________ is used to smooth out irregularities (peaks and valleys) to easily recognize trends.

A

moving average

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

The _________________ is required to create a Moving Average chart.

A

data analysis pack

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Which of the following terms refers to the text label that describes each data series?

A

category label

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

When printing, headers and footers appear on every sheet automatically. (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Excel calculates addition operations before operations within parentheses are performed. (T/F)

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

The SUMIF function combines the SUM function with the logical criterion component of the IF function (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

In Excel, you can create nested IF functions that allow for more than one logical test. (T/F)

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

In a table, each row of data is a field and each column is a record. (T/F)

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the selected formula?

A

trace precedents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Which of the following is a true statement?

  • Cells that contain absolute references do not change when copied.
  • All of the statements in this group are true.
  • There are three types of cell references you can use in a formula.
  • The type of cell references included in a formula determines the result of a formula when it is copied.
A

All of the statements in this group are true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Which of the following references cells in multiple workbooks or worksheets?

A

3D cell reference

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Which of the following functions calculates payments for a loan if regular payments are made and the interest rate is constant?

A

PMT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Which of the following terms refers to the cells that contain values and labels to be graphed in the chart?

A

source data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

Which of the following chart types use one data series to display each value as a percentage of the whole?

A

pie

42
Q

Which of the following charts displays three series of data to show fluctuations in stock prices from high to low to close?

A

stock

43
Q

Excel’s data visualization Conditional Formatting commands format cells with icons, cell shading, or shaded bars to distinguish the values. (T/F)

A

true

44
Q

Which of the following words best describes a Z to A sort?

A

descending

45
Q

A filter is a criterion that determines which data are shown and which are hidden. (T/F)

A

true

46
Q

A slicer _________________________.

A

is a visual filter

47
Q

We use the question mark ? to represent any single character in a sequence of characters (T/F)

A

true

48
Q

The countries Italy and Germany appear in our database. If we try to filter the country column using the criterion *y, we will get one of the following results:

A

both Italy and Germany

49
Q

In the filtering procedure, the symbols ? and * are called ____

A

wild cards

50
Q

In Excel, Exporting Data is __________________________.

A

Saving data in a format to be used in a different application

51
Q

When an Excel file is saved as a delimited file, this is not one of the types of delimiting it recognizes:

A

hyphen-delimited

52
Q

A text file is a document that includes raw data with no formatting. (T/F)

A

true

53
Q

A file in CSV format cannot be imported into Excel (T/F)

A

false

54
Q

To paste an Excel Worksheet Object into a Word document that will be updated in Word, when the original Excel object is changed, we should follow these steps:

A

Select and copy the Excel object => click inside the Word file => Click the Paste button and choose Paste Special => click on Paste Link radio button, then OK

55
Q

One of the statements below is not true of PivotTables:

A

PivotTables are not interactive

56
Q

The PivotTable Fields pane displays these areas:

A

Filters, Columns, Rows, and Values

57
Q

A calculated field is not a field in the source data. (T/F)

A

true

58
Q

A consolidated worksheet summarizes data from more than one worksheet using a mathematical or statistical Excel function. (T/F)

A

true

59
Q

In order to use the Consolidate command, you may work with worksheets that have data located in different positions on each worksheet. (T/F)

A

false

60
Q

On the copied sheet, which will become the consolidation sheet, you copy the contents of the cells that will be consolidated, leaving the original contents in place. (T/F)

A

false

61
Q

A static consolidation summarizes the data and displays a result that updates automatically on the consolidated sheet. (T/F)

A

false

62
Q

A source workbook includes data that is referenced in a dependent workbook. (T/F0

A

true

63
Q

A SmartArt graphic is linked to worksheet data. (T/F)

A

false

64
Q

SmartArt graphics are typically text-focused, although there are several that can incorporate pictures with text. (T/F)

A

true

65
Q

Which tab is the Consolidate command located on?

A

data tab

66
Q

Which of the following contains a range of data that will be used along with other ranges to provide summary information?

A

source worksheet

67
Q

Which of the following should you use when the data on the source worksheets might be edited after you have created your consolidation worksheet?

A

dynamic consolidation

68
Q

What is another name for consolidation when the data are arranged differently on source worksheets?

A

consolidation by category

69
Q

Which of the following is an example of an external reference with all its identifiers?

A

=‘[WorkbookName]WorksheetName’!CellRange

70
Q

Which of the following are examples of SmartArt objects?

  • all of the examples shown here
  • organization charts
  • pyramids
  • matrices
A

all of the examples shown here

71
Q

Which of the following statements is true about editing and formatting grouped worksheets?

  • When you group sheets, most editing commands that you perform affect every sheet in the group.
  • It is important that you carefully plan your commands for grouped worksheets.
  • All the statements in this set about grouped worksheets are true!
  • When you group sheets, most formatting commands that you perform affect every sheet in the group.
A

All the statements in this set about grouped worksheets are true!

72
Q

Which of the following actions can you perform with a hyperlink in Excel?

  • open another workbook
  • all of the actions mentioned in this set can be done using a hyperlink.
  • open another program
  • display a web page
A

all of the actions mentioned in this set can be done using a hyperlink.

73
Q

In an OR function, if any one of the arguments is true, the result is TRUE. (T/F)

A

true

74
Q

The syntax for an INDEX function (type one) is =INDEX(array, row_num,column_num). (T/F)

A

true

75
Q

The syntax for the MATCH function is =MATCH(lookup_array, lookup_value) (T/F)

A

false

76
Q

A mean absolute deviation (AMD) uses two Excel functions, ABS and AVERAGE. (T/F)

A

true

77
Q

You can use Text functions to split, join, convert, and otherwise manage labels and values in a worksheet. (T/F)

A

true

78
Q

Which of the following shows the correct syntax for the AND function?

A

=AND(LogicalN)

79
Q

In the MATCH function, which of the following match_type arguments finds the first value that exactly matches the lookup_value?

A

0

80
Q

Using financial functions, which of the following arguments specifies the total number of payments?

A

nper

81
Q

Which of the following functions allows you to link or join text in a chain?

A

CONCATENATE function (also called CONCAT)

82
Q

Text functions are also often referred to as ___________________ functions.

A

string

83
Q

The correct syntax of the TEXTJOIN function that displays the result in D2 is _________________.

A

=TEXTJOIN(“ “,,A2,B2,C2)

84
Q

A macro is saved in an Excel macro-enabled workbook which has an .xlsm file name extension. (T/F)

A

true

85
Q

The default setting in the Excel Trust Center is set to enable all macros when a workbook is opened.

A

false

86
Q

What should you do before you begin to record a macro?

A

practice what you want to do

87
Q

Which of the following is always the first key in a macro shortcut?

A

Ctrl

88
Q

Tableau is groundbreaking statistical software created by Stanford University researchers (T/F)

A

false

groundbreaking data visualization software

89
Q

Which of these statements is/are true of Tableau?

  • Tableau creates interactive charts
  • Tableau can import almost any type of data
  • Tableau is a data visualization industry leader
  • all three statements in this group
A

all three statements in this group

90
Q

A story in Tableau is a sequence of visualizations (worksheets or dashboards) that work together to convey a message (T/F)

A

true

91
Q

The first stage in creating a story in Tableau is:

A

import data

92
Q

In Tableau, the worksheets display in this location:

A

Along the bottom of the workbook as tabs

93
Q

Tableau’s built-in geo-coding allows for administrative places, such as country, state,and city, to be mapped automatically. (T/F)

A

true

94
Q

The only version of Tableau currently available is Tableau Desktop 2022 in professional and student editions. (T/F)

A

false

95
Q

One of the statements below about Tableau is false:

  • Tableau connects easily to almost any data source
  • Tableau allows for instantaneous insight by transforming data into Dashboards
  • Tableau is hard to use
  • One example of a Tableau dashboard shown in our PowerPoint presentation was the paths of Atlantic Oceans hurricanes.
A

tableau is hard to use

96
Q

In Tableau, qualitative data, such as Gender, Region, or Category are called ___________________.

A

dimensions

97
Q

In Tableau, quantitative data, such as Sales, Profit, or Income are called ___________________.

A

measures

98
Q

In Tableau, numerical values are indicated in the navigation bar with the “number” symbol #. (T/F)

A

true

99
Q

When we built our Sales by Product/Region worksheet, we used this kind of color spectrum to visualize both negative and positive profits:

A

orange-blue divergent

100
Q

When we activate a filter in a Tableau view, we are shown a set of checkboxes. For example, the filter for Year might show checkboxes labeled 2018, 2019, 2020, and 2021 that can be checked and unchecked, depending on which date we want to examine. (T/F)

A

true

101
Q

In Tableau, the Column and Row shelves at the top of the workbook “view” play different roles than do columns and rows in an Excel PivotTable. (T/F)

A

false

102
Q

When we create a map in Tableau that illustrates profitability in a geographical region, we will see ____________ on the Columns shelf and ____________ on the Rows shelf.

A

longitude, latitude

business analytics and technology (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions