Cpsc 215 exam 2

You can include an analysis of the constraints and conditions by which Solver arrived at its solution by creating a(n) _______ report.

answer

One way to ensure that correct data is entered into a cell or range is to use the Excel data _____ feature.

validation

To view the code of a macro, you need to open the Visual Basic ___.

Editor

______ analysis is an important business decision-making tool because it predicts the effect of cutting overhead or raising prices on net income

CVP

To save a workbook with marcos, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension

xlsm

To create a macro, you can enter a series of commands in the ____ programming language

VBA

With Goal Seek, you specify the _____ values you want

result

To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab

Convert to Range

The following are Excel-supported error alert types:

Stop, Warning, and Information

the ____ center is a central location for all the security settings in Office

Trust

Before using Scenario Manager, you should assign ____ to all the input and result cells you intend to use in your scenarios

names

In addition to displaying subtotals, the Subtotal feature “____” you worksheet so you can control the level of detail that is displayed

outlines

A business must pay insurance and rent; these are examples of ____ expenses

fixed

____is a program that searches for the optimal solution of a problem involving several variables

Solver

When you click in each cell in the Total row, a(n) ___ appears that you can click to open a list of the most commonly used functions

arrow

Every ___ consists of an object that contains a button for each unique value in that field

slicer

You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data

refresh

When you ___ a workbook, you control the ability users have to make changes to the file

protect

Protecting the ____ prohibits users from renaming, deleting, hiding, or inserting worksheets

structure

Every cell in a workbook has a(n) ____ property that determines whether or not changes can be made to that cell

locked

The three items that you must specify when using Solver are ____.

variable cell, objective cell, and constraints

Sometimes when you build a worksheet for other users, you may decide to add a(n) ____ message to a cell even if you do not validate the data in that cell

input