100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
Excel Exam 1 Questions with 100% Correct Answers Graded A+ | Verified | Latest Update 2024, Actual Complete Solutions ,Garanteed Distinction $7.99   Add to cart
Quickly navigate to
Preview
  2.  
  3. CompTIA
  4.  
  5. CompTIA

Exam (elaborations)

Excel Exam 1 Questions with 100% Correct Answers Graded A+ | Verified | Latest Update 2024, Actual Complete Solutions ,Garanteed Distinction
 8 views  0 purchase
  • Course
  • CompTIA
  • Institution
  • CompTIA

Excel Exam 1 Questions with 100% Correct Answers Graded A+ | Verified | Latest Update 2024, Actual Complete Solutions ,Garanteed Distinction

Preview 2 out of 5  pages

Document information

  • August 2, 2024
  • 5
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • excel exam 1
  • excel exam 1 questions with 100 correct answers g

Written for

  • CompTIA
  • CompTIA

Seller

avatar-seller
AnswersCOM

Reviews received

Content preview

100%
Excel
Exam
1
A
fast
way
to
switch
between
different
worksheets
in
the
same
workbook
using
the
keyboard
is:
-
✔✔
Ctrl
+
PageUp/PageDown
A
formula
may
contain
all
of
the
following,
except:
-
✔✔
Conditional
Formatting
A
SUM
function:
-
✔✔
Includes
SUM
and
SUBTOTAL
functions
in
its
range
All
of
the
following
are
characteristic
of
beautiful
formulas,
except:
-
✔✔
Contain
operators
and
cell
references
only,
no
functions
or
named
ranges
All
of
the
following
are
workbook
organization
ideas,
except
-
✔✔
Pivot
Tables
All
of
the
following
tabs
appear
in
the
Data
Validation
dialog
box,
except:
-
✔✔
Head/Footer
All
of
the
following
will
help
change
a
worksheet
name,
except
-
✔✔
F1
All
of
the
following
will
help
hide
a
worksheet,
except
-
✔✔
Select
the
sheet
and
press
F1
Assume
cell
A1
contains
the
stored
value
of
12,345.67.
Which
function
would
return
12,000.00
-
✔✔
ROUND(A1,0)
Assume
that
you
assigned
the
name
"sales_tax_rate"
to
cell
A1,
and
the
name
"sales_amount"
to
cell
A2.
Cell
A1
has
a
stored
value
of
.08
and
cell
A2
has
a
stored
value
of
100.
Which
formula
would
produce
the
correct
sales
tax
amount
of
8:
-
✔✔
=sales_tax_rate*sales_amount
Beginning
with
Excel
2007,
Microsoft
introduced
a
cell
style
for
input
cells,
named:
-
✔✔
Input
Beginning
with
Excel
version
2007,
what
is
the
maximum
number
of
Conditional
Formatting
rules
allowed?
-
✔✔
7
Besides
other
SUBTOTAL
functions,
what
is
excluded
by
the
function:
SUBTOTAL(9,A1:A100)
-
✔✔
Rows
in
the
range
A1:A100
that
are
hidden
by
a
filter
Conditional
formatting
can
help
with
all
of
the
following
tasks,
except
-
✔✔
Hyperlinks
Efficiency
can
be
gained
by:
-
✔✔
Minimizing
the
number
of
input
cells,
and
maximizing
the
number
of
formula
cells
Excel
is
best
equipped
to
summarize
data
that
is
in
a
flat
format.
Flat
data
is
characterized
by
all
of
the
following,
except
-
✔✔
The
entire
data
set
spans
across
many
columns,
but
only
occupies
a
single
row 100%
Excel
is
useful
for
accountants
because
-
✔✔
It
helps
make
recurring
tasks
more
efficient
Excel
supports
all
of
the
following
function
arguments,
except
-
✔✔
Aserisk
(*)
For
accountants,
why
is
the
SUBTOTAL
function
preferable
to
the
SUM
function
most
of
the
time?
-
✔✔
SUBTOTAL
excludes
other
SUBTOTAL
functions
in
it's
range
Generally,
new
workbooks
contain
three
worksheets,
unless:
-
✔✔
You
change
the
number
of
sheets
included
in
new
workbooks
in
the
Excel
Options
dialog
If
you
select
a
group
of
worksheets,
and
then
enter
"Report"
into
cell
A1
in
the
first
selected
sheet
in
the
group:
-
✔✔
"Report"
will
be
entered
into
cell
A1
of
all
selected
sheets
If
you
select
multiple
sheets
at
the
same
time:
-
✔✔
Any
task
you
perform
is
applied
to
all
of
the
selected
sheets
If
you
wanted
to
format
a
cell
red
when
debits
do
not
equal
credits,
which
Excel
feature
would
be
helpful:
-
✔✔
Conditional
Formatting
If
your
worksheet
has
a
Table
named
tbl_data
with
columns
named
Account,
Date,
and
Amount,
which
function
will
add
up
the
Amount
column:
-
✔✔
=SUM(tbl_data[Amount])
If
your
worksheet
has
a
Table
named
tbl_data,
and
the
Table
has
a
column
named
Amount,
which
of
the
following
refers
to
the
column:
-
✔✔
tbl_data[Amount]
If
your
worksheet
has
a
Table,
and
you
type
a
value
into
a
cell
adjacent
and
under
the
Table
-
✔✔
The
Table
will
automatically
expand
to
include
the
new
value
In
the
Data
Validation
dialog
box,
the
Error
Alert
tab
is
used
to:
-
✔✔
Define
an
optional
error
message
to
be
displayed
when
the
user
attempts
to
enter
invalid
data
In
the
Data
Validation
dialog
box,
the
Input
Message
tab
is
used
to:
-
✔✔
Define
an
optional
message
that
pops
up
when
the
user
selects
the
cell
In
the
Data
Validation
dialog
box,
the
Settings
tab
is
used
to:
-
✔✔
Define
the
rule
for
valid
data
In
the
SUBTOTAL
function's
first
argument,
which
of
the
following
numbers
represents
sum?
-
✔✔
9
In
thinking
about
worksheet
organization,
we
prefer
all
of
the
following
types
of
data,
except:
-
✔✔
Data
that
contains
blank
columns
In
your
worksheet,
you
create
a
skinny
row
and
then
write
a
formula
under
the
skinny
row.
The
key
to
using
the
skinny
row
is
to
make
sure
that
the
formula:
-
✔✔
Includes
the
skinny
row

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)

64438 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