Computer Science Final Exam
Data Model
A method of incorporating data from multiple, related tables into an Excel difference
Macros are recorded in the ________ programming language, which you can use to write computer programs within the Microsoft Windows environment.
Visual Basic for Applications
The custom date code, " ddd, mmm, dd" displays in the format_____.
Wed, Jul 15
A chart value that originates in a worksheet cell is referred to as ________.
a data point
A set of values that Excel saves and can substitute automatically in your worksheet is ______.
a scenario
A ____ is a graphic representation of data in a worksheet
chart
Objects that make up a chart are called ____
chart elements
To make comparisons among related data, use a ____ chart
column
PivotTable field names are formed from the source data's
column titles
The COUNT function counts the number of cells in a range that ________.
contain a number
Hold down the ____ key to select nonadjacent cells
ctrl
A sequence of averages computed from parts of a data series ______.
A moving average
Filter
A process by which you can limit the display of data to only specific information
What is an Excel Table?
A series of rows and columns that contains related data that can be managed independently from other data in a worksheet.
Field
A single piece of information for every record
PivotTable Fields pane
A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.
Field Section
The upper portion of the PivotTable Fields pane containing the fields --column titles---from your source data; use this area to add fields to and remove fields from the PivotTable
If a sheet tab has _____ you know that it is not selected
a solid background color
What is the Keyboard shortcut for Flash fill?
ctrl + E
A chart that is inserted into the same worksheet that contains the data used to create the chart is called _____.
embedded
The shorthand term for three dimensional, which refers to an image that appears to have all three spatial dimensions, length, width and depth
3-D
Text function
A function that can combine or separate data, change case, and apply formatting to a string of characters
Nested Function
A function that is contained inside another function
RIGHT
A function that returns the specified number of characteristics from the end (right) of a string of characters
Get and Transform Data
A group of commands that enables you to bring data from an Access database, from the Web, from a text file, from an XML file, and from many other sources, into Excel in a manner that lets you transform-modify-the data
Extensible Markup Language (XML)
A language that structures data in text files so it can be read by other systems, regardless of the hardware platform or operating system
Data Connection
A link to external data automatically updates an Excel workbook from the original data whenever the original data source gets new information
SUMIF Function
A logical function that contains one logic test- it will add values in a specified range that meets certain conditions or criteria
SUMIFS function
A logical function that will add values in multiple ranges that meet multiple criteria
Procedure
A named sequence of statements in a computer program that performs a task
Break-even point
A point at which a company starts to make a profit
Function
A predefined formula that performs calculations by using specific values, called arguments, in a particular order or structure.
Forecast
A prediction of the future often based on past performances
Moving Average
A sequence of averages computed from parts of a data series that smooths fluctuations in data to show a trend more clearly
Macro
A series of commands that are grouped together as a single command
Scenario
A set of values that Excel saves and can substitute automatically in your worksheet
UPPER
A text function that changes the case of the characters in a string, making all characters uppercase
CONCAT
A text function used to join up to 255 strings of characters
Solver
A what-if analysis tool that can help you find an optimal value for a formula in one cell- subject to constraints on the values of other cells on a worksheet
Scenario Manager
A what-if analysis tool that compares alternatives
To make code easier to read in the VBE code window, beginning and ending statements are formatted to the same level by
Aligning left
Fields
All the categories of data pertaining to one database item such as a name or employee number stored in a horizontal row in a database
MAXIFS Function
An Excel function that returns the maximum value among cells specified by a given set of conditions or criteria
Visual Basic Editor Window
An area where you can view the module containing Visual Basic Code
Digital Signature
An electronic, encryption-based, secure stamp of authentication on a macro or document
Variable Expense
An expense that varies depending on the amount of sales
VBA construct
An instruction that enables the macro to perform multiple operations on a single object
Add-In
An optional command or feature that is not immediately available; you must first install and/or activate an add-in to use it.
Database
An organized collection of data related to a particular topic or purpose
Solver is a command in Excel's
Analyze group
The values that an Excel Function uses to perform calculations or operations are called
Arguments
A logical function that counts cells that meet multiple criteria in multiple ranges
COUNTIFS
The text that displays on a control in a worksheet can be modified by changing this property
Caption
The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis
Category axis
Properties
Characteristics of ActiveX controls that can be changed
The entire chart and all of its elements
Chart Area
Use this type of ActiveX control to allow the person filling out a form to indicate a choice
Check Box
This type of ActiveX Control initiates an action when clicked
Command Button
In a database function, the use of two or more criteria on the same row- all conditions must be met for the records to be included in the results is called
Compound Criteria
Formating characteristics that are applied to cells when the value in the cell meets a specified condition are called
Conditional formats
Restrictions that are used in Solver to limit the results are called
Constraints
Database function that counts the number of occurrences of a specified condition in a database is
DAVERAGE
A database function that sums a column of values in a database that is limited by criteria set for one or more cells is
DSUM
A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points for a data series
Data marker
A value that originates in a worksheet cell and that is represented in a chart by a data marker
Data point
Related data points represented by data markers are referred to as the data; each data series has a unique color or pattern represented in the chart legend
Data series
If an error message displays when you try to run VBA code, click this button
Debug
When developing and editing ActiveX controls, you work in
Design Mode
To give you the option of approving or blocking files that contain macros, you should set your macro security level to:
Disable all macros with notification
A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for good or services
Enterprise fund
Features that are Add-ins are activated through the
Excel Options dialog box
Fixed Expense
Expenses that remain the same each month
The action of pulling out one or more pie slices from a pie chart for emphasis
Explode
A language that structures data in text files so that it can be read by other systems, regardless of the hardware platform or operating system is
Extensible Markup Language
Data
Facts about people, events, things, or ideas
In a database, information stored in columns and that contains a specific type of data such as a name, an employee number, or a social security number is a
Field
An Excel feature that predicts how to alter data based on the pattern you enter into the cell at the beginning of the column is
Flash Fill
This type of control is compatible with versions of Excel that do not support ActiveX
Form control
An Excel feature which, after typing an = and the beginning letters or letters of a function name, displays a list of function names that match that the typed letter(s)
Formula AutoComplete
A sum of money set aside for a specific purpose
Fund
A what-if analysis tool that find the input needed in one cell to arrive at the desired result in another cell
Goal Seek
ActiveX controls
Graphic objects that can run macros or scripts to automate a task or offer options
Decision Variable
In Solver, a cell in which the value will change to achieve the desired results
Objective cell
In Solver, a cell that contains a formula for the results you are trying to determine
Interval
In a moving average, the number of cells to include in the average
Data that has been organized in a useful manner is referred to as
Information
Record
Information that describes a record and is stored in columns
A chart element that identifies the patterns or colors that are assigned to the categories in the chart
Legend
The value in a chart's value axis that determines the spacing between tick marks and between the gridlines in the plot area
Major Unit
Macro Virus
Malicious lines of code in a macro program that are written with the intent of erasing or damaging files on another computer
A type of chart that compares values and shows categories across geographical regions; for examples, across countries, states, countries, and regions
Map Chart
The area in excel where you can make decisions about enabling data connections and workbook links is the
Microsoft Excel Trust Center
A logical function that returns TRUE if any of the conditions are true
OR function
To modify the Quick Access Toolbar, on the File tab click
Options
The mathematical rules for performing multiple calculations within a formula
Order of operations
The formula for calculating a percentage by which a value increases by adding the base percentage- usually 100% - to the percent increase
Percent for new value = base percent + percent of increase
The percent by which one number increases over another number
Percentage rate of increase
A chart that shows the relationship of each part to a whole
Pie Chart
The area bounded by the axes of a chart, including all the data series
Plot Area
The mathematical formula to calculate a rate of increase
Rate= amount of increase/ base
In a formula, the address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula
Relative cell reference
The tool that enables you to compare alternatives is
Scenario Manager
Sub
Short for sub procedure
The arrangement of the arguments in a function
Syntax
The Excel function that removes extra blank spaces from a string of characters is
TRIM
Information in a database is organized in a format of horizontal rows and vertical columns called a
Table
Record Macro
The Excel command that records your actions in Visual Basic for Applications programming language
VBA
The abbreviation for Visual Basic for Applications programming language
Event
The action, such as a combination of keystrokes, or the click of a button, that causes a program or macro to run
Syntax
The arrangement of the arguments in a function
Visual Basic for Application
The programming language used to write computer programs within Microsoft Windows Environment
A type of chart that shows values across the stages in a process
The term used to describe money set aside for the normal operating activities of a government entity such as a city
Embed
To insert something created in one computer program into another computer program
If data is listed in rows but you need to work with it in columns, use the paste option:
Transpose (T)
A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis
Value Axis
The formula for calculating the value after an increase by multiplying the original value- the base- by the percent for new value
Value after increase= base x percent for new value
VBA code can be examined and modified in the
Visual Basic Editor
The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet
What-if analysis
Module
When you record a macro, the place where the VBA code is stored
Another name for the category axis
X-axis
Another name for the value axis
Y-axis
Icon Set
a group of three, four, or five small graphic images that make your data visually easier to interpret
In VBA code, each line that contains a comment is preceded by
an apostrophe-single quotation
The values in parentheses in the SUM function (and other functions) are known as
arguments
A line that serves as a frame of reference for measurement and which borders the chart plot area
axis
The starting point when you divide the amount of increase by it to calculate the rate of increase
base
A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled
bevel
A defined set of formatting characteristics such as font, font size, and font color are known as _____.
cell style
A workbook sheet that only contains a chart
chart sheet
The process by which you and your colleagues can open and work on the same Excel workbook and see each other's changes is called
co-authoring
To make a letter a shortcut key, precede the letter with
ctrl
A text file in which the text is separated by commas or tabs is referred to as
delimited
The sheets which contain the information that a Summary sheet uses is known as a(n) ______ sheet.
detail
To approve or block files containing macros, your macro security level should be set to ________.
disable all macros with notification
When formatting a worksheet to be printed, _____ show where page breaks are located
dotted lines
The process by which a file is encoded so it cannot be opened without the proper password is
encryption
Examples of variable expenses in a restaurant are
food and wages
A _____ is prewritten in excel to look at one or more values, perform an operation, and then return a value
function
The default number format for cells is the _____ number format
general
Comments added to the VBA code displayed in
green text
To prevent a user from making changes to an Excel worksheet, use the ____ command so that the worksheet is not visible
hide
A moving average calculates an average for a group of numbers over a specified
interval
To display trends over time, use a ___ chart
line
A chart type that displays trends over time; time displays along the bottom axis and the data point values are connected with a line
line chart
The data for a PivotTable should be in the format of a ____.
list
Functions that are used to test for specific conditions
logical functions
The MEDIAN function finds _______.
middle value in a range of cells
To create a custom number format to display the full name of each month, use;
mmmm
To determine a trend from a widely fluctuating set of numbers, you can calculate a
moving average
To determine a 10% growth rate over a previous month sales, you would take the previous month's sales and _____.
multiply by 110%
In Excel, row headings are identified by ______.
numbers
A forecast is a prediction of the future, often based on
past performances
The _____ is the target destination for data that has been cut or copied using the Clipboard
paste area
A(n) _____ chart illustrates the relationship of each part to a whole
pie
To work with multiple tables in Excel, a _____ must be created between the tables
relationship
A combination of keys to execute a macro or program is known as a
shortcut key
After you create a macro and assign it to a button or menu item, to ensure that it works as expected, it needs to be
tested
The cells in which the values will change to achieve the desired results in Solver are called:
variable cells
A logical function that returns a result of TRUE if all the conditions are met
AND
One possible source of data for a PivotTable is a(n)
Access database file
Before working with a macro, you must first ______.
Add the developer tab to the ribbon
Optional commands and features that are NOT immediately available and must first be installed for you to use them as referred to as _______.
Add-ins
Values area
An area to position fields that contain data that is summarized in a PivotTable or PivotChart report.
PivotTable
An interactive Excel report that summarizes and analyzes large amounts of data
PivotTable
An interactive Excel report that summarizes and analyzes large amounts of data.
The _____ includes the Minimize, Restore, and Close buttons
Application- Level buttons
The _____ is a report in a workbook that is graphically represented in a PivotChart
Associated PivotTable
Which of the following is NOT a way to create a formula
By using a Function button on the status bar
The _______ button removes a filter from a slicer:
Clear Filter
Slicer
Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.
When selecting the range for a line chart, you may need to include a(n) ____ to have the same number of cells in each row.
Empty cell
The NOW function only requires one argument
False
Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are
Field buttons
The area in the layout section of the PivotTable Fields pane where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the:
Filters area
Expenses are classified according to which two broad categories
Fixed and variable
A ______ is a prewritten formula that looks at one or more values, performs an operation and then returns a value
Function
To import data from Access into an Excel Data Model, use the ____ command
Get Data
Where is the fill handle located?
Lower right corner of the selected cell
Unauthorized macro code is called a ____.
Macro virus
If you need to make changes to a template after it is protected, you must first remove the ______.
Protection
The COUNTIF function has 2 arguments:
Range of cells to check and the Criteria
An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data is called _____.
Recommended Charts
Which of the following is NOT considered a statistical function? SUM, AVERAGE, MEDIAN, MIN
SUM
A logical function that adds the values in cells that meet specific criteria in multiple ranges
SUMIFS
A function key or key combination, such as F5 or Ctrl + R, that carries out a menu command is called a ______.
Shortcut key
Field Names
The column titles from source data that form categories of data for a PivotTable
Refresh
The command to update a PivotTable to reflect new data
Source data
The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.
Primary Key
The field used to uniquely identify a record in an Access table.
Layout Section
The lower portion of the PivotTable Fields pane where you build the PivotTable report by rearranging and repositioning fields
A _____ is a predefined set of colors, fonts, line and fill effects that coordinate for an attractive look.
Theme
When you create a chart, you must first decide if you are going to plot values representing ____.
Totals OR details
Data can be edited on more than one worksheet at a time
True
A cell address is also referred to as a(n)
cell reference
An organization chart depicts ____ within an organization
reporting relationships
A group of related data plotted in a chart is called a data ____.
series
A(n) ____ is a chart that fits entirely in one cell
sparkline
Tiny Charts embedded in a cell that displays a visual trend summary alongside your data are called ______.
sparklines
If you want all of the forms within an organization to have a uniform appearance and have the data organized in the same manner, you should use ________.
standardization
The _____ displays the current cell mode, the page number and the zoom buttons
status bar
When you type data in a cell and press Enter, what cell becomes the active cell
the cell below
On your keyboard, which two symbols function ideally in date formats?
the hyphen key and the forward slash key
The area in the layout section of the PivotTable Fields pane where data is summarized is the
values area
The NOW function is ______, meaning that it will update automatically each time the workbook is opened.
volatile
A _____ is an excel document that stores data
workbook
The percent style button formats selected cells as a percentage with _____
0 Decimal places
You can add a button to the Quick Access Toolbar from the ____ dialog box
Excel Options
The ____ command joins 2 or more selected cells together into one cell and centers the contents in that cell
Merge and center
Which of the following does NOT display to the right side of a selected chart?
Move Chart button
In the Excel window, where does [Group] display when worksheets are grouped?
On the title bar
A(n) ______ displays data series, categories, data markers, and axes in the same manner as a standard chart.
PivotChart
Slicer header
The top of a slicer that indicates the category of the slicer items
The word WITH denotes the beginning of a _____, an instruction that enables the macro to perform multiple operations on a single object
VBA construct
Slicers are used to:
filter data
Comma Style format displays a number with _____.
2 decimal places
All excel formulas begin with a(n)____.
= sign
Which of the following is NOT a proper comparison operator? =>, >=, <>. <
=>
Which of the following is NOT an arithmetic operator? +, >=, %, ^
>=
PivotChart
A graphical representation of the data in a PivotTable
The break-even point is reached when ____.
Income equals expenses
To show trends over time, use a _____ chart.
Line
Data from an Excel workbook, an Access database, or imported from an external source such as a corporate database, a public data feed, or an analysis service can be incorporated in the_____
Data model
