Skip to content
Solved Assignments

BIS155 Week 2 Quiz: Excel Functions and Formulas

Quiz on Excel functions and formulas.

Preview 2 of 4 pages

See the first 2 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    BIS155 Week 2 Quiz: Excel Functions and Formulas Devry Question 1.1.(TCO 2) An absolute cell reference:(Points : 2) 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. Question 2.2.(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 Question 3.3.(TCO 2) =$E2 - G$4 contains examples of _____ cell references.(Points : 2) Absolute Mixed Relative Constant Question 4.4.(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. Question 5.5.(TCO 2) The MEDIAN function would identify the ____.(Points : 2) lowest value in a range. midpoint value in a range. highest value in a range. total number of cells in a range. Question 6.6.(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. Question 7.7.(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.

  2. Page 2

2 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.