EXCEL IKM TEST | 2025-2026 LATEST UPDATED|100 ACTUAL EXAM
COMPLETE QUESTIONS AND ANSWERS | 100% RATED CORRECT |
100% VERFIED | ALREADY GRADED A+
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. - (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 - (answer)e
,What is the difference between Microsoft Excel 2019 (Office 365) and Excel
Online - (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? - (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? - (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? -
(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? - (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? - (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? -
(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? - (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? - (answer)You can use
search functionlity on Excel Ribbon.
What is a Pivot Table and when should you use them in Excel? - (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.
COMPLETE QUESTIONS AND ANSWERS | 100% RATED CORRECT |
100% VERFIED | ALREADY GRADED A+
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. - (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 - (answer)e
,What is the difference between Microsoft Excel 2019 (Office 365) and Excel
Online - (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? - (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? - (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? -
(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? - (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? - (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? -
(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? - (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? - (answer)You can use
search functionlity on Excel Ribbon.
What is a Pivot Table and when should you use them in Excel? - (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.
