final Flashcards
(102 cards)
1
Q
SUM is a built-in formula that adds the values in a selected range. (T/F)
A
true
2
Q
The Formula bar displays the result of the formula and a cell displays the formula. (T/F)
A
False
3
Q
The Format Painter copies formatting attributes and styles from one cell to another cell or range. (T/F)
A
true
4
Q
Which of the following is the name used to describe a group of cells?
- range
- columns
- rows
- vector
A
Range
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
6
Q
To select non-adjacent cells, columns, or rows, which key must you press?
A
Ctrl
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
8
Q
In a function, the information inside the parentheses after the function name is called its
A
argument(s)
9
Q
Excel recognizes patterns and can complete most series with the ___________________.
A
fill handle
10
Q
When you cut or copy data, they are stored
A
on the windows clipboard
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
12
Q
Column and row references do not change, when you copy a relative cell address. (T/F)
A
false
13
Q
Range names describe a cell or group of cells and make it easier to interpret a formula. (T/F)
A
true
14
Q
Arguments are the pieces of information within parentheses in functions that determine what value a function returns. (T/F)
A
true
15
Q
The TODAY and NOW functions have only one argument. (T/F)
A
false
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
17
Q
Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly?
A
F4
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
19
Q
Which of the following functions counts the number of cells in a range based on specified criteria?
A
COUNTIF
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
21
Q
Each group of data points or values used in a graph is a data series (T/F)
A
true
22
Q
In a pie chart, a data series is a slice of a pie. (T/F)
A
false
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
24
Q
The Data Analysis command is located on the Data tab (T/F)
A
true
25
Which of the following explains the symbols, textures, or colors used to differentiate data series?
legend
26
What can pie charts graph?
a single data series
27
A(n) ___________ chart is used to display trends over time or categories, when order is important
line
28
A(n) _________________ is used to smooth out irregularities (peaks and valleys) to easily recognize trends.
moving average
29
The _________________ is required to create a Moving Average chart.
data analysis pack
30
Which of the following terms refers to the text label that describes each data series?
category label
31
When printing, headers and footers appear on every sheet automatically. (T/F)
true
32
Excel calculates addition operations before operations within parentheses are performed. (T/F)
false
33
The SUMIF function combines the SUM function with the logical criterion component of the IF function (T/F)
true
34
In Excel, you can create nested IF functions that allow for more than one logical test. (T/F)
true
35
In a table, each row of data is a field and each column is a record. (T/F)
false
36
Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the selected formula?
trace precedents
37
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.
All of the statements in this group are true
38
Which of the following references cells in multiple workbooks or worksheets?
3D cell reference
39
Which of the following functions calculates payments for a loan if regular payments are made and the interest rate is constant?
PMT
40
Which of the following terms refers to the cells that contain values and labels to be graphed in the chart?
source data
41
Which of the following chart types use one data series to display each value as a percentage of the whole?
pie
42
Which of the following charts displays three series of data to show fluctuations in stock prices from high to low to close?
stock
43
Excel's data visualization Conditional Formatting commands format cells with icons, cell shading, or shaded bars to distinguish the values. (T/F)
true
44
Which of the following words best describes a Z to A sort?
descending
45
A filter is a criterion that determines which data are shown and which are hidden. (T/F)
true
46
A slicer _________________________.
is a visual filter
47
We use the question mark ? to represent any single character in a sequence of characters (T/F)
true
48
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:
both Italy and Germany
49
In the filtering procedure, the symbols ? and * are called ____
wild cards
50
In Excel, Exporting Data is __________________________.
Saving data in a format to be used in a different application
51
When an Excel file is saved as a delimited file, this is not one of the types of delimiting it recognizes:
hyphen-delimited
52
A text file is a document that includes raw data with no formatting. (T/F)
true
53
A file in CSV format cannot be imported into Excel (T/F)
false
54
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:
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
One of the statements below is not true of PivotTables:
PivotTables are not interactive
56
The PivotTable Fields pane displays these areas:
Filters, Columns, Rows, and Values
57
A calculated field is not a field in the source data. (T/F)
true
58
A consolidated worksheet summarizes data from more than one worksheet using a mathematical or statistical Excel function. (T/F)
true
59
In order to use the Consolidate command, you may work with worksheets that have data located in different positions on each worksheet. (T/F)
false
60
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)
false
61
A static consolidation summarizes the data and displays a result that updates automatically on the consolidated sheet. (T/F)
false
62
A source workbook includes data that is referenced in a dependent workbook. (T/F0
true
63
A SmartArt graphic is linked to worksheet data. (T/F)
false
64
SmartArt graphics are typically text-focused, although there are several that can incorporate pictures with text. (T/F)
true
65
Which tab is the Consolidate command located on?
data tab
66
Which of the following contains a range of data that will be used along with other ranges to provide summary information?
source worksheet
67
Which of the following should you use when the data on the source worksheets might be edited after you have created your consolidation worksheet?
dynamic consolidation
68
What is another name for consolidation when the data are arranged differently on source worksheets?
consolidation by category
69
Which of the following is an example of an external reference with all its identifiers?
=‘[WorkbookName]WorksheetName'!CellRange
70
Which of the following are examples of SmartArt objects?
- all of the examples shown here
- organization charts
- pyramids
- matrices
all of the examples shown here
71
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.
All the statements in this set about grouped worksheets are true!
72
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
all of the actions mentioned in this set can be done using a hyperlink.
73
In an OR function, if any one of the arguments is true, the result is TRUE. (T/F)
true
74
The syntax for an INDEX function (type one) is =INDEX(array, row_num,column_num). (T/F)
true
75
The syntax for the MATCH function is =MATCH(lookup_array, lookup_value) (T/F)
false
76
A mean absolute deviation (AMD) uses two Excel functions, ABS and AVERAGE. (T/F)
true
77
You can use Text functions to split, join, convert, and otherwise manage labels and values in a worksheet. (T/F)
true
78
Which of the following shows the correct syntax for the AND function?
=AND(LogicalN)
79
In the MATCH function, which of the following match_type arguments finds the first value that exactly matches the lookup_value?
0
80
Using financial functions, which of the following arguments specifies the total number of payments?
nper
81
Which of the following functions allows you to link or join text in a chain?
CONCATENATE function (also called CONCAT)
82
Text functions are also often referred to as ___________________ functions.
string
83
The correct syntax of the TEXTJOIN function that displays the result in D2 is _________________.
=TEXTJOIN(" ",,A2,B2,C2)
84
A macro is saved in an Excel macro-enabled workbook which has an .xlsm file name extension. (T/F)
true
85
The default setting in the Excel Trust Center is set to enable all macros when a workbook is opened.
false
86
What should you do before you begin to record a macro?
practice what you want to do
87
Which of the following is always the first key in a macro shortcut?
Ctrl
88
Tableau is groundbreaking statistical software created by Stanford University researchers (T/F)
false
groundbreaking data visualization software
89
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
all three statements in this group
90
A story in Tableau is a sequence of visualizations (worksheets or dashboards) that work together to convey a message (T/F)
true
91
The first stage in creating a story in Tableau is:
import data
92
In Tableau, the worksheets display in this location:
Along the bottom of the workbook as tabs
93
Tableau's built-in geo-coding allows for administrative places, such as country, state,and city, to be mapped automatically. (T/F)
true
94
The only version of Tableau currently available is Tableau Desktop 2022 in professional and student editions. (T/F)
false
95
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.
tableau is hard to use
96
In Tableau, qualitative data, such as Gender, Region, or Category are called ___________________.
dimensions
97
In Tableau, quantitative data, such as Sales, Profit, or Income are called ___________________.
measures
98
In Tableau, numerical values are indicated in the navigation bar with the "number" symbol #. (T/F)
true
99
When we built our Sales by Product/Region worksheet, we used this kind of color spectrum to visualize both negative and positive profits:
orange-blue divergent
100
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)
true
101
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)
false
102
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.
longitude, latitude
