• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 3 out of 21 pages
Exam (elaborations)

Excel IKM Test Study Questions and Answers 2025

Document preview thumbnail
Preview 3 out of 21 pages

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.

Content preview

Excel IKM test



Excel IKM Test Study Questions and
Answers 2025
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




Excel IKM test

,Excel IKM test


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


Excel IKM test

, Excel IKM test


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.




Excel IKM test

Document information

Uploaded on
May 23, 2025
Number of pages
21
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
CA$23.63

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
PossibleA
3.9
(154)
Sold
1092
Followers
651
Items
14254
Last sold
1 day ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions