MS Excel Review

MS Excel Review

A review of labs 1-6

Multiple Choice

An Excel file is called....

• a spreadsheet

• a workbook

• a file

• a document

Multiple Choice

In MS Excel, this pointer allows you to..

• autofill cell contents

• select cells

• change column width or row height

• move or copy cell contents

Multiple Choice

Columns are

• horizonal

• vertical

Multiple Choice

The arrow keys can be used to move from cell to cell.

• True

• False

Fill in the Blank

The _________ has a bold border around it.

Fill in the Blank

New rows are inserted ________ the selected row.

Multiple Choice

Rows are

• horizontal

• vertical

Fill in the Blank

Finish this sentence: All formulas must start with a(n) __________

Multiple Choice

There is no way to check spelling in an Excel workbook.

• True

• False

Multiple Choice

What option will allow you to combine cells into one cell and place the text in the middle?

• Wrap Text

• Merge & Center

• Sort & Filter

Fill in the Blank

New columns are inserted to the __________ of the selected column.

Multiple Choice

The cell that is selected is called the...

• active cell

• column

• row

• coordinate

Multiple Choice

Columns are labeled with...

• numbers

• letters

• symbols

• cell addresses

Fill in the Blank

Fill in the Blank: Typed characters entered in the active cell address appear in the __________ ______.

Multiple Choice

In MS Excel, this pointer allows you to...

• change the column width or row height

• select cells

• autofill cell contents

• move cell contents

Multiple Choice

What does the command "Merge and Center" allow you to do?

• Sort the information.

• Place the text in the center horizontally and vertically.

• Make the text wrap to the next line.

• Combine cells and place the text in the middle.

Multiple Choice

Rows are labeled with...

• numbers

• letters

• symbols

• cell addresses

Multiple Choice

Which of the following is an example of a cell address?

• 2A

• B

• D4

• 16

Multiple Choice

What is the area in the upper left side called that displays the active cell address?

• Formula Bar

• Name box

• Function Library

• Column

Multiple Choice

What is the default alignment of numbers?

• left

• center

• right

• justified

Multiple Choice

The Quick Access Toolbar is...

• near the tab scrolling buttons.

• found at the bottom of the screen.

• customizable

• None of the above

Multiple Choice

Which symbol represents multiplication in a formula?

• *

• x

• +

• /

Multiple Choice

Which ribbon tab do you use to change the orientation (Portrait or Landscape)?

• Formulas

• Insert

• Home

• Page Layout

Multiple Choice

What should you use to perform the calculation in cell D13?

• Formula

• Function

Multiple Choice

Which is the correct function that calculates the total in cell D13?

• =sum(D3:D12)

• =D3+D4+D5+D6+D7+D8+D9+D10+D11+D12

• =total(D3:D12)

• D3+D4+D5+D6+D7+D8+D9+D10+D11+D12

Poll

Which skills do you think you need to review?

• Cell Basics

• Formulas

• Functions

• Nothing

• Everything