Excel IKM Test: Accurate Answers To All Questions
Determine what is the correct name for the areas, highlighted in red in the
image 1?
a) These are the Excel Formula Bar addresses.
b) These are the Excel column and row labels.
c) These are the Excel Ribbon function groups.
d) These are Excel Grid headers.
e) All the above options are incorrect. Correct Answer - b
What is the correct name of the area outlined in yellow in the image 2?
a) Excel formula Bar
b) Excel Cell Address Bar
c) Excel Address Bar
d) Excel Column and Row Address
e) Excel Name Box Correct Answer - e
What is the difference between Microsoft Excel 2019 (Office 365) and Excel
Online Correct Answer - Microsoft Excel 2019 is an electronic
spreadsheet program installed on your computer. When
you buy Excel 2019 you pay one time fee and you own the software.
Excel 365 comes as part of Office 365 subscription.
What are the key components of Excel User Interface? Correct Answer -
Excel uses Ribbon User Interface. It consist of Ribbon Tabs, Groups and Quick
Access Toolbar
What are Excel Tables and when you might consider using them? Correct
Answer - Excel tables have been designed to make managing and
analyzing a group of related data easier.
What is Excel Range. And how is Excel Range different from Excel Tables?
Correct Answer - Excel Range is a group or block of cell references that are
entered to perform calculations or as an
argument for a function.
Excel Table is a defined grid of cells for data and formulas that automatically
expands as you add to it
and also automatically has the capacity to sort and filter.
,What is VLOOKUP formula Syntax and Typical Usage? Correct Answer -
VLOOKUP function finds items in a table or range by row. VLOOKUP is
designed to retrieve data from a
specific column in table.
What is XLOOKUP formula? Correct Answer - XLOOKUP function
performs lookups in vertical or horizontal ranges. It is a more robust and
flexible
successor than traditional VLOOKUP
What are the tools available to analyze Transactional Data in Excel? Correct
Answer - Transactions could be analyzed manually in Excel Ranges. Excel
PowerQuery is designed to import and process transactional data, Excel
Tables are designed to
store and Excel Pivot Tables and Pivot Charts are designed to analyze and
report on transactional data.
What is Excel PowerQuery and how you can use it? Correct Answer - is
the technology that enables business users to access data stored in various
sources and allows to import and transform the data without writing code.
Ribbon - > Data->"Get & Transform" section.
If you know that particular functionality exists in Excel but you are not sure
on which Ribbon tab it is available how can you use it quickly? Correct
Answer - You can use search functionlity on Excel Ribbon.
What is a Pivot Table and when should you use them in Excel? Correct
Answer - A pivot table is a data summarization tool that is used to analyze
and report the data. Pivot tables are used to summarize, sort, reorganize,
group, count, total or average data stored in a database.
What is Excel Pivot Chart and when should you use it? Correct Answer -
A Pivot Chart is a graphical representation of the data from Pivot Table. A
Pivot Chart is especially useful for user when you are trying to analyze and
display results from large dataset.
What is Excel Dashboard and when should you consider using it? Correct
Answer - An Excel dashboard is designed to help business leaders in
, tracking Key Performance Indicators and metrics to enable data driven
decision making based on the data presented in dashboard.
What is the function of Format Painter in Excel? Correct Answer - it is
feature of Excel and as the name suggest it formats. It copies the format from
area to other.
What is the difference between absolute and relative reference in Microsoft
Excel? Correct Answer - Using relative references we can apply the same
formula to a lot of cells without copying and changing the formula. We use
Absolute reference when want to drag the formula but keep a row or column
or even both of them consistent.
What is the Excel VBA and when do you use it? Correct Answer - Visual
Basic for Applications is the programming language (macros) of the Excel and
it can be utilized for a variety of use.
How can you protect Workbook in Excel and why you might consider doing it?
Correct Answer - We can use the protect workbook option to prevent
users from viewing hidden worksheets, adding, moving, deleting, or hiding
worksheets, and renaming worksheets.
What is SmartArt in Excel and when would you use it? Correct Answer -
A smart art is a graphic representation of information which you use to add
more flare to your spreadsheet as it increases the visual appeal for the
document
What are the tools in Excel to Remove data duplicates? Correct Answer -
Remove Duplicates tool, Pivot Table, Filter, Conditional Formatting, Power
Query
How would you use Excel Freeze Panes concept and why you might consider
doing it? Correct Answer - To navigate around a data and see the
headers of the section all the time
How can you duplicate Excel Worksheet? Correct Answer - right click on
worksheet > select Move or Copy
Determine what is the correct name for the areas, highlighted in red in the
image 1?
a) These are the Excel Formula Bar addresses.
b) These are the Excel column and row labels.
c) These are the Excel Ribbon function groups.
d) These are Excel Grid headers.
e) All the above options are incorrect. Correct Answer - b
What is the correct name of the area outlined in yellow in the image 2?
a) Excel formula Bar
b) Excel Cell Address Bar
c) Excel Address Bar
d) Excel Column and Row Address
e) Excel Name Box Correct Answer - e
What is the difference between Microsoft Excel 2019 (Office 365) and Excel
Online Correct Answer - Microsoft Excel 2019 is an electronic
spreadsheet program installed on your computer. When
you buy Excel 2019 you pay one time fee and you own the software.
Excel 365 comes as part of Office 365 subscription.
What are the key components of Excel User Interface? Correct Answer -
Excel uses Ribbon User Interface. It consist of Ribbon Tabs, Groups and Quick
Access Toolbar
What are Excel Tables and when you might consider using them? Correct
Answer - Excel tables have been designed to make managing and
analyzing a group of related data easier.
What is Excel Range. And how is Excel Range different from Excel Tables?
Correct Answer - Excel Range is a group or block of cell references that are
entered to perform calculations or as an
argument for a function.
Excel Table is a defined grid of cells for data and formulas that automatically
expands as you add to it
and also automatically has the capacity to sort and filter.
,What is VLOOKUP formula Syntax and Typical Usage? Correct Answer -
VLOOKUP function finds items in a table or range by row. VLOOKUP is
designed to retrieve data from a
specific column in table.
What is XLOOKUP formula? Correct Answer - XLOOKUP function
performs lookups in vertical or horizontal ranges. It is a more robust and
flexible
successor than traditional VLOOKUP
What are the tools available to analyze Transactional Data in Excel? Correct
Answer - Transactions could be analyzed manually in Excel Ranges. Excel
PowerQuery is designed to import and process transactional data, Excel
Tables are designed to
store and Excel Pivot Tables and Pivot Charts are designed to analyze and
report on transactional data.
What is Excel PowerQuery and how you can use it? Correct Answer - is
the technology that enables business users to access data stored in various
sources and allows to import and transform the data without writing code.
Ribbon - > Data->"Get & Transform" section.
If you know that particular functionality exists in Excel but you are not sure
on which Ribbon tab it is available how can you use it quickly? Correct
Answer - You can use search functionlity on Excel Ribbon.
What is a Pivot Table and when should you use them in Excel? Correct
Answer - A pivot table is a data summarization tool that is used to analyze
and report the data. Pivot tables are used to summarize, sort, reorganize,
group, count, total or average data stored in a database.
What is Excel Pivot Chart and when should you use it? Correct Answer -
A Pivot Chart is a graphical representation of the data from Pivot Table. A
Pivot Chart is especially useful for user when you are trying to analyze and
display results from large dataset.
What is Excel Dashboard and when should you consider using it? Correct
Answer - An Excel dashboard is designed to help business leaders in
, tracking Key Performance Indicators and metrics to enable data driven
decision making based on the data presented in dashboard.
What is the function of Format Painter in Excel? Correct Answer - it is
feature of Excel and as the name suggest it formats. It copies the format from
area to other.
What is the difference between absolute and relative reference in Microsoft
Excel? Correct Answer - Using relative references we can apply the same
formula to a lot of cells without copying and changing the formula. We use
Absolute reference when want to drag the formula but keep a row or column
or even both of them consistent.
What is the Excel VBA and when do you use it? Correct Answer - Visual
Basic for Applications is the programming language (macros) of the Excel and
it can be utilized for a variety of use.
How can you protect Workbook in Excel and why you might consider doing it?
Correct Answer - We can use the protect workbook option to prevent
users from viewing hidden worksheets, adding, moving, deleting, or hiding
worksheets, and renaming worksheets.
What is SmartArt in Excel and when would you use it? Correct Answer -
A smart art is a graphic representation of information which you use to add
more flare to your spreadsheet as it increases the visual appeal for the
document
What are the tools in Excel to Remove data duplicates? Correct Answer -
Remove Duplicates tool, Pivot Table, Filter, Conditional Formatting, Power
Query
How would you use Excel Freeze Panes concept and why you might consider
doing it? Correct Answer - To navigate around a data and see the
headers of the section all the time
How can you duplicate Excel Worksheet? Correct Answer - right click on
worksheet > select Move or Copy
