Computer Science Final Exam

Ace your homework & exams now with Quizwiz!

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


Related study sets

Chapter 23-24, 25-26 APush Test!

View Set

Chapter 52: Alterations in Musculoskeletal Function: Rheumatic Disorders

View Set

Google Analytics Certification Questions

View Set

Chapter 26: Head and Spine Injuries (Questions)

View Set

Introduction to Pharmacology Test

View Set

Ch 8: Guidelines for Healthy Eating

View Set

HEMODIALYSIS/PERITONEAL DIALYSIS

View Set

Human Development Quiz 2 (Chapter 2)

View Set