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
