final Flashcards
SUM is a built-in formula that adds the values in a selected range. (T/F)
true
The Formula bar displays the result of the formula and a cell displays the formula. (T/F)
False
The Format Painter copies formatting attributes and styles from one cell to another cell or range. (T/F)
true
Which of the following is the name used to describe a group of cells?
- range
- columns
- rows
- vector
Range
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
fill handle tool
To select non-adjacent cells, columns, or rows, which key must you press?
Ctrl
We should use cell addresses in formulas, rather than explicit numbers, because
the formulas can automatically update if a number in a cell used by the formula is changed
In a function, the information inside the parentheses after the function name is called its
argument(s)
Excel recognizes patterns and can complete most series with the ___________________.
fill handle
When you cut or copy data, they are stored
on the windows clipboard
The term syntax refers to the required parts of a formula and the rules controlling the order of the parts. (T/F)
true
Column and row references do not change, when you copy a relative cell address. (T/F)
false
Range names describe a cell or group of cells and make it easier to interpret a formula. (T/F)
true
Arguments are the pieces of information within parentheses in functions that determine what value a function returns. (T/F)
true
The TODAY and NOW functions have only one argument. (T/F)
false
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)
false
Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly?
F4
Which of the following functions counts the number of cells in a range that contain any data type, text, or numbers?
COUNTA
Which of the following functions counts the number of cells in a range based on specified criteria?
COUNTIF
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?
formula auditing
Each group of data points or values used in a graph is a data series (T/F)
true
In a pie chart, a data series is a slice of a pie. (T/F)
false
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)
true
The Data Analysis command is located on the Data tab (T/F)
true
Which of the following explains the symbols, textures, or colors used to differentiate data series?
legend
What can pie charts graph?
a single data series
A(n) ___________ chart is used to display trends over time or categories, when order is important
line
A(n) _________________ is used to smooth out irregularities (peaks and valleys) to easily recognize trends.
moving average
The _________________ is required to create a Moving Average chart.
data analysis pack
Which of the following terms refers to the text label that describes each data series?
category label
When printing, headers and footers appear on every sheet automatically. (T/F)
true
Excel calculates addition operations before operations within parentheses are performed. (T/F)
false
The SUMIF function combines the SUM function with the logical criterion component of the IF function (T/F)
true
In Excel, you can create nested IF functions that allow for more than one logical test. (T/F)
true
In a table, each row of data is a field and each column is a record. (T/F)
false
Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the selected formula?
trace precedents
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
Which of the following references cells in multiple workbooks or worksheets?
3D cell reference
Which of the following functions calculates payments for a loan if regular payments are made and the interest rate is constant?
PMT
Which of the following terms refers to the cells that contain values and labels to be graphed in the chart?
source data
Which of the following chart types use one data series to display each value as a percentage of the whole?
pie
Which of the following charts displays three series of data to show fluctuations in stock prices from high to low to close?
stock
Excel’s data visualization Conditional Formatting commands format cells with icons, cell shading, or shaded bars to distinguish the values. (T/F)
true
Which of the following words best describes a Z to A sort?
descending
A filter is a criterion that determines which data are shown and which are hidden. (T/F)
true
A slicer _________________________.
is a visual filter
We use the question mark ? to represent any single character in a sequence of characters (T/F)
true
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
In the filtering procedure, the symbols ? and * are called ____
wild cards
In Excel, Exporting Data is __________________________.
Saving data in a format to be used in a different application
When an Excel file is saved as a delimited file, this is not one of the types of delimiting it recognizes:
hyphen-delimited
A text file is a document that includes raw data with no formatting. (T/F)
true
A file in CSV format cannot be imported into Excel (T/F)
false
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
One of the statements below is not true of PivotTables:
PivotTables are not interactive
The PivotTable Fields pane displays these areas:
Filters, Columns, Rows, and Values
A calculated field is not a field in the source data. (T/F)
true
A consolidated worksheet summarizes data from more than one worksheet using a mathematical or statistical Excel function. (T/F)
true
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
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
A static consolidation summarizes the data and displays a result that updates automatically on the consolidated sheet. (T/F)
false
A source workbook includes data that is referenced in a dependent workbook. (T/F0
true
A SmartArt graphic is linked to worksheet data. (T/F)
false
SmartArt graphics are typically text-focused, although there are several that can incorporate pictures with text. (T/F)
true
Which tab is the Consolidate command located on?
data tab
Which of the following contains a range of data that will be used along with other ranges to provide summary information?
source worksheet
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
What is another name for consolidation when the data are arranged differently on source worksheets?
consolidation by category
Which of the following is an example of an external reference with all its identifiers?
=‘[WorkbookName]WorksheetName’!CellRange
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
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!
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.
In an OR function, if any one of the arguments is true, the result is TRUE. (T/F)
true
The syntax for an INDEX function (type one) is =INDEX(array, row_num,column_num). (T/F)
true
The syntax for the MATCH function is =MATCH(lookup_array, lookup_value) (T/F)
false
A mean absolute deviation (AMD) uses two Excel functions, ABS and AVERAGE. (T/F)
true
You can use Text functions to split, join, convert, and otherwise manage labels and values in a worksheet. (T/F)
true
Which of the following shows the correct syntax for the AND function?
=AND(LogicalN)
In the MATCH function, which of the following match_type arguments finds the first value that exactly matches the lookup_value?
0
Using financial functions, which of the following arguments specifies the total number of payments?
nper
Which of the following functions allows you to link or join text in a chain?
CONCATENATE function (also called CONCAT)
Text functions are also often referred to as ___________________ functions.
string
The correct syntax of the TEXTJOIN function that displays the result in D2 is _________________.
=TEXTJOIN(“ “,,A2,B2,C2)
A macro is saved in an Excel macro-enabled workbook which has an .xlsm file name extension. (T/F)
true
The default setting in the Excel Trust Center is set to enable all macros when a workbook is opened.
false
What should you do before you begin to record a macro?
practice what you want to do
Which of the following is always the first key in a macro shortcut?
Ctrl
Tableau is groundbreaking statistical software created by Stanford University researchers (T/F)
false
groundbreaking data visualization software
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
A story in Tableau is a sequence of visualizations (worksheets or dashboards) that work together to convey a message (T/F)
true
The first stage in creating a story in Tableau is:
import data
In Tableau, the worksheets display in this location:
Along the bottom of the workbook as tabs
Tableau’s built-in geo-coding allows for administrative places, such as country, state,and city, to be mapped automatically. (T/F)
true
The only version of Tableau currently available is Tableau Desktop 2022 in professional and student editions. (T/F)
false
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
In Tableau, qualitative data, such as Gender, Region, or Category are called ___________________.
dimensions
In Tableau, quantitative data, such as Sales, Profit, or Income are called ___________________.
measures
In Tableau, numerical values are indicated in the navigation bar with the “number” symbol #. (T/F)
true
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
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
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
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
