Tentamen (uitwerkingen)
Excel IKM test questions with correct answers.
- Vak
- Instelling
Excel IKM test questions with correct answers.
[Meer zien]Voorbeeld 2 van de 12 pagina's
Voorbeeld 2 van de 12 pagina's
In winkelwagen
In winkelwagen
gesponsord bericht van onze partner
Verkoper
Volgen
EvaTee
Ontvangen beoordelingen
Voorbeeld van de inhoud
Excel IKM test questions with correctanswers.
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
, Excel IKM test questions with correct
answers.
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.
What is Excel Pivot Chart and when should you use it? - 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? - 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? - 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? -
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? - 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? -
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? - 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
Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:
Bewezen kwaliteit door reviews
Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!
In een paar klikken geregeld
Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.
Direct to-the-point
Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper EvaTee. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €13,73. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 68175 samenvattingen verkocht
Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen