CIS 105 Midterm study guide
=Average Correct Answer calculates the arithmetic mean or
average of the values contained in two or more cells
=DAVERAGE Correct Answer Averages the values in a field
(column) of records in a list or database that match conditions
you specify.
=DCOUNT Correct Answer Table range is the range of cells
included in the count, field name specifies the field to be
counted, and criteria is the condition to be met. Enter the criteria
range by selecting the field name with the desired value in the
cell below.
=DMIN Correct Answer Returns the smallest number in a
field (column) of records in a list or database that matches
conditions that you specify.
=DSUM Correct Answer function used to total table values
that meet specified criteria
=If Correct Answer evaluates a condition and returns one
value if the condition is true and another value if the condition is
false
=Max Correct Answer displays the highest value in a range
=Min Correct Answer displays the lowest value in a range
, =PMT Correct Answer calculates the periodic payment for a
loan with a fixed interest rate and fixed term
=SUM Correct Answer calculates the total of values
contained in two or more cells
=Vlookup Correct Answer looks up a value in a vertical
lookup table and returns a related result from the lookup table
absolute cell referance Correct Answer indicates a cell's
specific location; does not change when the formula is copied
application software Correct Answer Application software is
computer software designed to help the user to perform specific
tasks.
Application Software Examples Correct Answer Productivity
sw, gaming sw, business sw, drawing sw, education sw
Autosum Correct Answer
bar chart Correct Answer compares values across categories
using horiztontal bars
BIOS Correct Answer Basic Input Output System- identify,
test and initialize components of the system. then points the way
to the os so it can load up and take over
The BIOS program controls the startup process and loads the
operating system into memory. The BIOS is an example of
firmware
=Average Correct Answer calculates the arithmetic mean or
average of the values contained in two or more cells
=DAVERAGE Correct Answer Averages the values in a field
(column) of records in a list or database that match conditions
you specify.
=DCOUNT Correct Answer Table range is the range of cells
included in the count, field name specifies the field to be
counted, and criteria is the condition to be met. Enter the criteria
range by selecting the field name with the desired value in the
cell below.
=DMIN Correct Answer Returns the smallest number in a
field (column) of records in a list or database that matches
conditions that you specify.
=DSUM Correct Answer function used to total table values
that meet specified criteria
=If Correct Answer evaluates a condition and returns one
value if the condition is true and another value if the condition is
false
=Max Correct Answer displays the highest value in a range
=Min Correct Answer displays the lowest value in a range
, =PMT Correct Answer calculates the periodic payment for a
loan with a fixed interest rate and fixed term
=SUM Correct Answer calculates the total of values
contained in two or more cells
=Vlookup Correct Answer looks up a value in a vertical
lookup table and returns a related result from the lookup table
absolute cell referance Correct Answer indicates a cell's
specific location; does not change when the formula is copied
application software Correct Answer Application software is
computer software designed to help the user to perform specific
tasks.
Application Software Examples Correct Answer Productivity
sw, gaming sw, business sw, drawing sw, education sw
Autosum Correct Answer
bar chart Correct Answer compares values across categories
using horiztontal bars
BIOS Correct Answer Basic Input Output System- identify,
test and initialize components of the system. then points the way
to the os so it can load up and take over
The BIOS program controls the startup process and loads the
operating system into memory. The BIOS is an example of
firmware
