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