# BIS 155 All Quizzes

\$23.00

BIS 155 All Quizzes
(TCO 1) If you had worksheets that contained the inventory of each room…

SKU: BIS 155 All Quizzes Categories: , Tags: , , ,

## BIS 155 All Quizzes

BIS 155 All Quizzes

A+ Week 1-5

Quiz Week 1

https://www.hiqualitytutorials.com/product/bis155-quiz-week-1/

(TCO 1) An Output Area (as it applies to Excel 2010) is defined as_______. (Points : 2)

A range of cells containing results based upon manipulation of the variables in the input area

Displays the name of a worksheet within a workbook

A range of cells containing values for variables used in formulas

Displays the content of the active cell

(TCO 1) In Excel 2010, a cell is best described by which of the following? (Points : 2)

Must have formulas entered into it

Cannot be used for labels or headings

Must have text entered into it

Is the intersection of a column and a row

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

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

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

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

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

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

(TCO 1) Ribbon Commands with arrows indicate_____. (Points : 2)

A shortcut to cell A1

There are two or more sub-commands related to the command

The next step in the process

Directionality

(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: (Points : 2)

Workbook.

Ledger

Document

Journal

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

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

(TCO 3) A data series is a group of related ____________. (Points : 2)

Charts on a worksheet

Category labels on a horizontal axis

Data points on a chart

Numerical values on a vertical axis

(TCO 3) Which of the following best describes a column chart? (Points : 2)

Displays data comparisons vertically in columns

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

Contains graphical representation of values in data series

Contains the entire chart and all of its elements

(TCO 3) When creating a chart in Excel, a single data series _____. (Points : 2)

Compares values for one set of data

Groups or clusters similar data in columns to compare values across categories

Is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

Compares two or more sets of data in one chart

(TCO 3) When creating a chart in Excel, a multiple data series _______. (Points : 2)

Groups or clusters similar data in columns to compare values across categories

Compares two or more sets of data in one chart

Is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart

Places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color

(TCO 3) A pie chart with one or more slices separated for emphasis is called a(n) ____________ pie chart. (Points : 2)

Expanded

Exploded

Displaced

Clustered

(TCO 3) When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: (Points : 2)

Design, Layout, and Format

Home, Insert, and Page Layout

Chart, Type, and Formulas

Data, Review, and Data

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

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

(TCO 1) Which of the following best describes a cell address?

Identifies the electronic “neighborhood” of a spreadsheet

Identifies a cell by a column letter and a row number

Searches for and displays similar labels as you type

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

(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

(TCO 1) Which of the following best describes the order of precedence as it applies to math operations in Excel?

Includes letters, numbers, and spaces

Controls the sequence in which Excel performs arithmetic operations

Is a software application used to create and modify business communications

Includes formulas, functions, and formatting

BIS 155 All Quizzes

(TCO 1) When you paste copied data, Excel displays the Paste Options button:

In the status bar at the left of the screen

In the next set of nonadjacent ranges

On the toolbar

In the bottom right corner of the pasted data

(TCO 3) Groups of related numeric values in an Excel worksheet are:

Data point

Data roles

Categories

Data series

(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

(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

(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

(TCO 3) After creating a chart, you can change the chart type by using _____.

Page Layout tab / Chart Options button

Design tab / Change Chart Type button

Data tab / Chart Changer tool

You cannot change the chart

BIS 155 All Quizzes

Quiz Week 2

https://www.hiqualitytutorials.com/product/bis-155-quiz-week-2/

(TCO 2) In Excel, a relative cell reference: (Points : 2)

Indicates a cell’s specific location and the reference does not change when you copy the formula.
Contains both an absolute and a relative cell reference

Indicates a cell’s relative location from the cell containing the formula; the reference changes when you copy the formula

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

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

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

(TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a(n) _____ cell reference. (Points : 2)

Abstract

Relative

Mixed

Absolute

(TCO 2) Which of the following describes the SUM function? (Points : 2)

Identifies the midpoint value in a set of values

Calculates the total of values contained in two or more cells

Calculates the arithmetic mean or average of values in a range

Displays the lowest value in a range

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

Max

Today

Find

If

(TCO 2) Which of the following best describes the COUNT function? (Points : 2)

Tallies the number of cells in a range that are not empty

Tallies the number of blank cells in a range

Displays the current date

Tallies the number of cells in a range that contain values

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

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

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

Lookup value
Column index

Lookup table

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

Sizing handle

Pointer

Fill handle

Insertion point

(TCO 2) One benefit of using range names in formulas is that _____ . (Points : 2)

It directly or indirectly refers to the cell containing the formula

It contains both an absolute and a relative cell reference

It identifies the present value of the loan

If you copy the formula, you do not have to make the cell reference absolute

(TCO 2) The PMT function is best described by which of the following? (Points : 2)

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

It is the total number of payment periods

It is the present value of a loan

It calculates the periodic payment for a loan with a fixed interest rate and a fixed term

(TCO 7) Which of the following is NOT an Excel tool used to improve productivity in developing consistently formatted workbooks? (Points : 2)

Macros

Templates

Themes

Background

(TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit. (Points : 2)

Format

Hide

Lock

Unlock

(TCO 7) By default, a macro records cells as _____ references if they are selected while recording the macro. (Points : 2)

Absolute

Relative

Flexible

Mixed

(TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. (Points : 2)

Saves

Deletes

Runs

Disables

(TCO 2) In Excel, a function can be defined as a _____. (Points : 2)

Predefined formula that performs a calculation

Cell reference or a value

List of values and defined names as you enter data into a spreadsheet

Set of rules that govern the structure and components for a formula

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

Synthesis

Synergy

synchronization

syntax

(TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true or false is also sometimes called a _____.

Logical test

Lookup value

Breakpoint

Table array action

(TCO 2) If you enter an = and the first few letters of a function in the formula bar, Excel will display a drop-down list of functions beginning with those letters. This feature is called _____.

Syntax Helper

Formula AutoComplete

Formula Wizard

Function Finder

(TCO 2) Which of the following best describes the HLOOKUP function?

The periodic interest rate, such as a monthly interest rate

Calculates the periodic payment for a loan with a fixed interest rate and fixed term

Looks up a value in a lookup table where the first column contains the values to compare with the lookup value

Looks up a value in a lookup table in which the first row contains the values to compare with the lookup value

(TCO 7) Which of the following file formats can store macros?

Xlsm

CSV

XML
XLSX

(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

BIS 155 All Quizzes

Quiz Week 3

https://www.hiqualitytutorials.com/product/bis155-quiz-week-3/

(TCO 4) _____ column and row headings enables you to keep these headings on the screen when scrolling through a large spreadsheet. (Points : 2)

Formatting

Freezing

Resizing

Tiling

(TCO 4) In Excel, a table is defined as _____. (Points : 2)

An area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis

A complete set of data for an entity

A Field, which is an individual piece of data

An individual piece of data, such as a last name

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

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

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

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

A Date Filter

A Text Filter
the use of a table element as a formula

A Number Filter

(TCO 4) To apply a red background color to cells for employees who have sales greater than \$1,000, you can use _____. (Points : 2)

A PivotTable

A multiple level sort

Conditional formatting

A range name

(TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____. (Points : 2)

Displays a particular color based on the relative value of the cell contents to other selected cells

Displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range

Helps locate where data may be missing

Helps locate errors in cells quickly

(TCO 4) For Subtotals to be useful and accurate, it is important that the data be _____ correctly. (Points : 2)

sorted
formatted

aligned

labeled

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

Tables

Format

Layout

Chart

(TCO 4) The Insert Calculated Field dialog box requires you do all the following EXCEPT _____. (Points : 2)

Enter formulas using field names instead of cell references
Enter a description column heading for the calculated field

Build formulas using mathematical operands such as +, -, and *

Enter formulas using cell references

(TCO 4) Data displayed in the PivotTable will be updated _____. (Points : 2)

When you right-click a cell in the PivotTable and select Refresh

Automatically as soon as the source data changes

When you select the worksheet containing the PivotTable

When you create a PivotChart

(TCO 4) A quick way to display the Go to dialog box is to press the _____ key(s). (Points : 2)

F4

Ctrl+Home

Ctrl+End
F5

(TCO 4) To go to the top of your spreadsheet quickly, use the _____ key(s). (Points : 2)

Ctrl+End

Arrow

Ctrl+Home

Esc

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

Axis Field arrows

Report Filter arrows

Values arrows

Legend Field arrows

(TCO 4) Pivot Charts look best when they use basic charts, such as a _____. (Points : 2)

Column chart

Scatter chart

Surface chart

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

Freezes only the top row

The sequence in which pages print

Indicates where data starts on a new printed page

Stops the printer from printing

(TCO 4) The Subtotal command is located on the _____ tab.

Data

Formula

Page layout

Insert

(TCO 4) _____ are created to organize and summarize data in PivotTables.

Categories

Types

Titles

Levels

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

Calculations

Insert Calculated Field dialog launcher

Tools

PivotTable Calculation

(TCO 4) A Pivot Table Style controls all the following EXCEPT _____.

Bolding

Font colors

Number format

(TCO 4) The PivotChart Tools contextual tab includes all the following EXCEPT _____.

Design

Layout

Format

Type

(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

Select the chart and then press Delete

Click and drag the PivotChart off the worksheet

BIS 155 All Quizzes

Quiz Week 4

https://www.hiqualitytutorials.com/product/bis155-quiz-week-4/

(TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2)

Commas

Tabs
Spaces

Hyphens

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

Tab-delimited

Comma-separated value

XML

Fixed-width

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

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.

(TCO 8) The Text to Columns command is found on the ________ tab. (Points : 2)

File

Data

Insert

Page Layout

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

CONCATENATE

PROPER

UPPER

LOWER

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

UPPER

LOWER

PROPER

CONCATENATE

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

PROPER

CAPS

UPPER

LOWER

(TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _________ tab of the Ribbon. (Points : 2)

Merge

Mailings

Home

Review

BIS 155 All Quizzes

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

View

Review

Data

File

(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: (Points : 2)

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.

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

File

Data

Review

View

(TCO 8) The command to send an Excel workbook by e-mail is located on the ________ tab. (Points : 2)

File

Home

Insert

View

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

Options

Permissions

Show Fewer Properties

Show All Properties

(TCO 8) To join two or more text strings into one text string, you can use the ___________. (Points : 2)

Convert Text to Columns Wizard

Merge and Center command on the Home tab of the Ribbon

CONCATENATE function

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

Check for Issues

Protect Workbook

Manage Versions

Options

(TCO 8) Which of the following is one of the most common file types imported into Excel?

Text

PowerPoint

Web

Word

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

Fixed

Mixed

Divided

Text

(TCO 8) Which of the following is a frequently used function to manipulate txt?

CONCATENATE

PMT

IF

DATE

(TCO 8) To change the text string JANE doe to jane doe, use the ________ function.

CONCATENATE

PROPER

UPPER

LOWER

(TCO 8) Which of the following will produce the same result as the CONCATENATE function?

=A4&B4

=A4+B4

=A4B4

=A4,B4

(TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers’ names and addresses stored in an Excel file, you should choose _________ from the Select Recipients menu while performing the merge.

Type New List

Use Existing List

Import from Excel

Select from Outlook Contacts

(TCO 8) If first and last names are combined in a single column, you can split them into two separate columns using the ________.

Split Names Wizard

PivotTable feature

CONCATENATE function

Convert Text to Columns Wizard

(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

(TCO 8) Windows can search for files by author name or keywords that have been entered into ________.

a file name

the Trust Center

document properties

cell A1

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

PROPER

UPPER

SUBSTITUTE

RESPOND

Quiz Week 5

https://www.hiqualitytutorials.com/product/bis155-quiz-week-5/

(TCO 5) The tabs of grouped worksheets are displayed with a ________ background. (Points : 2)

Gray

Yellow

Blue

White
(TCO 5) In Excel, which of the following would you perform to group nonadjacent worksheets? (Points : 2)

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

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

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

Right-click a worksheet tab, then select Group.

(TCO 5) When two windows of the same workbook are opened, Excel adds ________ to the title bar of the second window. (Points : 2)

The letter B

The number 2

The letter A

The number 1

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

Drag a split box

Double-click a split box.

Right-click in the active cell and click Split.

Click Split in the Window group on the View tab.

(TCO 5) If a worksheet name has a space in it, ________ surround the worksheet name in the worksheet reference. (Points : 2)

Double quotation marks

Single quotation marks

Parentheses

Brackets

(TCO 5) Which formula would return the #NAME? error? (Points : 2)

=SUM(B6.B12)

=MAX(B6:B12)

=AVG(B6:B12)

=IF(A6=”Atlanta”,A3,0)

(TCO 5) If A1 contains the hourly pay rate of \$10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)? (Points : 2)

A1

A2

A3

A1 & A2

(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. (Points : 2)

Two, two

Two, one

One, two

One, one

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

Scenario Manager

Goal Seek

One-variable data table

Two-variable data table

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

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.

(TCO 6) The Goal Seek command is located in the ________ command on the Data tab. (Points : 2)

What-If Analysis

Data Validation

Consolidate

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

Scenario Manager

Goal Seek

Data Table

Solver

(TCO 6) What happens when you add a new scenario and generate a new scenario summary report? (Points : 2)

The new report will be created on a new worksheet.

The new scenario will be included into the old report.

The new report will be added directly below the original report.

The new report will replace the original report.

(TCO 6) Which of the following commands cannot be used on a constraint in the Solver Parameters dialog box? (Points : 2)

Format

Change

Delete

(TCO 6) The maximum number of scenarios Scenario Manager can handle is: (Points : 2)

30

32

18

16

(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

(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 All Sheets.

Right-click a worksheet tab, then select Group.

(TCO 5) After saving the arrangement of windows, a workbook can be opened by opening the ________ file.

Worksheet

Workspace

Workview

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

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

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

[NewJersey.xlsx]Qtr4!B6

Textbook Chapter 8

(TCO 5) Before you can create an external reference you must first __________.

Select the cell or cells to hold the external reference.

Open the destination workbook and all source workbooks.

Switch to the source workbooks and click the cells.

Click on Insert Function on the Formulas tab.

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

=SUM(Yr1:Yr5!C7)

=SUM(Yr1-Yr5!C7)

=SUM(‘Yr1:Yr5’!C7)

=SUM(“Yr1:Yr5”!C7)

(TCO 6) Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only \$350 a month?

Solver

Data Table

Scenario Manager

Goal Seek

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

Format scenarios.

Delete scenarios.

Edit scenarios.

(TCO 6) Before creating a scenario with Scenario Manager, it is important to know which cells contain the variables you want changed and the:

Scenario names.

Formatting of the results.

Cells containing the formulas that generate the results

Final results.

(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.

BIS 155 All Quizzes

DeVry