Excel Assessment UPDATED Actual Exam Questions and CORRECT Answers
8 views 0 purchase
Course
Excel Assessment
Institution
Excel Assessment
Excel Assessment UPDATED Actual Exam
Questions and CORRECT Answers
Some of your data in Column C is displaying as hashtags (#) because the column is too
narrow. How can you widen Column C just enough to show all the data? - CORRECT
ANSWER- Double-click the vertical boundary between columns C...
Excel Assessment UPDATED Actual Exam
Questions and CORRECT Answers
Some of your data in Column C is displaying as hashtags (#) because the column is too
narrow. How can you widen Column C just enough to show all the data? - CORRECT
ANSWER✔✔- Double-click the vertical boundary between columns C and D
Which two functions check for the presence of numerical or nonnumerical characters in
cells? - CORRECT ANSWER✔✔- ISNUMBER and ISTEXT
If you drag the fill handle (lower-right corner) of cell A2 downward into cells A3, A4, A5,
what contents will appear in those cells? - CORRECT ANSWER✔✔- Feb, Mar, Apr
If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =
PROPER(A3) return? - CORRECT ANSWER✔✔- The Death Of Chivalry
In the worksheet below, you want to use Data > Subtotal to show a subtotal value per sport.
What must you do BEFORE applying the Subtotal function? - CORRECT ANSWER✔✔-
Sort by the data in Column D
When editing a cell, what do you press to cycle between relative, mixed and absolute cell
references? - CORRECT ANSWER✔✔- the F4 (Windows) or Command +T (Mac)
You need to add a line chart showing a sales trends over the last 12 months and you have only
a little space to work with. How can you convey the required information within a single
cell? - CORRECT ANSWER✔✔- Add a sparkline, a graphic that summarizes data visually
within a single worksheet cell
What is the best way to activate the Excel Help system? - CORRECT ANSWER✔✔- Press
F1 or click the Help tab in the ribbon
Which format will display the value 27,500,000 as 27.5? - CORRECT ANSWER✔✔- ###.0,,
, When using Goal Seek, you can find a target result by varying __ at most. - CORRECT
ANSWER✔✔- one input
In the image below, which option(s) can you select so that the appropriate field headers
appear in cells A4 and B3 instead of the terms Row Labels and Column Labels, respectively?
- CORRECT ANSWER✔✔- Show in Tabular Form or Show in Outline Form
A cell contains the value 7.877 and you want it to display as 7.9. How can you accomplish
this? - CORRECT ANSWER✔✔- Click the Decrease Decimal button twice. <-
Which formula is NOT equivalent to all of the others? - CORRECT ANSWER✔✔-
=SUM(A3,A6)
Which custom format will make the cells in column A appear like the corresponding cells in
column B? - CORRECT ANSWER✔✔- MMMM-YYYY
Which function returns a reference to a cell ( or cell range) that is specified distance from a
base cell? - CORRECT ANSWER✔✔- INDEX
You're working with columns whose width and font-size should not be changed. Yet the
columns are too narrow to display all the text in each cell. What tool should you use to solve
the problem? - CORRECT ANSWER✔✔- Wrap Text
Of the four chart types listed, which works best for summarizing time-based data? -
CORRECT ANSWER✔✔- Line chart
The AutoSum formulas in the range C9:F9 below return unexpected values. Why is this? -
CORRECT ANSWER✔✔- The AutoSum formulas include the year at the top of each column
in the calculation
The text filter in column A is designed to display only those rows where column A entry has a
particular attribute. What is this attribute? - CORRECT ANSWER✔✔- The second character
in the cell is 9
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 $7.99. You're not tied to anything after your purchase.