MS Excel - Concepts Review 1

Which is NOT a way to create a new workbook in Excel 2019?

• Using an existing template

• Using the Excel workbook maker

• Using an online template

• Create a blank workbook from scratch

Users can save a workbook in Excel 2019 using which item?

• Quick Access Toolbar

• Insert tab

• Home tab

• Ctrl+C

Which data format in Excel 2019 treats text as text and numbers as numbers?

• Basic

• Number

• Text

• General

Which is NOT a way to add worksheets to a workbook in Excel 2019?

• Right-click an existing sheet, click Insert, and click the OK button

• Open the Insert tab, click the Insert drop-down arrow, and click Insert Sheet

• Click the plus sign button near the existing worksheets

• Open the Home tab, click the Insert drop-down arrow, and click Insert Sheet

Which are two ways to copy a worksheet in Excel 2019?

• While holding the Shift key on the keyboard, click and drag the worksheet to a new location

• While holding the Ctrl key on the keyboard, click and drag the worksheet to a new location

• Right-click a worksheet tab and click Copy

• Right-click a worksheet tab and click Move or Copy

The Find and Select feature in Excel 2019 is located in which tab on the ribbon?

• File

• Insert

• Home

• Data

Which feature on the Excel ribbon is used to navigate to the last cell of the worksheet?

• Go To Last

• Find

• Go To Special

• Replace

The Format drop-down menu is found under which group on the ribbon?

• Editing

• Styles

• Cells

• Alignment

Which symbol indicates where a worksheet will be placed during the click and drag method of moving a worksheet in Excel?

• Green shield

• Yellow square

• Black line

• Black arrow

Rows and columns can be inserted and deleted using the ribbon under which tab?

• File

• Home

• Insert

• Page Layout