Introduction to Excel

Which shortcut key is used to save an Excel workbook?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + P

How do you select an entire column in Excel?

• Click the column letter at the top

• Double-click any cell in the column

• Right-click any cell in the column and choose Select All

• Click the row number at the left

Which of the following is used to move from one cell to another in a worksheet?

• Scroll Bar

• Tab Key

• Enter Key

• All of the above

What is the default name of the first worksheet in a new Excel workbook?

• Sheet0

• Sheet1

• Worksheet

• Workbook

What does the Fill Handle in Excel do?

• Moves the contents of a cell

• Copies cell contents to adjacent cells

• Deletes the contents of a cell

• Formats the cell with a pattern

How do you apply a border to a cell or range of cells?

• Go to the Insert tab and select Border

• Right-click the cell and select Apply Border

• Go to the Home tab, Font group, and select Borders

• Go to the Page Layout tab and select Borders

To enter data into a cell, you need to:

• Double-click the cell

• Click the cell and start typing

• Right-click the cell and select Enter

• Select the cell and press Enter

What is the result of pressing Ctrl + Home in an Excel worksheet?

• It saves the workbook

• It moves to the first cell (A1) of the worksheet

• It opens the Home tab on the Ribbon

• It creates a new workbook

Which tab on the Ribbon allows you to apply basic formatting such as font styles, colors, and borders?

• File

• Home

• Insert

• Data

Which option on the Home tab allows you to change the font color?

• Fill Color

• Font Style

• Font Color

• Cell Color