Introduction to Basic Excel

The intersection of a row and a column is called a ________.

• Cell

• Sum

• Worksheet

• Chart

How to delete information on a cell? (including the format of a certain cell)

• Click on the cell and press Del button

• Click on the cell and clear it using Backspace button

• Right Click on the cell and choose Clear Contents

• Close the workbook

Where is the fill handle located?

• in the bottom-right corner of the selected cell

• at the beginning of any formula or function

• on the right side of the Home tab on the Ribbon

• in Backstage view

In this image, why does the value in cell G1 look slightly different from the value in the formula bar?

• It’s using conditional formatting.

• It’s using a formula.

• It’s using an absolute cell reference.

• It’s using the Currency number format.

You can click the tabs at the bottom of a workbook to switch between ________.

• number formats

• cell range

• formulas

• worksheets

Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

• There is nothing wrong with the formula.

• It should use the COUNT function instead.

• It should have an equals sign (=) at the beginning.

• It should use quotation marks instead of parentheses.

Which of the following is an absolute cell reference?

• $A$2

• A2

• #A2

• A:2

The four areas in this image are used to create a ________.

• custom filter

• complex formula

• subtotal

• PivotTable

What is a workbook in Excel?

• a file that stores one or more worksheets

• a collection of files in a folder

• a type of chart

How can you select multiple cells at once in Excel?

• Hold down the Shift key while clicking the cells you want to select.

• Click and drag over the cells you want to select.

• Hold down the Shift key while clicking the cells you want to select.

• all of these ways