100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Excel Assessment UPDATED Actual Exam Questions and CORRECT Answers $7.99   Add to cart

Exam (elaborations)

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...

[Show more]

Preview 2 out of 9  pages

  • September 14, 2024
  • 9
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Excel Assessment
  • Excel Assessment
avatar-seller
MGRADES
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

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 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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

80364 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