BIS 155 Week 1 Quiz

 

Question 1

0 / 2 pts

(TCO 1) An Output Area (as it applies to Excel 2016) is defined as _____.

Correct Answer

  

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

   

displaying the name of a worksheet within a workbook

 

You Answered

   

a range of cells containing values for variables used in formulas

 

   

displaying the content of the active cell

 

See Chapter 1 in the textbook.

 

Question 2

2 / 2 pts

(TCO 1) In Excel 2016, a cell is best described by which of the following?

   

Must have formulas entered into it

 

   

Cannot be used for labels or headings

 

   

Must have text entered into it

 

Correct!

   

Is the intersection of a column and a row

 

See Chapter 1 in the textbook.

 

Question 3

2 / 2 pts

(TCO 1) If you wanted to insert the current date into a header or footer element, what would the code look like?

   

code &[Page]

   

Ctrl + Alt + Delete

 

   

The Ctrl + D key combination

 

Correct!

   

code &[Date]

See Chapter 1 in the textbook.

 

Question 4

2 / 2 pts

(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

 

Correct!

   

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

 

See Chapter 1 in the textbook.

 

Question 5

2 / 2 pts

(TCO 1) The fill handle in Excel 2016 _____.

   

is the fastest way to type A1 in the name box

 

   

helps carry over the fill to the remaining slides

 

   

is the same action as pressing enter

 

Correct!

  

is a small green square at the bottom-right corner of a cell that facilitates fill operations

See Chapter 1 in the textbook.

 

Question 6

2 / 2 pts

(TCO 1) Ribbon Commands with arrows indicate _____.

   

a shortcut to cell A1

 

Correct!

   

there are two or more subcommands related to the command

 

   

the next step in the process

 

   

directionality

 

See Chapter 1 in the textbook.

 

Question 7

2 / 2 pts

(TCO 1) The three types of data that can be entered in a cell in an Excel worksheet are _____.

   

columns, rows, and fields

 

   

numbers, fonts, and styles

 

   

functions, comments, and macros

 

Correct!

   

text, values, and formulas

 

See Chapter 1 in the textbook.

 

Question 8

2 / 2 pts

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

 

Correct!

   

in the bottom right corner of the pasted data.

 

See Chapter 1 in the textbook.

 

Question 9

2 / 2 pts

(TCO 2) In Excel, a relative cell reference _____.

  

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

 

Correct!

  

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

See Chapter 2 in the textbook.

 

Question 10

2 / 2 pts

(TCO 2) Which of the following function keys toggles through relative, absolute, and mixed references?

   

There is no way to toggle through the various types of references.

 

   

F8

 

Correct!

   

F4

 

   

B4

 

See Chapter 2 in the textbook.

 

Question 11

2 / 2 pts

(TCO 2) =$E2-G$4 contains examples of _____ cell references.

   

absolute

 

Correct!

   

mixed

 

   

relative

 

   

constant

 

See Chapter 2 in the textbook.

 

Question 12

2 / 2 pts

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

   

PRESENT

 

Correct!

   

TODAY

 

   

CURRENT

 

   

SET

 

 

See Chapter 2 in the textbook.

 

Question 13

2 / 2 pts

(TCO 2) The MEDIAN function would identify the ____.

   

lowest value in a range

 

Correct!

   

midpoint value in a range

 

   

highest value in a range

 

   

total number of cells in a range

 

 

See Chapter 2 in the textbook.

 

Question 14

2 / 2 pts

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

   

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

 

Correct!

   

Tallies the number of cells in a range that contain values

 

 

See Chapter 2 in the textbook.

 

Question 15

2 / 2 pts

(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

 

Correct!

   

Displays the current date and time

 

See Chapter 2 in the textbook.

===============================

Question 1

2 / 2 pts

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

   

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

 

Correct!

   

Displays the content of the active cell

 

See Chapter 1 in the textbook.

 

Question 2

2 / 2 pts

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

   

Identifies the electronic "neighborhood" of a spreadsheet

Correct!

   

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

See Chapter 1 in the textbook.

 

Question 3

2 / 2 pts

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

   

Adds all of the numbers in the row automatically

 

Correct!

  

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

   

Adds all of the numbers in the columns automatically

 

  

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

See Chapter 1 in the textbook.

 

Question 4

2 / 2 pts

(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

 

Correct!

   

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

 

See Chapter 1 in the textbook.

 

Question 5

2 / 2 pts

(TCO 1) The fill handle in Excel 2016 _____.

   

is the fastest way to type A1 in the name box

 

   

helps carry over the fill to the remaining slides

 

   

is the same action as pressing enter

 

Correct!

  

is a small green square at the bottom-right corner of a cell that facilitates fill operations

See Chapter 1 in the textbook.

 

Question 6

2 / 2 pts

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

 

Correct!

  

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.

 

See Chapter 1 in the textbook.

 

Question 7

2 / 2 pts

(TCO 1) Which of the following best describes a range in Excel 2016?

   

Cannot be selected with the mouse

 

  

Are the numbers that fall between the smallest and largest in the formula

 

   

Is another word for the active worksheet

 

Correct!

   

Refers to a group of adjacent or contiguous cells

 

See Chapter 1 in the textbook.

 

Question 8

2 / 2 pts

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

   

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

 

Correct!

   

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

 

See Chapter 1 in the textbook.

 

Question 9

2 / 2 pts

(TCO 2) An absolute cell reference

   

causes a potential error.

 

Correct!

  

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.

 

See Chapter 2 in the textbook.

 

Question 10

2 / 2 pts

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

Correct!

   

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

 

See Chapter 2 in the textbook.

 

Question 11

2 / 2 pts

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

   

abstract

 

   

relative

 

Correct!

   

mixed

 

   

absolute

 

See Chapter 2 in the textbook.

 

Question 12

2 / 2 pts

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

   

Identifies the midpoint value in a set of values

 

Correct!

   

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

 

See Chapter 2 in the textbook.

 

Question 13

2 / 2 pts

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

   

MAX

 

   

TODAY

 

   

FIND

 

Correct!

   

IF

 

See Chapter 2 in the textbook.

 

Question 14

2 / 2 pts

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

   

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

 

Correct!

   

Tallies the number of cells in a range that contain values

 

 

See Chapter 2 in the textbook.

 

Question 15

2 / 2 pts

(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

 

Correct!

   

Displays the current date and time

 

See Chapter 2 in the textbook.

 

SmartExpert

(118)

Status NEW Posted 02 Nov 2017 10:11 AM My Price 10.00

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

Attachments

file 1509618568-BIS 155 Week 1 Quiz.docx preview (1417 words )

B-----------IS -----------155----------- We-----------ek -----------1 Q-----------uiz----------- Q-----------ues-----------tio-----------n 1----------- 0----------- /----------- 2Â----------- pt-----------s -----------(TC-----------O 1-----------) A-----------n O-----------utp-----------ut -----------Are-----------a (-----------as -----------it -----------app-----------lie-----------s t-----------o E-----------xce-----------l 2-----------016-----------) i-----------s d-----------efi-----------ned----------- as----------- __-----------___-----------. -----------Cor-----------rec-----------t A-----------nsw-----------er -----------  ----------- a----------- ra-----------nge----------- of----------- ce-----------lls----------- co-----------nta-----------ini-----------ng -----------res-----------ult-----------s b-----------ase-----------d u-----------pon----------- ma-----------nip-----------ula-----------tio-----------n o-----------f t-----------he -----------var-----------iab-----------les----------- in----------- th-----------e i-----------npu-----------t a-----------rea----------- Â----------- Â ----------- d-----------isp-----------lay-----------ing----------- th-----------e n-----------ame----------- of----------- a -----------wor-----------ksh-----------eet----------- wi-----------thi-----------n a----------- wo-----------rkb-----------ook----------- Â-----------  -----------You----------- An-----------swe-----------red----------- Â----------- Â ----------- a----------- ra-----------nge----------- of----------- ce-----------lls----------- co-----------nta-----------ini-----------ng -----------val-----------ues----------- fo-----------r v-----------ari-----------abl-----------es -----------use-----------d i-----------n f-----------orm-----------ula-----------s -----------  -----------  -----------  ----------- di-----------spl-----------ayi-----------ng -----------the----------- co-----------nte-----------nt -----------of -----------the----------- ac-----------tiv-----------e

Not Rated(0)

• Buy Answer