BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
what is a visible cue that shows when a table is made?
Drop down arrows for sorting are visible
calculated fields
formulas added to an existing table
a structured reference contains
column names from an existing table
the order in which filters are applied matters
false
the order in which sorting fields are applied matters
true
conditional formatting
changes the appearance of cells based on user criteria
what is the PMT function used for?
working with LOANS (Principal, Monthly payments, Term).
the two best words for describing pivot tables are ____________.
dynamic and interactive
filtering does what to data?
hides data from view
what should be done before inserting subtotals into a table?
sort the data
on a flowchart, if we want to visualize departmental ownership of a part of a
process and the relationship to other departments overall, we can use...
swim lanes
at what level (generally) of a typical organizational hierarchy deals with the day-
to-day functions of business?
operational
what does the "Long Tail" refer to?
a relative few products or content overshadows most alternative options
why has HBO removed some of its own content?
increase revenue through cost cutting
an example of EXPLICIT knowledge would be..
employee payroll information
an example of IMPLICIT knowledge would be...
business workplace culture
social tagging relies on...
user generated metadata
what is a good description of an excel slicer?
buttons that filter data
web 1.0 relies more on...
one-way communication
web 2.0 relies more on...
bi-directionial communication
GRADED
what is a visible cue that shows when a table is made?
Drop down arrows for sorting are visible
calculated fields
formulas added to an existing table
a structured reference contains
column names from an existing table
the order in which filters are applied matters
false
the order in which sorting fields are applied matters
true
conditional formatting
changes the appearance of cells based on user criteria
what is the PMT function used for?
working with LOANS (Principal, Monthly payments, Term).
the two best words for describing pivot tables are ____________.
dynamic and interactive
filtering does what to data?
hides data from view
what should be done before inserting subtotals into a table?
sort the data
on a flowchart, if we want to visualize departmental ownership of a part of a
process and the relationship to other departments overall, we can use...
swim lanes
at what level (generally) of a typical organizational hierarchy deals with the day-
to-day functions of business?
operational
what does the "Long Tail" refer to?
a relative few products or content overshadows most alternative options
why has HBO removed some of its own content?
increase revenue through cost cutting
an example of EXPLICIT knowledge would be..
employee payroll information
an example of IMPLICIT knowledge would be...
business workplace culture
social tagging relies on...
user generated metadata
what is a good description of an excel slicer?
buttons that filter data
web 1.0 relies more on...
one-way communication
web 2.0 relies more on...
bi-directionial communication
