EXCEL ASSOCIATE CERTIFICATION EXAM UPDATED ACTUAL QUESTIONS AND CORRECT ANSWERS

EXCEL ASSOCIATE CERTIFICATION EXAM UPDATED
ACTUAL QUESTIONS AND CORRECT ANSWERS

Question:
1. What are three ways to create a new workbook in Excel 2019?
Answer:
Using an existing template Using an online template Create a blank workbook from scratch

Question:
2. Users can save a workbook in Excel 2019 using which item?
Answer:
Quick Access Toolbar

Question:
3. Which data format in Excel 2019 treats text as text and numbers as numbers?
Answer:
General

Question:
4. Which are ways to add worksheets to a workbook in Excel 2019?
Answer:
1. Right-click an existing sheet, click insert, and click the OK button
2. Click the plus sign button near the existing worksheets
3. Open the Home tab, click the Insert drop-down arrow, and click Insert Sheet

Question:
5. Which are two ways to copy a worksheet in Excel 2019?
Answer:
1. While holding the Ctrl key on the keyboard, click and drag the worksheet to a new location
2. Right-click a worksheet tab and click Move or Copy

Question:
6. The Find and Select feature is located in which tab on the ribbon?
Answer:
the Home tab

Question:
7. Which feature on the Excel 2019 ribbon is used to navigate to the last cell of a worksheet?
Answer:
Go To Special

Question:
8. The Format drop-down menu is found under which group on the ribbon?
Answer:
Cells group of the Home tab