Updated! Excel Associate 2019
Certification Exam Question and
Answers [100% Correct] 2024/2025
Latest Version!!
How do you import a comma delimited file into a new worksheet and add it to the data model in Excel?
First, click the Data tab, then select "From Text/CSV" in the Get & Transfor...
Updated! Excel Associate 2019
Certification Exam Question and
Answers [100% Correct] 2024/2025
Latest Version!!
How do you import a comma delimited file into a new worksheet and add it to the data model in Excel?
First, click the Data tab, then select "From Text/CSV" in the Get & Transform group. Browse to the
file location, select the file, and click Import. In the pop-up, ensure the delimiter is set to Comma, then
choose Load To, check "New worksheet," and select "Add this data to the Data Model." Click OK.
What is the procedure for clearing the formatting in a specific cell range on the Rental Rates worksheet?
Select the cell range (A4:D4), then go to the Home tab, click Clear in the Editing group, and
choose Clear Formats.
How can you rename a table in Excel from Table1 to Rates?
Open the Name Manager in the Formulas tab, select Table1, click Edit, change the name to Rates,
and click OK. Close the Name Manager.
How do you change the page orientation of a worksheet to landscape in Excel?
In the Page Layout tab, under the Page Setup group, click the Orientation dropdown and select
Landscape.
What steps should you take to check for compatibility issues in a workbook and copy the results to a new
sheet?
Go to the File tab, click "Check for Issues," select "Check Compatibility," and in the Compatibility
Checker pop-up, click "Copy to New Sheet."
How do you merge cells A1:E1 in the Fishing worksheet without changing the alignment?
Select the cell range A1:E1, go to the Home tab, and in the Alignment group, click the Merge &
Center dropdown and select Merge Across.
1
,What is the process for linking cell B13 on the Tents worksheet to cell A4 on the Fishing worksheet?
Select cell B13 on the Tents worksheet, go to the Insert tab, click Link, choose "Place in This
Document," type A4 in the reference field, select the Fishing worksheet, and click OK.
How do you apply conditional formatting with the 3 Flags Icon Set to a range of cells on the Tents
worksheet?
Select cells C4:C11 on the Tents worksheet, go to the Home tab, click Conditional Formatting,
choose Icon Sets, and select 3 Flags.
What steps should be followed to expand a chart’s data range to include an additional entry on the Tents
worksheet?
Click on the chart, go to the Chart Design tab, click Select Data, and then select the additional
data (e.g., B7:C7) while holding down the Ctrl key. Click OK to update the chart.
How do you replace all occurrences of "Choco" with "Chocolate" across the entire workbook?
Go to the Home tab, click Find & Select, choose Replace. In the Find and Replace window, type
"Choco" in the "Find what" box and "Chocolate" in the "Replace with" box. Click Options, set the
"Within" field to Workbook, and click Replace All. Then, click Close.
What is the default file extension when saving a workbook in Excel 2019?
.xlsx
Which of the following is the correct way to freeze panes in Excel?
Click on the View tab, then click Freeze Panes, and select either "Freeze Panes," "Freeze Top Row," or
"Freeze First Column."
Click on the View tab, then click Freeze Panes, and select either "Freeze Panes," "Freeze Top
Row," or "Freeze First Column."
Which function would you use to find the average of a range of numbers in Excel?
2
, AVERAGE
In Excel, how can you quickly add a column of numbers?
Click on the cell at the bottom of the column, then press Alt + =.
Click on the cell at the bottom of the column, then press Alt + =.
What is the purpose of the COUNTIF function in Excel?
It counts the number of cells that meet a specific condition.
It counts the number of cells that meet a specific condition.
How do you remove duplicate values from a range of cells in Excel?
Go to the Data tab, click on "Remove Duplicates," and select the columns to check for duplicates.
Go to the Data tab, click on "Remove Duplicates," and select the columns to check for duplicates.
What is the shortcut key to create a new workbook in Excel?
Ctrl + N
How can you change the format of a number to currency in Excel?
Select the cell or range, then press Ctrl + Shift + 4 or use the Number Format dropdown in the Home tab.
Select the cell or range, then press Ctrl + Shift + 4 or use the Number Format dropdown in the
Home tab.
Which of the following functions would you use to return the current date in Excel?
=TODAY()
What does the VLOOKUP function do in Excel?
3
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
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 StellarGrades. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €8,97. Je zit daarna nergens aan vast.
