Excel IKM test questions & answers
2025/2026
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. - ANSWERSb
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 - ANSWERSe
What is the difference between Microsoft Excel 2019 (Office 365) and Excel Online -
ANSWERSMicrosoft 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? - ANSWERSExcel 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? - ANSWERSExcel 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? - ANSWERSExcel
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? - ANSWERSVLOOKUP 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? - ANSWERSXLOOKUP 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? - ANSWERSTransactions
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? - ANSWERSis 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? - ANSWERSYou can use search functionlity on Excel
Ribbon.
What is a Pivot Table and when should you use them in Excel? - ANSWERSA 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? - ANSWERSA 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? - ANSWERSAn 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? - ANSWERSit 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? -
ANSWERSUsing 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? - ANSWERSVisual 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? - ANSWERSWe
can use the protect workbook option to prevent users from viewing hidden worksheets, adding,
moving, deleting, or hiding worksheets, and renaming worksheets.
2025/2026
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. - ANSWERSb
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 - ANSWERSe
What is the difference between Microsoft Excel 2019 (Office 365) and Excel Online -
ANSWERSMicrosoft 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? - ANSWERSExcel 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? - ANSWERSExcel 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? - ANSWERSExcel
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? - ANSWERSVLOOKUP 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? - ANSWERSXLOOKUP 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? - ANSWERSTransactions
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? - ANSWERSis 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? - ANSWERSYou can use search functionlity on Excel
Ribbon.
What is a Pivot Table and when should you use them in Excel? - ANSWERSA 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? - ANSWERSA 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? - ANSWERSAn 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? - ANSWERSit 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? -
ANSWERSUsing 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? - ANSWERSVisual 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? - ANSWERSWe
can use the protect workbook option to prevent users from viewing hidden worksheets, adding,
moving, deleting, or hiding worksheets, and renaming worksheets.
