Upgrade to remove ads
Only $2.99/month

CIS 201 FINAL EXAM

Terms in this set (100)

A ____ file contains data fields separated by a selected character.
delimited
A Word document often contains data stored in a(n) ____ that can then be copied and pasted into an Excel worksheet.
table
Because ____ help speed and simplify work, many Excel users create one for each project on which they work
Templates
Excel allows you to take a ____ of any open window and add it to a workbook.
screenshot
Importing ____ provides greater flexibility to manipulate text in Excel.
raw data
The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.
Text Import Wizard
Webpages use a file format called ____.
HTML
Excel allows you to import data from webpages.
TRUE
SmartArt graphics may include at most one shape.
False
The Import Data dialog box allows you to choose in which cell to import the text from a text file and to specify properties of the imported text.
TRUE
A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.
query
A screen ____ is a portion, usually of one object or section of a window, of the screen.
clipping
A(n) ____ contains little or no formatting.
text file
All of the following are formats accepted for picture files EXCEPT ____.
mp3
Elements in a SmartArt graphic are grouped in ____.
levels
When Excel imports a database table, the data is placed in an Excel ____.
table
You can add text to a SmartArt graphic by using the ____.
text pane
You can select any range of cells with entries surrounded by blank cells by tapping or clicking a cell in the range and then pressing ____.
d. CTRL+SHIFT+ASTERISK
It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.
false
It is not possible to replicate formulas after completing an import, so be sure to complete the replication before the import.
false
____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.
slicers
____ reports are visual representations of PivotTables.
PivotChart
A ____ is a visual way to show how two variables relate to each other.
trendline
A ____ is an interactive view of worksheet data.
PivotTable report
A ____ report is an interactive chart that allows users to change the groupings that graphically present data.
PivotChart
A(n) ____ is most often thought about in terms of how a value changes over time, but can also describe the relationship between two variables.
trend
Charts with ____ are often reformatted to start the vertical axis at a number other than zero.
trendlines
In a PivotTable, ____ fields correspond to summary values of original data across categories.
data
In PivotTables, ____ fields correspond to columns in the original data.
category
The ____ value is a number from 0 to 1 that measures the strength of a trend.
R-squared
The +/- buttons ____ a field across categories.
expand and collapse
The summary function that calculates the number of data values in a PivotTable report is ____.
count
Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.
filtering
When creating a PivotTable report, the active cell should be positioned ____.
anywhere in the range that contains the data
You can add a trendline to all of the following EXCEPT a(n) ____ chart.
pie
You can change the height of a slicer by clicking the Height text box in the Buttons group on the ____ tab and then entering the desired height.
SLICER TOOLS OPTIONS
All types of Excel charts can have a trendline added to them.
false
Excel needs the blank rows above a PivotTable to remain blank, for any filters added in the PivotTable Fields task pane.
true
To add data to a PivotTable, select field check boxes in the PivotTable Fields task pane.
true
When you add a trendline to a chart, you can set the number of periods to forecast forward or backward in time.
true
A cell containing a formula that references other cells is said to have ____.
precedents
A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.
dependent
A(n) ____ Report shows the answer that Solver found, which constraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those constraints.
answer
An Answer Report shows original and final values of the target cell and changing cells plus ____
constraints
An Answer Report's ____ column indicates binding constraints
Status
For each model, it is helpful to define a ____ scenario that represents the starting assumptions.
baseline
Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.
auditing
Formula auditing tools include a tracer ____, which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references.
arrow
The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.
Watch Window
The ____ error code indicates that a cell reference in a formula is not valid.
#REF!
The ____ feature is especially useful when working with very large worksheets.
outline
To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the '____' command.
Circle Invalid Data
When a cell contains a(n) ____ reference, it means that one of its defining values is itself.
circular
Which of the following complex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?
Solver Feature
Which of the following is NOT a type of data validation criteria you can assign to a cell?
Bold Style Formatting
A Solver constraint that is binding is one that limits the final solution in some way.
true
Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.
true
Each cell referenced in a formula is a dependent of the cell containing the formula.
false
Errors can be introduced into a worksheet in formulas.
true
You can attempt to solve a complex worksheet problem manually, also known as the trial and error method.
true
A ____ is created by performing a set of steps and recording the steps as they are performed.
macro
A macro name can be up to ____ characters long.
255
Data analysis commands are required ​
in order to use the power tools
Data catalogs _____.​
​can be shared with everyone within a business
If you will be using keyboard navigation when creating a macro, you must ensure that the '____' button in the Code group on the DEVELOPER tab is selected so that the macro works properly.
use relative reference
In Power BI, a(n) _____ is the file management system where you can upload many different types of files.​
dashbord
Use macros to ensure consistency in all of the following EXCEPT ____.
variables
What does OLAP stand for?​
​Online Analytical Processing
Why do the query tables use an underscore in their names?
. ​Database structures rarely allow spaces in the names of files or field
You can reset the ribbon to its installation default by clicking the Reset button in the Customize the Ribbon options in the ____ dialog box.
excel options
A macro name can contain numbers and letters but not underscores.
false
A macro's steps and their order should be determined and rehearsed after creating the macro.
false
A relationship is a field or column that three data sources have in common.​
false
Before recording a macro, you should select your ending cell.
false
If you make a mistake while recording a macro, press the ESC key and repeat the step in error.
false
Macros provide you with an opportunity to make certain tasks much more efficient and accurate.
true
Power BI is a business intelligence tool to visualize and share data.​
true
The 3D Maps command opens a window that uses a few of your computer's resources.​
false
The Get & Transform command does not allow you to edit imported data.​
false
You can set up multiple relationships using Power Pivot.
true
____ are descriptions which do not regularly appear as part of a worksheet's data.
comments
____ means working together in cooperation on a document with other Excel users.
collaboration
____ work well when multiple people are collaborating and commenting on a worksheet.
comments
A workbook which is not shared and can be opened only by a single user is called an ____ workbook.
exclusive
By default, Excel keeps a change history of ____ days for a shared workbook.
30
Each copy of a workbook to be merged must have a different ____.
file name
To password-protect a shared workbook, tap or click the ____ button (REVIEW tab | Changes group).
Protect Shared Workbook
Which of the following buttons will enable two worksheets to scroll at the same time so that you can make a visual comparison of the workbooks?
Synchronous Scrolling
XML data always is imported as a(n) ____.
table
You can click the ____ button to turn on/off the view of all comments.
show all comments
You can import an XML file into a workbook by clicking the Import button ____.
(DEVELOPER tab | XML group)
You can open the ____ view and then click the Share tab to view options for distributing a workbook.
backstage
You can press ____ to add a new comment to a worksheet.
SHIFT+F2
You can tap or click the 'Insert a Comment' button ____ to add a new comment to a worksheet.
(REVIEW tab | Comments group)
After a(n) shared workbook is protected, no one can unprotect or change it except the owner.
true
Comments added by each user are identified by a name in the comment, set by the user.
true
Excel has the capability to mark who changed what data, in which cell, and when.
true
In order to merge multiple workbooks, each workbook must be a copy of the same workbook.
true
Merging multiple copies of a workbook requires no special setup.
false
You can use a background image, or watermark, as a worksheet's background.
true
THIS SET IS OFTEN IN FOLDERS WITH...