100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
7-8 excel Questions with 100% Correct Answers Graded A+ | Verified | Latest Update 2024, Actual Complete Solutions ,Garanteed Distinction $7.99   Add to cart

Exam (elaborations)

7-8 excel Questions with 100% Correct Answers Graded A+ | Verified | Latest Update 2024, Actual Complete Solutions ,Garanteed Distinction

 7 views  0 purchase
  • Course
  • CompTIA
  • Institution
  • CompTIA

7-8 excel Questions with 100% Correct Answers Graded A+ | Verified | Latest Update 2024, Actual Complete Solutions ,Garanteed Distinction

Preview 2 out of 8  pages

  • August 2, 2024
  • 8
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • 7 8 excel
  • CompTIA
  • CompTIA
avatar-seller
AnswersCOM
100%
7-8
excel
________
determines
how
two
sets
of
data
from
a
sample
vary
simultaneously.
-
✔✔
COVARIANCE.S
________
is
a
measure
of
how
two
set
of
data
vary
simultaneously
and
is
calculated
by
taking
the
average
of
each
product
of
the
deviation
of
a
data
point.
-
✔✔
Covariance
________
is
a
measure
of
how
two
sets
of
data
vary
simultaneously.
-
✔✔
Covariance
________
returns
the
forecasted
values
of
a
target
date
using
exponential
smoothing.
-
✔✔
FORECAST.ETS
=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black")
-
✔✔
false
4)
If
there
are
5
possible
outcomes,
how
many
logical
tests
are
required?
-
✔✔
4
A
college
admissions
office
might
use
which
of
the
following
functions
to
offer
scholarships
to
incoming
student
who
are
in
the
top
10%
of
their
high
school
classes?
-
✔✔
PERCENTILE.INC
A
Forecast
worksheet
is
a
business
intelligence
tool
that
projects
trends
based
on
historical
data.
-
✔✔
True
A
histogram
is
a
pie
chart
created
by
the
Analysis
ToolPak.
-
✔✔
false
A
loan
amortization
table
is
a
schedule
that
calculates
the
interest
per
payment
period,
principal
repayment
for
each
payment,
and
remaining
balance
after
each
payment
is
made.
-
✔✔
True
A
MATCH
function
returns
the
value
of
a
given
position.
-
✔✔
false
A
NOT
function
reverses
the
truth
of
a
logical
test.
-
✔✔
true
A
quartile
is
a
value
used
to
divide
a
range
into
five
equal
groups.
-
✔✔
false
A
Truth
Table
is
a
matrix
that
provides
true
or
false
for
every
possible
combination
for
an
OR,
NOT,
or
AND
criteria
combination.
-
✔✔
true
A
Truth
Table
is
a
matrix
that
provides
true
or
false
for
every
possible
combination
for
an
OR,
NOT,
or
AND
criteria
combination.
-
✔✔
True
A(n)
________
is
a
business
intelligence
tool
which
extrapolates
future
values
based
on
current
trends.
-
✔✔
forecast
worksheet
A(n)
________
is
a
dataset
that
contains
a
manageable
subset
of
a
population.
-
✔✔
sample
A(n)
________
is
a
visual
depiction
of
a
population
distribution
created
by
the
Analysis
ToolPak.
-
✔✔
histogram 100%
A(n)
________is
a
matrix
that
provides
the
results
(TRUE
or
FALSE)
for
every
possibility
of
an
AND,
OR,
or
NOT
criteria
combination.
-
✔✔
truth
table
A(n)________
is
a
schedule
that
calculates
the
interest
per
payment
period,
principal,
repayment,
and
remaining
balance.
-
✔✔
loan
amortization
table
Advanced
filtering
will
not
copy
results
to
a
new
location.
-
✔✔
False
An
empty
cell
in
the
criteria
in
an
Advanced
Filter
will
display
no
records.
-
✔✔
false
An
INDEX
function
returns
the
position
of
a
value.
-
✔✔
False
An
INDEX
function
returns
the
position
of
a
value.
-
✔✔
False
An
OR
condition
in
an
advanced
filter
requires
at
least
two
rows
in
the
criteria
range.
-
✔✔
true
An
OR
function
evaluates
to
TRUE
only
if
all
of
the
conditions
are
true.
-
✔✔
False
ANOVA
stands
for
analysis
of
variability.
-
✔✔
false
Correlation
is
a
tool
included
on
the
Analysis
ToolPak.
-
✔✔
True
Covariance
-
✔✔
True
Covariance
has
two
functions
associated
with
it
-
COVARIANCE.P
and
COVARIANCE.S.
-
✔✔
true
Database
functions
do
not
require
a
Criteria
Range.
-
✔✔
False
DSTDEV
calculates
the
standard
deviation
of
a
sample
population
in
a
database
range.
-
✔✔
True
Excel
2016
has
NO
new
functions
in
the
Analysis
ToolPak.
-
✔✔
False
FORECAST.ETS.SEASONALITY
returns
the
projected
quarter
of
the
year
when
a
forecasted
value
will
happen.
-
✔✔
false
If
9/3/2021
is
the
contents
of
B3,
what
would
be
the
result
of
=MONTH(B3)?
-
✔✔
If
9/3/2021
is
the
contents
of
B3,
what
would
be
the
result
of
=MONTH(B3)?
If
you
autofill
the
formula
=RANK.AVG(A1,$A$1:$A$5,0)
from
B1
to
B5,
what
would
the
value
be
in
B5?
-
✔✔
3.5
If
you
need
to
find
out
how
many
days
between
two
dates,
which
function
would
you
use?
-
✔✔
days

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller AnswersCOM. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $7.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

80461 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$7.99
  • (0)
  Add to cart