SmartExpert

(118)

$30/per page/Negotiable

About SmartExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,English,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 57 Weeks Ago, 2 Days Ago
Questions Answered: 7570
Tutorials Posted: 7352

Education

  • BS,MBA, PHD
    Adelphi University/Devry
    Apr-2000 - Mar-2005

Experience

  • HOD ,Professor
    Adelphi University
    Sep-2007 - Apr-2017

Category > Business & Finance Posted 05 Nov 2017 My Price 8.00

BIS 155 Week 2 Quiz

Question 12 pts

(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

 

Question 22 pts

(TCO 2) Which of the following steps can be used to insert a SUM function?

Type =SUM(type the range), and press Enter.

Click a cell, click AutoSum in the Function library group on the Formulas tab, either press Enter to select the suggested range or type the range, and then press Enter.

 

Click the cell directly underneath the range you would like to SUM and press Alt=.

Any of these steps will insert the SUM function

 

Question 32 pts

(TCO 2) The _____ function uses the computer’s clock to display the current date and military time that you last opened the workbook.

=NOW

=HELLO

 

=NOW()

=TODAY()

 

Question 42 pts

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

 

Question 52 pts

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

data points

data roles

 

categories

data series

 

Question 62 pts

(TCO 3) Which best describes a data point?

A numeric value that describes a single value on a chart

A group of related data points

 

Displays data comparisons vertically in columns

Text that describes a collection of data points in a chart

 

Question 72 pts

(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

 

Question 82 pts

(TCO 3) Stock market or economic trends over long periods of time are frequently shown on a _____.

line chart

bar chart

 

pie chart

doughnut chart

 

Question 92 pts

(TCO 3) To visually determine whether there is a relationship between two variables, use a _____.

bar chart

scatter chart

 

pie chart

3-D pie chart

 

Question 102 pts

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

Design, Layout, and Format

Home, Insert, and Page Layout

 

Chart, Type, and Formulas

Data, Review, and Data
 

 

Question 112 pts

(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

 

Question 122 pts

(TCO 3) When you select a chart, Excel displays three icons on the right. Which icon comes first?

Chart layouts

Chart elements

 

Chart design

Chart examples

 

 

Question 132 pts

(TCO 3) The _____ labels show exact values or the name of a data point.

Legend

Trendline

 

Error

Data

 

Question 142 pts

(TCO 3) You can apply multiple settings like fill colors and borders at the same time using the Format  _____.

task pane

title window

 

quick layout tool

developer dialog box

 

Question 152 pts

(TCO 3) How can a data source be selected?

All of the below are true

Select the range of data contiguously

 

 

Select the range of data noncontiguously

Select the range of data, including the labels desired

Answers

SmartExpert
(118)
Status NEW Posted 05 Nov 2017 10:11 PM My Price 8.00

BIS----------- 15-----------5 W-----------eek----------- 2 -----------Qui-----------z-----------

Attachments

file 1509976758-BIS 155 Week 2 Quiz.docx preview (1164 words )
T-----------op -----------of -----------For-----------m -----------Que-----------sti-----------on -----------12Â----------- pt-----------s -----------(TC-----------O 2-----------) T-----------he -----------___-----------__ -----------num-----------ber----------- is----------- th-----------e n-----------umb-----------er -----------of -----------the----------- co-----------lum-----------n i-----------n t-----------he -----------loo-----------kup----------- ta-----------ble----------- th-----------at -----------con-----------tai-----------ns -----------the----------- re-----------tur-----------n v-----------alu-----------es.----------- -----------loo-----------kup----------- va-----------lue----------- -----------col-----------umn----------- in-----------dex----------- -----------loo-----------kup----------- ta-----------ble----------- -----------ran-----------dom----------- Â-----------  -----------Que-----------sti-----------on -----------22Â----------- pt-----------s -----------(TC-----------O 2-----------) W-----------hic-----------h o-----------f t-----------he -----------fol-----------low-----------ing----------- st-----------eps----------- ca-----------n b-----------e u-----------sed----------- to----------- in-----------ser-----------t a----------- SU-----------M f-----------unc-----------tio-----------n? ----------- T-----------ype----------- =S-----------UM(-----------typ-----------e t-----------he -----------ran-----------ge)-----------, a-----------nd -----------pre-----------ss -----------Ent-----------er.----------- -----------Cli-----------ck -----------a c-----------ell-----------, c-----------lic-----------k A-----------uto-----------Sum----------- in----------- th-----------e F-----------unc-----------tio-----------n l-----------ibr-----------ary----------- gr-----------oup----------- on----------- th-----------e F-----------orm-----------ula-----------s t-----------ab,----------- ei-----------the-----------r p-----------res-----------s E-----------nte-----------r
Not Rated(0)