Excel Competency Final UPDATED Actual Exam Questions and CORRECT Answers
8 views 0 purchase
Course
Excel Competency
Institution
Excel Competency
Excel Competency Final UPDATED Actual
Exam Questions and CORRECT Answers
Excel provides a variety of tools for designing a spreadsheet, which is referred to as a
worksheet in the Excel application. - CORRECT ANSWER- True
The Accounting Number Style displays values with commas and two decimal ...
Excel Competency Final UPDATED Actual
Exam Questions and CORRECT Answers
Excel provides a variety of tools for designing a spreadsheet, which is referred to as a
worksheet in the Excel application. - CORRECT ANSWER✔✔- True
The Accounting Number Style displays values with commas and two decimal places, but no
dollar signs. - CORRECT ANSWER✔✔- False
A function is always structured beginning with the function address and an opening
parenthesis mark. - CORRECT ANSWER✔✔- False
The function inputs are referred to as arguments. - CORRECT ANSWER✔✔- True
To use a "general" formula over and over again but with a different set of numbers, use a
feature called absolute cell referencing. - CORRECT ANSWER✔✔- False
The error message ###### means that there is ____. - CORRECT ANSWER✔✔- insufficient
width in the cell to display data, or negative date/time
The ____ function adds a list of values and/or cell ranges. - CORRECT ANSWER✔✔- Sum
Each function has its own ____, which specifies the function name and order of the
arguments. - CORRECT ANSWER✔✔- syntax
$B$1 is an example of a(n) ____ reference. - CORRECT ANSWER✔✔- absolute
B1 is an example of a(n) ____ reference. - CORRECT ANSWER✔✔- relative
Microsoft Excel charts provide a visual representation of quantitative information, giving the
viewer an overall picture of a set of data. - CORRECT ANSWER✔✔- True
, In a line chart, values are indicated by the filled areas below the lines. - CORRECT
ANSWER✔✔- False
The Alternative Data task pane, which is available from the shortcut menu for a selected
chart, provides options for modifying the values used to generate a chart. - CORRECT
ANSWER✔✔- False
You must make changes to the content of data labels using buttons in the Format Data Labels
task pane. - CORRECT ANSWER✔✔- True
Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine
many smaller segments of a pie chart into a separate smaller chart. - CORRECT
ANSWER✔✔- False
The ____ is the vertical axis where data values are plotted. - CORRECT ANSWER✔✔- y-
axis
The purpose of formatting is to make a chart ____. - CORRECT ANSWER✔✔- easier for the
viewer to understand
Stacked charts do a good job of illustrating the ____ effects of data in categories. -
CORRECT ANSWER✔✔- cumulative
The ____ option of splitting a pie data series into a second, smaller pie chart allows you to
select a cutoff point by percentage, rather than value, and assign all the percentages below
that point to the second plot. - CORRECT ANSWER✔✔- percentage value
With the ____ sub-type, the data to be plotted must be placed by column in this order: high
stock value for the day, low stock value, and, finally, closing stock value. - CORRECT
ANSWER✔✔- High-Low-Close
If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter
the following formula: =3>5. - CORRECT ANSWER✔✔- True
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
