Microsoft Excel Final Chapters 1-11

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

An ____ 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 withing those constraints.

Answer

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

AutoCalculate

When you first create a table, Excel automatically enables ____.

AutoFilter

Which of the following format symbols displays text along with numbers entered in a cell?

" " (quotation marks)

Error messages begin with the ____ symbol.

#

____ refers to cells not wide enough to display the entire entry.

#####

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

#REF!

The ____ error code indicates that a cell reference in a formula is not valid.

#REF!

The code ____ instructs Excel to insert the page number in the header or footer section.

&[Page]

Which of the following is the path to the Goal Seek button?

(DATA tab | Date Tools group

You can tap or click the 'Insert a Comment' button ____ to add a new comment to a worksheet.

(REVIEW tab | Comments group)

Which of the following format codes insures that Excel will display a decimal point in the number?

. (period)

All of the following are formats accepted for picture files EXCEPT ____.

.mp3

When you decrease the row height to ____, the row is hidden.

0

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

0

Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parenthesis?

0.00%;[Blue](0.00%)

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

20xx

A macro name can be up to ____ characters long.

255

When Excel follows the order of operations, the formula, 8*3+2, equals ____.

26

The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 or less than or equal to 5.

3, 4, 5

A range that spans two or more worksheets in a workbook is called a ____ range.

3-D

By default, Excel keeps a change history of ____ days for a shared workbook.

30

Which of the following patterns extends the fill series to 575, 550, 525?

625, 600

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

8.43

Which comparison operator means "not equal to"?

<>

Which of the following formulas contains an absolute cell reference?

=$B$4

Which of the following calculations multiplies 23 by 0.01?

=23%

Which of the following are valid formulas?

=3^4 =H3/H11 =11+9 =22-F15

The general form of the VLOOKUP function is ____.

=VLOOKUP(lookup_value, lookup_table, col_index_num)

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

AVERAGE

Like the AutoFilter query technique, the ____ command displays a subset of the table.

Advanced Filter

The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

Rules Manager

Which of the following functions can you use to determine the position of the space that separates a first and last name?

SEARCH

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.

SHIFT

The ____ function is useful when you want to add values in a range only if they meet criteria.

SUMIF

____ are named combinations of values that are assigned to variables in a model.

Scenarios

____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.

Slicers

One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

Solver

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

An Answer Report's ____ column indicates binding constraints.

Status

To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu.

Summarize Values By

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

____ are used in XML files to describe data items.

Tags

____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

The formula checker

If the contents of a cell coped using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

Thursday, Saturday, Monday

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Thursday, Saturday, Monday

The Highlight Changes command is located on the ____ menu.

Track Changes

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

____ code is created automatically by the macro recorder.

VBA

The ____ function is used when a table direction is vertical.

VLOOKUP

Which of the following are types of summary functions for PivotChart report and PivotTable report data analysis?

Varp Count Count Nums Average

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

Watch Window

All of the following are valid Excel arithmetic operators EXCEPT ____.

^

As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in an ____ cell reference.

absolute

Names are ____ cell references.

absolute

To start a new line in a cell, press the ____ keys.

alt+enter

An ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

amortization schedule

When creating a PivotTable report, the active cell should be positioned ____.

anywhere in the range that contains the data

For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.

arguments

The left column values in a table array are called table ____.

arguments

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

Which of the following is the maximum number of active data tables per worksheet?

as many as you want

Data is in ____ sequence if it is in order from lowest to highest.

ascending

Cell references in a formula are called ____.

assumptions

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

auditing

The following sequence: 1, 1, 1, etc., is an example of an ____ series.

auto fill

In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.

background formula checking

For each model, it is helpful to define a ____ scenario that represents the starting assumptions.

baseline

Comments can be placed at any of the following positions EXCEPT ____.

before the Supplement statement

Cell ____ can be used to distinguish the different functional parts of a worksheet.

borders

The arguments in ____ in the ScreenTip for a function are optional.

brackets

In a table, a column that contains formulas or functions is called a ____.

calculated column

A field containing computational values based on data in other fields.

calculated fields

In PivotTables, ____ fields correspond to columns in the original data.

category

To enter data in a cell, you must first select the ____.

cell

Charts can either be embedded in a worksheet or placed in a separate ____.

chart sheet

Using the Excel spell checker, you can ____.

check the spelling in a single cell check the spelling of words in a selected range add words to the dictionary

A ____ reference is a formula that depends on its own value.

circular

When a cell contains a ____ reference, it means that one of its defining values is itself.

circular

What effect does the Accounting Number Format have on the selected cells?

displays cell contents with two decimal places that align vertically

When a formula fails to pass one of the rules and background formula checking if enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.

green triangle

You can drill all of the following down through a workbook EXCEPT ____.

groupings

A ____ is text and graphics that print at the top of each page.

header

To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.

hide

Which of the following are true about the ROUND function?

if the number of digits argument is greater than zero, then the number is rounded to the specified number of digits to the right of the decimal point if the number of digits is equal to zero, then the number is rounded to the nearest integer if the number of digits argument is less than zero, then the number is rounded to the specified number of digits to the left of the decimal point

Only images that are ____ are free for anyone to use without permission.

in the public domain

Which are types of fields used by PivotTables?

index data category summary

The ____ is a blinking vertical line that indicates where the next typed character will appear.

insertion point

Which of the following is a method of entering functions?

keyboard, touch gesture, or pointer the Sum menu the Insert Function box in the formula bar the Name box area in the formula bar

By default, text is ____ in a cell.

left-aligned

Passwords in Excel can contain ____.

letters numbers spaces up to 30 characters

Elements in a SmartArt graphic are grouped in ____.

levels

A ____ is a reference to a cell or range of cells in another workbook.

link

The arguments in an IF function are ____.

logical_test value_if_true value_if_false

A ____ is created by performing a set of steps and recording the steps as they are performed.

macro

An Excel ____ is a procedure composed of a VBA code.

macro

The ____ prefix is a standard prefix for email hyperlinks, which Excel adds automatically.

mailto:

Shared workbooks must be ____ within the number of days specified to record the change history.

merged

Combining two or more selected cells into one cell is called ____ cells.

merging

Which of the following are PMT function arguments?

monthly interest rate number of payments loan amount

A cell ____ often is created from column or row titles.

name

Rather than manually setting a print area each time you want to print a range, you can ____ the range.

name

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

nested

You can add the DEVELOPER tab to the Ribbon with options in the ____ dialog box.

none of the above

The default view in Excel is called ____ view.

normal

Which of the following fill actions can you perform by dragging the fill handle?

number, number, number, etc. month, month, month, etc.

A workbook contains ____ worksheet by default.

one

With an ____data table you can vary the value in one cell.

one-input

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

orientation

Headers, footers, and margins are all ____ options.

page setup

A ____ ensures that users cannot unprotect a worksheet simply by clicking the Unprotect button.

password

You should create a ____ when you want to keep others from changing the worksheet from protected to unprotected.

password

A cell containing a formula that references other cells is said to have ____.

precedents

A series of precise instructions for a computer to accomplish a task is called a ____.

procedure

When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas.

protect

A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

query

____ ensures that users do not change values inadvertently that are critical to the worksheet.

Cell protection

To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then tap or click ____ on the Table submenu.

Convert to Range

Tapping or clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others.

Convert to Shapes

The summary function that calculates the number of data values in a PivotTable report is ____.

Count

____ format codes allow you to specify how a cell entry assigned a format will appear.

Custom

Which of the following are database functions?

DAVERAGE DSUM

You can delete a control by pressing and holding or right-clicking the control and selecting ____ on the shortcut menu.

Delete

You can click the ____ command on the shortcut menu to remove a comment from a worksheet.

Delete Comment

____ a shape within a SmartArt graphic means moving it to a lower level.

Demoting

Which of the following is the default security option for workbooks containing macros?

Disable all macros with notification

The ____ should be used before sharing a workbook publicly.

Document Inspector

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Double-click or double-tap

The ____ button allows you to move through a formula step by step.

Evaluate Formula

You can add buttons to the Quick Access Toolbar with options in the ____ dialog box.

Excel Options

Which of the following happens when you enter the formula =G15 into a cell?

Excel assigns the value in cell G15 to the active cell

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Fill Formatting Only

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Goal

The ____ function is used when a table direction is horizontal.

HLOOKUP

Webpages use a file format called ____.

HTML

The ____ function is useful when you want to assign a value to a cell based on a logical test.

IF

Which of the following is NOT a SmartArt graphic category?

Microsoft.com

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

NOW

The ____ style is the format style that Excel initially assigns to all cells in a workbook.

Normal

Which of the following are effective workbook collaboration options?

distributing a workbook to others physically or electronically sharing a workbook participating in discussion threads or online meetings using a service, such as SharePoint Services with Microsoft Office 2013

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Qtr2

The ____ value is a number from 0 to 1 that measures the strength of a trend.

R-squared

A number from 0 to 1 that measures the strength of a trend.

R-squared value

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

ROUND

To prevent round-off errors, use the ____ function.

ROUND

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

fill handle

Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.

filtering

A ____ is text and graphics that print at the bottom of every page.

footer

Predicting data values that are outside the data set.

forecasting

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

format

You can ____ comments.

format resize copy move

A ____ is a pre-written formula that is built into Excel.

function

____ text often provides a strong visual appeal.

Rotated

Names are ____ to the workbook.

global

A ____ total sums all of the data in a row or column.

grand

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

Row banding

With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.

quotation marks

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.

range

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

range finder

In a table, or database, the data related to each person or item is called a ____.

record

A ____ reference is an adjusted cell reference in a copied and pasted formula.

relative

The adjusted cell references in a copied and pasted formula are called ___ cell references.

relative

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

right arrow

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

right parenthesis

Changes to category fields are correspondingly made to these in the PivotTable report.

row fields

Excel allows you to take a ____ of any open window and add it to a workbook.

screen shot

Point mode allows you to ____.

select cells for use in a formula using the mouse pointer

You can insert a ____ at the bottom of a table.

total row

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

trace error

When the copies of a workbook to be merged into a single workbook are made, ____ must be enabled.

track changes sharing

If either ____ or sharing is enabled, Excel enables the other by default.

tracking

In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched.

transposed

A ____ is most often thought about in terms of how a value changes over time, but can also describe the relationship between two variables.

trend

A ____ is a visual way to show how two variables relate to each other.

trendline

A visual way to relate two variables.

trendline

You can enable or disable macros with options in the ____ dialog box.

trust center

When working with a large worksheet, you can split the window into ____ panes.

two or four

The first step in creating an effective worksheet is to make sure you ____.

understand what is required

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

unprotected

Data tables must be built in an ____ area of a worksheet.

unused

A computer ____ is a potentially damaging computer program designed to affect your computer negatively by altering the way it works.

virus

When you work with a ____ created by someone else, you should review its content and structure before you make changes to it.

workbook

An Excel ____ allows data to be summarized and charted easily.

worksheet

Excel allows you to share and collaborate with others through a variety of features, depending on ____.

your resources collaborators' resources your preferences collaborators' preferences

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

zeros positive numbers text negative numbers

____ a shape within a SmartArt graphic means moving it to a higher level.

Promoting

Each copy of a workbook to be merged must have a different ____.

file name

Which of the following is NOT a type of data validation criteria you can assign to a cell?

Bold style formatting

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

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.

Clipboard

You should use a ____ chart to compare values side by side, broken down by category.

Clustered Column

____ means working together in cooperation on a document with other Excel users.

Collaboration

____ are descriptions which do not regularly appear as part of a worksheet's data.

Comments

____ work well when multiple people are collaborating and commenting on a worksheet.

Comments

____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

Conditional

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

Extracting

You can click the ScreenTip button in the ____ dialog box to add ScreenTip text to a hyperlink.

Insert Hyperlink

Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try?

Iterations

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

MATCH

The ____ function displays the highest value in a range.

MAX

The ____ function determines the lowest number in a range.

MIN

Which of the following functions can you use to convert names entered in all uppercase to mixed case?

PROPER

The ____ function returns the present value of an annuity.

PV

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page layout

Which of the following commands can you use to replace a formula with a text value?

Past Values

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

PivotChart

An interactive chart that graphically presents data.

PivotChart report

Using ____, a user with little knowledge of formulas, functions, and ranges can complete powerful what-if-analyses of a set of data.

PivotCharts PivotTables trendlines slicers

Drawn from data in worksheet columns.

PivotTable fields

A ____ is an interactive view of worksheet data.

PivotTable report

An interactive view of worksheet data.

PivotTable report

A screen ____ is a portion, usually of one object or section of a window, of the screen.

clipping

Which of the following are names for a step-by-step description of a computerized task?

code program procedure

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

colon (:)

Changes to series fields in a PivotChart report appear as changes to these in the PivotTable report.

column fields

The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.

consolidation

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

An Answer Report shows original and final values of the target cell and changing cells plus ____.

constraints

The basics of using VBA to create a data entry form include ____.

creating a user interface setting the properties writing the code

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.

criteria

If you deselect an item from the filter menu, it is called the filter ____.

criterion

To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.

ctrl

To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

ctrl

To select noncontinuous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.

ctrl

You should hold down the ____ key to select the nonadjacent cells.

ctrl

Pressing the ____ keyboard shortcut key(s) selects cell A1.

ctrl+home

In a PivotTable, fields ____ correspond to summary values of original data across categories.

data

You choose a ____ to automate data analysis.

data table

A ____ file contains data fields separated by a selected character.

delimited

A cell whose value relies on another referenced cell is said to be a ____ of that referenced cell.

dependent

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

dependents

A ____ is an attachment to a file or email message that vouches for its authenticity.

digital certificate

What effect does the Comma Style format have on the selected cells?

displays cell contents with two decimal places and commas as thousands separators

Which of the following are guidelines for creating a table in Excel?

do not enter more than one table per worksheet maintain at least one blank row between a table and other worksheet entries do not use blank rows or rows with repeating characters to separate the column headings (field names) from the data place column headings (field names) in the first row of the table

Which of the following are formatting symbols?

dollar sign ($) comma (,) percent sign (%)

When you insert a manual page break, Excel displays a ____ line between pages.

dotted

Which of the following chart types cannot include trendlines?

doughnut pie

Using the mouse to move or copy cells is called ____.

drag and drop

PivotTables are ____ by nature.

dynamic

Clicking the ____ box completes an entry.

enter

The ____ preceding a formula alerts Excel that you entering a formula or function and not text.

equal sign (=)

In Excel, a number can contain the characters ____.

everything

The +/- buttons ____ a field across categories.

expand and collapse

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

exploded

Imported data that maintains a refresh-able link to its external source is called ____ data.

external

Each row of an Excel worksheet used to create a table can store a record, and each column can store a ____.

field

You can name a range by ____.

selecting a cell or range, typing the name in the Name box, and pressing the ENTER key selecting a cell or range, typing the name in the formula bar, and pressing the ENTER key selecting a cell or range, tapping or clicking the Define Name button (FORMULAS tab | Define Names group)

Which of the following is not a valid format symbol?

semi-colon (;)

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

sheet name location workbook name

Excel treats ____ as graphic objects that can be moved, resized, and formatted.

slicers

Graphic objects used to filter data.

slicers

You can connect ____ to more than one PivotTable to filter the data.

slicers

The field or fields selected for sorting records are called ____ keys.

sort

A (n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

sparkline

A Word document often contains data stored in a ____ that can be copied and pasted into an Excel worksheet.

table

A ____ should be formatted so that the records are easily distinguished.

table

A worksheet's row-and-column structure can be used to organize and store a ____.

table

When Excel imports a database table, the data is placed in an Excel ____.

table

XML data always is imported as a ____.

table

The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.

table array

A ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.

template

You should create good ____ to ensure your workbooks are free of errors.

test data

A ____ contains little or no formatting.

text file

You can add text to a SmartArt graphic by using the ____.

text pane

Which of the following steps must be taken in preparation for working with macros in Excel?

the DEVELOPER tab must be made available on the ribbon a security setting must be modified to enable macros all worksheets must be unprotected the workbook that includes macros must be saved as an Excel Macro-Enabled Workbook file type

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

theme

Which of the following are true about macros?

they save time they ensure consistency they automate repetitive tasks they reduce formatting conformity


Ensembles d'études connexes

Strategic Management Tentafrågor

View Set

MEDSURG II: Saunders Ethical Legal Q's

View Set

Science 6_Lesson-1:Fill the Blank, Vocabulary & Questions

View Set

World Geography Chapter 5 Test Review

View Set

CH 14 Power, Influence and Leadership

View Set

Chapter 2- Money Management Skills

View Set

What are the President's enumerated powers? (pc)

View Set

Unit 1 Test: International Governments

View Set