Microsoft Excel, Lesson 1: Entering Data

Multiple Choice

The letters in Excel represent the...

• Rows

• Columns

• Cells

• Data

Multiple Choice

The numbers in Excel represent the...

• Rows

• Columns

• Cells

• Data

Multiple Choice

What is the cell in the worksheet in which you can type data?

• Main cell

• Open cell

• Active cell

• Absolute cell

Multiple Choice

The intersection of a row and column.

• column

• row

• cell

• active cell

Multiple Choice

The set of data that runs up and down in a spreadsheet

• column

• row

• cell

• active cell

Multiple Choice

Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.


Which of the following suggestions would help Luisa?

• Make the cell wider
• Change the number formatting in the cell
• Change the font format in the cell
• Delete the data and re-type it

Multiple Choice

Excel is part of

• Access
• Microsoft Office
• PowerPoint

Multiple Choice

To allow you to evenly distribute a title over a table of numbers, use the

• Center button
• Merge and Center button
• Merge cells only button

Multiple Choice

How do you change column width to fit the contents?

• Single-click the boundary to the left of the column heading
• Double-click the boundary to the right of the column heading
• Press ALT and single-click anywhere in the column

Multiple Select

Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.

• Enter Keys

• Arrow Keys

• Piano Keys

• Tab Key

Multiple Choice

The cell address of the highlighted cell is

• C

• 4

• A4

• C4

Multiple Choice

These are known as

• workbooks

• worksheets

• formula bar

• cell

Multiple Choice

What does the indicated icon do in the red box?

• Apply underline

• Apply italic

• Make text bigger

• Apply bold

Multiple Choice

A formula in the spreadsheet should always start with 

• a plus sign
• an asterisk
• an equals sign
• a capital letter

Multiple Choice

Which of these would add up the numbers from A3 to A6 

• +(A3:A6)
• =(A3:A6)
• =(Ave(a3:a6))
• =Sum(A3:A6)

Multiple Choice

What are lines that can be applied around worksheet cells or objects?

• Gridlines
• Borders
• Underlines
• Boundaries

Multiple Choice

Excel is part of?

• Power Point
• Microsoft Office Suite
• Access
• Google

Multiple Choice

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

• Cell Address
• Worksheet
• Formula

Multiple Choice

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

• false
• true

Multiple Choice

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column