BIS155 Week 2 Quiz: Excel Functions and Formulas
Quiz on Excel functions and formulas.
Elijah Nelson
Contributor
4.5
47
about 1 month ago
Preview (2 of 4)
Sign in to access the full document!
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.
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.
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
University
DeVry University
Subject
Information Technology