Basic Microsoft Excel Skills

1.

Multiple Choice

10 sec

1 pt

What do you call the blank boxes on a spreadsheet?

cells

info

squares

spots

2.

Multiple Choice

10 sec

1 pt

What would be a correct formula for sum in excel?

=SUM(B3:B9)

=SUMB3+B9

SUM(B3:B9)

=ADD(B3:B9)

3.

Multiple Choice

10 sec

1 pt

_____ are vertical.

Rows

Columns

4.

Multiple Choice

30 sec

1 pt

________ are horizontal

Rows

Columns

5.

Multiple Choice

10 sec

1 pt

A combination of numbers and symbols used to express a calculation. Always begins with an = sign.

Cell address

Worksheet

Formula

6.

Multiple Choice

10 sec

1 pt

Microsoft Excel is what type of software?

Word Processing

Spreadsheet

Presentation

Drawing

7.

Multiple Choice

10 sec

1 pt

Which symbol must you use to begin a formula?

+

=

/

*

8.

Multiple Choice

10 sec

1 pt

How do you make a cell the active cell?

Click the ACTIVE button

Click INSERT CELL

Click on the cell

Cells are always active

9.

Multiple Choice

10 sec

1 pt

What is the name of this cell?

B10

5B

B5

A5

10.

Multiple Choice

10 sec

1 pt

True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?

True

False

11.

Multiple Choice

10 sec

1 pt

What is the Formula sign for multiply?

*

-

/

+

12.

Multiple Choice

30 sec

1 pt

By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.

True

False

13.

Multiple Choice

30 sec

1 pt

Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?

=(A1+A2+A3)/4

A1+A2+A3/4

=A1+A2+A3^4

(A1+A2) + A3/4

14.

Multiple Choice

30 sec

1 pt

Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?

=(C3+C5+C9)/3

=SUM(C2:C10)

=AVERAGE(C2:C10)

=(C3+C5+C9)

15.

Multiple Choice

30 sec

1 pt

You want to enter a series of dates down a column. What would be the best tool for the job?

Cut and Paste

AutoFill

Spelling Checker

Find and Replace

16.

Multiple Choice

30 sec

1 pt

True or False: Microsoft Excel can use Headers & Footers, just like Microsoft Word.

True

False

17.

Multiple Choice

30 sec

1 pt

You have decided to center the text within a cell. What have you done?

Changed alignment

Wrapped text

Merged cells

Autofit content

18.

Multiple Choice

30 sec

1 pt

Which of these number formats would you want to apply to a cell showing the total sales for the month?

Percentage

Currency

Date

19.

Multiple Choice

30 sec

1 pt

True or False: You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.

True

False

20.

Multiple Choice

30 sec

1 pt

You want to enter a series of dates down a column. What would be the best tool for the job?

Find and Replace

Cut and Paste

Spelling Checker

AutoFill

21.

Multiple Choice

30 sec

1 pt

What term refers to mathematical equations used in Excel to perform calculations?

Cell

Format

Formulas

Summations

22.

Multiple Choice

30 sec

1 pt

In Excel, all formulas must begin with what symbol?

!

#

$

=

23.

Multiple Choice

30 sec

1 pt

What symbol is used to designate an absolute cell reference?

#

!

$

@

24.

Multiple Choice

30 sec

1 pt

To sort names in a worksheet, we can use this button.

25.

Multiple Choice

30 sec

1 pt

To display the Letter Grade Equivalent, we can use the ___ function.

if

count

average

sum

26.

Multiple Choice

30 sec

1 pt

What function was used to find the highest grade?

average

min

sum

max

27.

Multiple Choice

45 sec

1 pt

The cell in the worksheet in which you can type data.

Active Cell

Formula

Landscape

Range

28.

Multiple Choice

45 sec

1 pt

A line around the edges of a cell.

Cell Reference

Fill Handle

Cut

Border

29.

Multiple Choice

45 sec

1 pt

Formatting option that changes the way numbers/data look in a cell.

Copy

Merge

Formula

Number Format

30.

Multiple Choice

30 sec

1 pt

The intersection of a column and a row in a table or worksheet.

Workbook

Column

Sheet Tab

Cell

Explore this activity with a free account