BUS 1350 EXAM 1 LAPES QUESTIONS
& VALID CORRECT ANSWERS
Formula - Correct Answer ✔✔ - an expression that returns a value
- ex: A1+A2+A3+A4+A5
Function - Correct Answer ✔✔ - a named operations that replaces the arithmetic
expression in a formula
- =SUM(A1:A5)
Syntax - Correct Answer ✔✔ - a set of rules which specifies how a function should be
written FUNCTION
- (arg1, arg2, [arg3], [arg4],...)
Argument - Correct Answer ✔✔ - information the function uses to calculate an answer
AutoSum - Correct Answer ✔✔ - offers a fast and convenient way to enter commonly
used functions
SUM - Correct Answer ✔✔ sum of values in specified range
AVERAGE - Correct Answer ✔✔ average value in specified range
COUNT - Correct Answer ✔✔ - total count of numeric values in the specified range
- COUNT (value1, [value2], [value3], [value4],...)
MAX - Correct Answer ✔✔ maximum value in the specified range
MIN - Correct Answer ✔✔ minimum value in the specified range
COUNTA - Correct Answer ✔✔ - counts the number of cells in a range that are not
empty
- COUNTA (value1, [value2], [value3], [value4],...)
theme font - Correct Answer ✔✔ a font associated with a particular;ar theme and used
for headings and body text; theme fonts change automatically when the theme is
changed
standard font - Correct Answer ✔✔ a font that retains its appearance no matter what
theme is used with the workbook
serif fonts - Correct Answer ✔✔ fonts that have short decorative lines at the upper and
lower ends of their characters
, sans serif fonts - Correct Answer ✔✔ font that does not include short decorative lines at
the upper and lower ends of their characters
percent change formula - Correct Answer ✔✔ (current year value - previous year
value)/ previous year value
transposed pasted range - Correct Answer ✔✔ Put into a different place or order when
pasted into a different place
highlighting cells with conditional formats - Correct Answer ✔✔ - you can modify any
conditional formatting rule to change what is being formatted, as well as change what
formatting is applied
- you can remove a conditional format at any time without affecting the underlying data
- when you use conditional formatting to highlight cells in a worksheet, the purpose of
the formatting is not always immediately apparent. to ensure that everyone knows why
certain cells are highlighted, you should document the meaning of the format.
set print area - Correct Answer ✔✔ - solid lines indicate manual page breaks
- dotted lines indicate automatic page breaks
where to place constants - Correct Answer ✔✔ - constants can be placed in an Excel
formula or in a worksheet cell that is referenced by the formula.
placing constants in separate cells - Correct Answer ✔✔ - helps users better
understand the worksheet because no values are hidden within the formulas.
- you can add explanatory text next to each constant to document how it is being used
in the formula.
placing constants in a formula - Correct Answer ✔✔ prevents users from inadvertently
changing the value of a constant and altering the formula result.
rounding data values - Correct Answer ✔✔ - ROUND (number, Num_digits)
- ROUNDDOWN (number, Num_digits)
- ROUNDUP (number, Num_digits)
calculating minimums and maximums - Correct Answer ✔✔ - the MIN and MAX
functions return the smallest and largest values from a specified set of numbers
- MIN (number1, [number2], ...)
- MAX (number1, [number2], ...)
measures of central tendency - Correct Answer ✔✔ mean, median, mode
#DIV/0! - Correct Answer ✔✔ the formula or function contains a number divided by 0
& VALID CORRECT ANSWERS
Formula - Correct Answer ✔✔ - an expression that returns a value
- ex: A1+A2+A3+A4+A5
Function - Correct Answer ✔✔ - a named operations that replaces the arithmetic
expression in a formula
- =SUM(A1:A5)
Syntax - Correct Answer ✔✔ - a set of rules which specifies how a function should be
written FUNCTION
- (arg1, arg2, [arg3], [arg4],...)
Argument - Correct Answer ✔✔ - information the function uses to calculate an answer
AutoSum - Correct Answer ✔✔ - offers a fast and convenient way to enter commonly
used functions
SUM - Correct Answer ✔✔ sum of values in specified range
AVERAGE - Correct Answer ✔✔ average value in specified range
COUNT - Correct Answer ✔✔ - total count of numeric values in the specified range
- COUNT (value1, [value2], [value3], [value4],...)
MAX - Correct Answer ✔✔ maximum value in the specified range
MIN - Correct Answer ✔✔ minimum value in the specified range
COUNTA - Correct Answer ✔✔ - counts the number of cells in a range that are not
empty
- COUNTA (value1, [value2], [value3], [value4],...)
theme font - Correct Answer ✔✔ a font associated with a particular;ar theme and used
for headings and body text; theme fonts change automatically when the theme is
changed
standard font - Correct Answer ✔✔ a font that retains its appearance no matter what
theme is used with the workbook
serif fonts - Correct Answer ✔✔ fonts that have short decorative lines at the upper and
lower ends of their characters
, sans serif fonts - Correct Answer ✔✔ font that does not include short decorative lines at
the upper and lower ends of their characters
percent change formula - Correct Answer ✔✔ (current year value - previous year
value)/ previous year value
transposed pasted range - Correct Answer ✔✔ Put into a different place or order when
pasted into a different place
highlighting cells with conditional formats - Correct Answer ✔✔ - you can modify any
conditional formatting rule to change what is being formatted, as well as change what
formatting is applied
- you can remove a conditional format at any time without affecting the underlying data
- when you use conditional formatting to highlight cells in a worksheet, the purpose of
the formatting is not always immediately apparent. to ensure that everyone knows why
certain cells are highlighted, you should document the meaning of the format.
set print area - Correct Answer ✔✔ - solid lines indicate manual page breaks
- dotted lines indicate automatic page breaks
where to place constants - Correct Answer ✔✔ - constants can be placed in an Excel
formula or in a worksheet cell that is referenced by the formula.
placing constants in separate cells - Correct Answer ✔✔ - helps users better
understand the worksheet because no values are hidden within the formulas.
- you can add explanatory text next to each constant to document how it is being used
in the formula.
placing constants in a formula - Correct Answer ✔✔ prevents users from inadvertently
changing the value of a constant and altering the formula result.
rounding data values - Correct Answer ✔✔ - ROUND (number, Num_digits)
- ROUNDDOWN (number, Num_digits)
- ROUNDUP (number, Num_digits)
calculating minimums and maximums - Correct Answer ✔✔ - the MIN and MAX
functions return the smallest and largest values from a specified set of numbers
- MIN (number1, [number2], ...)
- MAX (number1, [number2], ...)
measures of central tendency - Correct Answer ✔✔ mean, median, mode
#DIV/0! - Correct Answer ✔✔ the formula or function contains a number divided by 0
