Excel Competency UPDATED Actual Exam Questions and CORRECT Answers
3 views 0 purchase
Course
Excel Competency
Institution
Excel Competency
Excel Competency UPDATED Actual Exam
Questions and CORRECT Answers
b - CORRECT ANSWER- ABC is a:
a.Cell reference
b.Column designation
c.Range reference
d.Row name
b - CORRECT ANSWER- The fastest way to highlight top 10 values in a range is by:
a) Adding a pie chart next to the data.
b) A...
Excel Competency UPDATED Actual Exam
Questions and CORRECT Answers
b - CORRECT ANSWER✔✔- ABC is a:
a.Cell reference
b.Column designation
c.Range reference
d.Row name
b - CORRECT ANSWER✔✔- The fastest way to highlight top 10 values in a range is by:
a) Adding a pie chart next to the data.
b) Applying conditional formatting.
c) Quickly selecting the values and changing the border colors by hand.
d) This will always be a lengthy process, especially if you have a large dataset
d - CORRECT ANSWER✔✔- Excel has _______ rows:
a.2,000
b.16,384
c.33,000
d.1,048,576
,d - CORRECT ANSWER✔✔- What does it mean when Excel displays ### in a cell that is
supposed to have a numerical value?
a.It is a pattern it wants you to reproduce
b.It is an error message
c.It is not a prime number
d.The column is too narrow to display the value
a - CORRECT ANSWER✔✔- What is the shortcut/key combination to print work?
a.CTRL+P
b.CTRL+S
c.CTRL+U
d.CTRL+V
b - CORRECT ANSWER✔✔- Returns the number of cell locations in a range that contain a
text or numeric character.
a.COUNT
b.COUNTA
c.COUNTIF
d.COUNTAS
, - CORRECT ANSWER✔✔- In VLOOKUP, "lookup_value" is:
a.the array of matches that are available based on your lookup value.
b.the column that includes the information that we are looking up.
c.the range that contains the values you want returned by the function.
d.the piece of data you know and are trying to match with something you don't know.
True - CORRECT ANSWER✔✔- T/F: When you create a table, if your data does not
contain column headers, Excel adds headers with default names
d - CORRECT ANSWER✔✔- In Excel, a collection of similar data can be structured in a(n)
____ of rows and columns.
A. index
B. glossary
C. list
D. range
b - CORRECT ANSWER✔✔- Nima wants to create a hyperlink to a location in her current
workbook. She clicks the Hyperlink button in the Links group on the Insert tab. What option
should she select from the Link to list?
A. Existing File
B. Place in This Document
C. Create New Document
D. E-mail Address
d - CORRECT ANSWER✔✔- Like cell ____, a worksheet group can contain adjacent or
nonadjacent sheets.
A. controls
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.
