Upgrade to remove ads
CIS 201 FINAL EXAM
Terms in this set (100)
A ____ file contains data fields separated by a selected character.
A Word document often contains data stored in a(n) ____ that can then be copied and pasted into an Excel worksheet.
Because ____ help speed and simplify work, many Excel users create one for each project on which they work
Excel allows you to take a ____ of any open window and add it to a workbook.
Importing ____ provides greater flexibility to manipulate text in Excel.
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 ____.
Excel allows you to import data from webpages.
SmartArt graphics may include at most one shape.
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.
A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.
A screen ____ is a portion, usually of one object or section of a window, of the screen.
A(n) ____ contains little or no formatting.
All of the following are formats accepted for picture files EXCEPT ____.
Elements in a SmartArt graphic are grouped in ____.
When Excel imports a database table, the data is placed in an Excel ____.
You can add text to a SmartArt graphic by using the ____.
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 ____.
It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.
It is not possible to replicate formulas after completing an import, so be sure to complete the replication before the import.
____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.
____ reports are visual representations of PivotTables.
A ____ is a visual way to show how two variables relate to each other.
A ____ is an interactive view of worksheet data.
A ____ report is an interactive chart that allows users to change the groupings that graphically present data.
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.
Charts with ____ are often reformatted to start the vertical axis at a number other than zero.
In a PivotTable, ____ fields correspond to summary values of original data across categories.
In PivotTables, ____ fields correspond to columns in the original data.
The ____ value is a number from 0 to 1 that measures the strength of a trend.
The +/- buttons ____ a field across categories.
expand and collapse
The summary function that calculates the number of data values in a PivotTable report is ____.
Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.
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.
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.
Excel needs the blank rows above a PivotTable to remain blank, for any filters added in the PivotTable Fields task pane.
To add data to a PivotTable, select field check boxes in the PivotTable Fields task pane.
When you add a trendline to a chart, you can set the number of periods to forecast forward or backward in time.
A cell containing a formula that references other cells is said to have ____.
A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.
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.
An Answer Report shows original and final values of the target cell and changing cells plus ____
An Answer Report's ____ column indicates binding constraints
For each model, it is helpful to define a ____ scenario that represents the starting assumptions.
Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.
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.
The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.
The ____ error code indicates that a cell reference in a formula is not valid.
The ____ feature is especially useful when working with very large worksheets.
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.
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?
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.
Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.
Each cell referenced in a formula is a dependent of the cell containing the formula.
Errors can be introduced into a worksheet in formulas.
You can attempt to solve a complex worksheet problem manually, also known as the trial and error method.
A ____ is created by performing a set of steps and recording the steps as they are performed.
A macro name can be up to ____ characters long.
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.
Use macros to ensure consistency in all of the following EXCEPT ____.
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.
A macro name can contain numbers and letters but not underscores.
A macro's steps and their order should be determined and rehearsed after creating the macro.
A relationship is a field or column that three data sources have in common.
Before recording a macro, you should select your ending cell.
If you make a mistake while recording a macro, press the ESC key and repeat the step in error.
Macros provide you with an opportunity to make certain tasks much more efficient and accurate.
Power BI is a business intelligence tool to visualize and share data.
The 3D Maps command opens a window that uses a few of your computer's resources.
The Get & Transform command does not allow you to edit imported data.
You can set up multiple relationships using Power Pivot.
____ are descriptions which do not regularly appear as part of a worksheet's data.
____ means working together in cooperation on a document with other Excel users.
____ work well when multiple people are collaborating and commenting on a worksheet.
A workbook which is not shared and can be opened only by a single user is called an ____ workbook.
By default, Excel keeps a change history of ____ days for a shared workbook.
Each copy of a workbook to be merged must have a different ____.
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?
XML data always is imported as a(n) ____.
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.
You can press ____ to add a new comment to a worksheet.
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.
Comments added by each user are identified by a name in the comment, set by the user.
Excel has the capability to mark who changed what data, in which cell, and when.
In order to merge multiple workbooks, each workbook must be a copy of the same workbook.
Merging multiple copies of a workbook requires no special setup.
You can use a background image, or watermark, as a worksheet's background.
THIS SET IS OFTEN IN FOLDERS WITH...
Excel Chapter 8
CIS 201 module 2
Advanced Excel Final
CIS 201 module 3
YOU MIGHT ALSO LIKE...
CIS Chapter 7: Quiz 10
Chapter 7-Quiz 11
Excel Chapter 4, Microsoft 2016