devry bis155 all weeks quizes

| June 7, 2016

Question
quizes

week 1

Question 1. Question :

(TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel 2010)?

Displays the name of a worksheet within a workbook

Is at the intersection of a column and a row

Identifies the address of the current cell

Displays the content of the active cell

: Textbook Chapter 1

2 of 2

Question 2. Question :

(TCO 1) In Excel 2010, a sheet tab ________.

displays the content of the active cell

conceals the applicable formulas for the workbook

identifies the address of the current cell

displays the name of a worksheet within a workbook

: Textbook Chapter 1

2 of 2

Question 3. Question :

(TCO 1) Which of the following best describes the AutoComplete function?

Adds all the numbers in the row automatically

Searches for and displays any other similar label in the current column as you begin to type

Adds all the numbers in the columns automatically

Is a number that represents a quantity and can be the basis of calculations

: Textbook Chapter 1

2 of 2

Question 4. Question :

(TCO 1) Why would you use cell references in formulas instead of constant values?

You can easily include letters, numbers, and spaces

It is easier to debug the errors

You can change the input values without changing the formulas

You can control the sequence in which Excel performs arithmetic operations

: Textbook Chapter 1

2 of 2

Question 5. Question :

(TCO 1) Which of the following best describes the result of using the fill handle on a cell containing a formula?

Cannot complete a sequence of dates in a column

Changes the background color of the selected cells to yellow

Copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula

Has two or more sub-commands related to the command

: Textbook Chapter 1

2 of 2

Question 6. Question :

(TCO 1) Which of the following would allow you to adjust the column width and/or row height of many cells at once?

Just type longer or taller formulas in some of them

Click and drag across the cells to select them and use any sizing method you choose

Drag the fill handle across the cells

Type A1 in the “Go To” dialog box

: Textbook Chapter 1

2 of 2

Question 7. Question :

(TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a:

workbook.

ledger.

document.

journal.

: Textbook Chapter 1

2 of 2

Question 8. Question :

(TCO 1) Which of the following describes the horizontal Alignment in Excel 2010?

Refers to the up-down position of contents in a cell

Removes the vertical lines running through the data

Puts a line horizontally through the data

Refers to the left-right position of contents in a cell

: Textbook Chapter 1

2 of 2

Question 9. Question :

(TCO 3) A chart can be defined as ________.

a group of related data points

a visual representation of numerical data

a numeric value that describes a single value on a chart

text that describes a collection of data points in a chart

: Textbook Chapter 3

2 of 2

Question 10. Question :

(TCO 3) A __________ is usually the most effective way to display proportional relationships, such as market share data, where the individual data values represent parts of a whole.

column chart

pie chart

bar chart

line chart

: Textbook Chapter 3

2 of 2

Question 11. Question :

(TCO 3) Which of the following best describes the chart area?

Contains graphical representation of values in data series

Contains the entire chart and all of its elements

A vertical line that borders the plot area to provide a frame of reference for measurement

A horizontal line that borders the plot area to provide a frame of reference for measurement

: Textbook Chapter 3

2 of 2

Question 12. Question :

(TCO 3) To display similar data in a single column, with each series of data distinguished by a different color, use a:

stacked column chart.

pie chart.

3-D column chart.

box diagram.

: Textbook Chapter 3

2 of 2

Question 13. Question :

(TCO 3) To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a:

diagram.

pop-up comment box.

legend.

note.

: Textbook Chapter 3

2 of 2

Question 14. Question :

(TCO 3) In Excel, an area chart _______.

shows the high, low, and close prices for individual stocks over time

trends using two dimensions on a continuous curve

emphasizes the magnitude of changes over time by filling in the space between lines with a color

shows a relationship between two variables

: Textbook Chapter 3

2 of 2

Question 15. Question :

(TCO 3) Which of the following best describes a sparkline?

A label that describes either the category axis or the value axis

A miniature chart contained in a single cell

The value or name of a data point

A label that describes the chart

: Textbook Chapter 3

2 of 2

* Times are displayed in (GMT-07:00) Mountain Time (US & Canada)

week 2

(TCO 2) An absolute cell reference:

causes a potential error.

indicates a cell’s specific location and the reference does not change when you copy the formula.

occurs when a formula directly or indirectly refers to the cell containing the formula.

contains both an absolute and a relative cell reference.

: Textbook Chapter 2

Comments:

Question 2. Question :

(TCO 2) Which of the following best describes a mixed cell reference?

Occurs when a formula directly or indirectly refers to the cell containing the formula.

Causes a potential error.

Contains absolute or relative cell references, but not both.

Contains both an absolute and a relative cell reference.

: Textbook Chapter 2

Comments:

Question 3. Question :

(TCO 2) The rules for constructing a function can be referred to as the function’s _____.

synthesis

synergy

synchronization

syntax

: Textbook Chapter 2

Comments:

Question 4. Question :

(TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function.

PRESENT

TODAY

CURRENT

SET

: Textbook Chapter 2

Comments:

Question 5. Question :

(TCO 2) The _____ function returns a result based on a condition.

MAX

TODAY

FIND

IF

: Textbook Chapter 2

Comments:

Question 6. Question :

(TCO 2) The MAX function identifies the _____.

highest value in a range.

number of blank cells in a range.

lowest value in a range.

midpoint value in a range.

: Textbook Chapter 2

Comments:

Question 7. Question :

(TCO 2) The NOW function would perform which of the following?

Contains another function embedded inside one or more of its arguments.

Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.

Evaluates true or false.

Displays the current date and time.

: Textbook Chapter 2

Comments:

Question 8. Question :

(TCO 2) The _____ number is the number of the column in the lookup table that contains the return values.

lookup value

column index

lookup table

random

: Textbook Chapter 2

Comments:

Question 9. Question :

(TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell.

sizing handle

pointer

fill handle

insertion point

: Textbook Chapter 2

Comments:

Question 10. Question :

(TCO 2) To simplify entering ranges in formulas, you can use _____.

range names

a cell’s relative location

both an absolute and a relative cell reference

a cell’s specific location

: Textbook Chapter 2

Comments:

Question 11. Question :

(TCO 2) When calculating a PMT function, the RATE would be described best by which of the following?

It is the periodic interest rate, such as a monthly interest rate.

It is the total number of payment periods.

It is a word or a string of characters that represent one or more cells.

It is the present value of the loan.

: Textbook Chapter 2

Comments:

Question 12. Question :

(TCO 7) A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose.

theme

style

template

macro

: Textbook Chapter 11

Comments:

Question 13. Question :

(TCO 7) The process of protecting a worksheet requires you to enter a(n) _____.

user name

e-mail address

IN user key

password

: Textbook Chapter 11

Points Received: 0 of 2

Comments:

Question 14. Question :

(TCO 7) You must _____ the recording of the macro when you have completed the tasks it was designed to do.

begin

stop

copy

paste

: Textbook Chapter 11

Comments:

Question 15. Question :

(TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.

View

Data

Insert

Developer

: see p. 608 in textbook, first point under “Creating Macro Buttons.”

Comments:

week 3

(TCO 4) In Excel, a dataset would be which of the following?

Indicates where data starts on a new printed page

CORRECT Collection of structured, related data in columns and rows

Freezing rows to keep them visible

Freezing panes to keep them visible

: Textbook Chapter 4

2 of 2

Question 2. Question :

(TCO 4) Which of the following best describes a page break?

Freezes only the top row

The sequence in which pages print

CORRECT Indicates where data starts on a new printed page

Stops the printer from printing

: Textbook Chapter 4

2 of 2

Question 3. Question :

(TCO 4) To create a table from an existing range of data, _____.

click within the range, click the Table Tools Design tab, and then select Convert to Table

select any cell in the worksheet and then click Existing Range in the Tools group

click in a cell and on the Home tab, and click the Insert arrow in the Cells group

CORRECT click the Insert tab and then click Table in the Tables group

: Textbook Chapter 4

2 of 2

Question 4. Question :

(TCO 4) Filtering the Cost column (field) to show only records greater than $10,000 is an application of _____.

a Date Filter

a Text Filter

INCORRECT the use of a table element as a formula

CORRECT a Number Filter

: Textbook Chapter 4

0 of 2

Question 5. Question :

(TCO 4) Which of the following best describes conditional formatting?

CORRECT Highlights or emphasizes cells that meet certain conditions

Tags a table element as a reference in a formula

Formats the condition of the worksheet in preparation for printing

Calculates an aggregate for values in a range or database

: Textbook Chapter 4

2 of 2

Question 6. Question :

(TCO 4) In addition to sorting and filtering cells by content, you can sort and/or filter by _____.

top/bottom rule

conditional formatting

icon sets

the data bar

: Textbook Chapter 4

0 of 2

Question 7. Question :

(TCO 4) When data is grouped, the margin area displays the _____.

aggregate columns

group headings

collapse and expand buttons

group totals

: Textbook Chapter 5

0 of 2

Question 8. Question :

(TCO 4) To add a PivotTable, choose the Insert PivotTable command from the _____ group.

tables

format

layout

chart

: Textbook Chapter 5

0 of 2

Question 9. Question :

(TCO 4) To begin a filter based on a particular field, you drag the desired field to which area under Drag fields between areas below?

Column Labels

Report Filter

Row Labels

Values

: Textbook Chapter 5

0 of 2

Question 10. Question :

(TCO 4) To create a calculated field, select _____ located on the PivotTable Tools Options tab.

Calculations

Insert Calculated Field dialog launcher

Tools

PivotTable Calculation

: Textbook Chapter 5

0 of 2

Question 11. Question :

(TCO 4) Excel applies basic formatting to PivotTables such as _____.

subtotals in italics

primary row labels in bold

primary row labels in italics

subtotals in red

: Textbook Chapter 5

2 of 2

Question 12. Question :

(TCO 4) What are the areas of a PivotTable Report where fields can be placed?

Criteria Range and Extract Range

Values, Axis Fields, Legend Fields, and Report Filter

CORRECT Values, Row Labels, Column Labels, and Report Filter

Database, Field, and Criteria

: Textbook Chapter 5

2 of 2

Question 13. Question :

(TCO 4) After a PivotChart has been created, the PivotTable Settings can still be changed by using the _____.

PivotTable Field List

Chart Layout command

Format Tab

Data Tab

: Textbook Chapter 5

2 of 2

Question 14. Question :

(TCO 4) Click the _____ to sort or filter the chart representation based on the values.

Axis Field arrows

Report Filter arrows

Values arrows

Legend Field arrows

: Textbook Chapter 5

0 of 2

Question 15. Question :

(TCO 4) Which of the following will NOT delete a PivotChart?

Go to the Home tab and click Cut

Right-click the chart and click Cut

I Select the chart and then press Delete

Click and drag the PivotChart off the worksheet

: Textbook Chapter 5

0 of 2

week 4

(TCO 8) To

import a text file into Excel, click ________ on the File tab.
Open

New

Info

Options

Question 2. Question :

(TCO 8) Which of the following is NOT a text file?

Tab-delimited

Comma-separated value

XML

Fixed-width

Question 3. Question :

(TCO 8) Which of the following is NOT a method for refreshing data?

Click the Refresh All command.

Save the Excel workbook.

Click the Refresh All arrow, then click Refresh.

Right-click in a range of data and then select Refresh.

Question 4. Question :

(TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.

Fixed

Mixed

Divided

Text

Question 5. Question :

(TCO 8) To change the text string jOHn dOE to John Doe, use the ________ function.

CONCATENATE

PROPER

UPPER

LOWER

Question 6. Question :

(TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function.

UPPER

LOWER

PROPER

CONCATENATE

Question 7. Question :

(TCO 8) Which of the following functions does not change the case or capitalization of text?

PROPER

CAPS

UPPER

LOWER

:

Question 8. Question :

(TCO 8) When the data source you select for a mail merge is an Excel workbook that has more than one worksheet, what does Word do?

Automatically uses the data from the first worksheet in the workbook.

Automatically uses the data from the last worksheet in the workbook.

Displays a list of the worksheet names and lets you pick which one to use.

Displays an error message and is unable to continue.

:

Question 9. Question :

(TCO 8) The New Comment command is located on the ________ tab.

View

Review

Data

IN File

Question 10. Question :

(TCO 8) If you have a table with city, state, and zip code merged together in column C and use the Convert Text to Columns Wizard to separate the data into three fields, you need:

empty columns to the right of column C.

empty rows at the bottom of the worksheet.

empty columns to the left of column C.

empty rows at the top of the worksheet.

Instructor Explanation: Textbook Chapter 9

Points Received: 2 of 2

Comments:

Question 11. Question :

(TCO 8) The command to track changes is located on the ________ tab.

File

Data

Review

View

Question 12. Question :

(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.

Gmail

Hotmail

Yahoo

Outlook

Question 13. Question :

(TCO 8) The ________ command displays additional document properties such as Company.

Options

Permissions

Show Fewer Properties

Show All Properties

Instructor Explanation: Textbook Chapter 10

Points Received: 2 of 2

Comments:

Question 14. Question :

(TCO 8) All EXCEPT ___________ are Excel functions that help you manipulate text.

PROPER

UPPER

SUBSTITUTE

RESPOND

Instructor Explanation: Textbook Chapter 10

Points Received: 2 of 2

Comments:

Question 15. Question :

(TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password.

Check for Issues

Protect Workbook

Manage Versions

Options

week 5

(TCO 5) Excel’s multiple worksheet abilities can do all of the following EXCEPT:

create Pivot Charts.

group worksheets together to enter data.

display worksheets side by side.

IN create links among the worksheets.

Comments:

Question 2. Question :

(TCO 5) In Excel, which of the following would you perform to group adjacent worksheets?

Click the first tab, hold Shift, and then click the last tab.

Click the first tab, hold Ctrl, and then click the last tab.

Right-click a worksheet tab, then select Select All Sheets.

Right-click a worksheet tab, then select Group.

Comments:

Question 3. Question :

(TCO 5) If the active cell is in column A, but not in row 1, when you click the Split command, the worksheet will appear in two ________ panes.

horizontal

IN vertical

diagonal

square

Comments:

Question 4. Question :

(TCO 5) In Excel, which of the following is NOT a method for splitting a worksheet?

Drag a split box.

IN Double-click a split box.

Right-click in the active cell and click Split.

Click Split in the Window group on the View tab.

Comments:

Question 5. Question :

(TCO 5) Which of the following external references is for a workbook and worksheet that have no spaces?

“[New.Jersey.xlsx]Qtr4!”B6

‘[New.Jersey.xlsx]Qtr4!’B6

IN [New.Jersey.xlsx]Qtr4!,B6

[NewJersey.xlsx]Qtr4!B6

Comments:

Question 6. Question :

(TCO 5) Excel’s ability to manage worksheets allows you to do all EXCEPT:

validate data in worksheets.

hide worksheets.

arrange windows to view multiple sheets at once.

split a worksheet window to see separate sections at once.

Comments:

Question 7. Question :

(TCO 5) Which of the following is the proper use of a 3D formula?

=SUM(Yr1:Yr5!C7)

IN =SUM(Yr1-Yr5!C7)

=SUM(‘Yr1:Yr5’!C7)

=SUM(“Yr1:Yr5”!C7)

Comments:

Question 8. Question :

(TCO 6) A one-variable data table must have at least ________ blank row(s) and ________ blank column(s) between the dataset and the data table.

two, two

two, one

one, two

one, one

Comments:

Question 9. Question :

(TCO 6) Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?

IN Scenario Manager

Goal Seek

One-variable data table

Two-variable data table

Comments:

Question 10. Question :

(TCO 6) What is the main difference between Goal Seek and variable data tables?

Goal Seek produces a list of result values.

Goal Seek uses the original worksheet data to change an input.

Goal Seek manipulates multiple variables to produce multiple results.

Goal Seek shows results in a separate table.

Comments:

Question 11. Question :

(TCO 6) The Scenario Manager dialog box enables you to do all the following EXCEPT:

format scenarios.

add scenarios.

IN delete scenarios.

edit scenarios.

Comments:

Question 12. Question :

(TCO 6) Which of the following is NOT in the What-If Analysis command in the Data Tools group on the Data tab?

Scenario Manager

Goal Seek

Data Table

Solver

Comments:

Question 13. Question :

(TCO 6) Which of the following is NOT one of the three parameters in Solver?

IN Constraints

Objective cell

Changing variable cells

Input value

Comments:

Question 14. Question :

(TCO 6) Which of the following is NOT required for Solver to generate a solution?

Constraints

A formula that produces a value to be optimized

Precedent values

IN Variables that change within the specified limitations

Comments:

Question 15. Question :

(TCO 6) The initial results of a Goal Seek are:

automatically entered into the worksheet.

inserted into a new worksheet.

presented visually in a chart.

shown in the Goal Seek Status dialog box.

Comments:

Order your essay today and save 30% with the discount code: ESSAYHELPOrder Now