MS EXCEL

MS EXCEL

Welcome to Excel!

Multiple Choice

Excel file is saved as a ____________

• Document

• workbook

• worksheets

• Presentation

Multiple Choice

The entry bar is also known as (AKA):

• name box
• formula bar
• status bar
• none of the above

Multiple Choice

When you insert a row, where does Excel place it in relation to the cursor position?

• Above the current row.

• You must copy and paste any existing data down one row to have a blank row at the cursor position.

Multiple Choice

This is a:

• ribbon
• group
• tab
• none of the above

Multiple Choice

This is the:

• tab
• title bar
• group
• none of the above

Multiple Choice

What is the name of the cell that is colored blue?

• A

• B

• 2B

• B2

Multiple Choice

Which is a formula using MS Excel using addition.

• 2 + 3 =

• = A + B

• =A2+B3

• A2+B3

Multiple Choice

The Quick Access Toolbar is:

• customizable
• found at the bottom of the screen
• found on the right side of the screen
• none of the above

Multiple Choice

What is the symbol for division when using MS EXCEL.

• /

• +

• *

• -

Multiple Choice

How are ROWS in MS EXCEL spreadsheet named?

• numbers

• letters

• cells

• columns

Multiple Choice

Which is NOT a term used in Excel?

• Workbook

• Worksheet

• Cell

• Document

Multiple Choice

A program using a table comprising of rows, columns and cells.

• MS Word

• MS PowerPoint

• MS Outlook

• MS Excel

Multiple Choice

Which new workbook option displays the title, Book1, when it is created?

• A blank workbook.

• A workbook created from a template.

Multiple Choice

Why would you enter labels into the worksheet?

• Labels should be used when you need to enter text only.

• Labels are entered for report titles or column headings only.

• Labels identify the values and help outline the mathematical relationships.

• d.Labels identify where and how the values should appear.

Multiple Choice

What does every formula in MS EXCEL start with?

• +

• -

• =

• *

Multiple Choice

To select an entire row, where would you click?

• The cell in column A for that row.

• Click the row header for the row you want to select.

• Click the column header where your cell is in the row you want to select.

• Click the row number in the Name Box and press ENTER.

Multiple Choice

What is an EXCEL Spreadsheet used to make?

• Calendar

• Publisher

• Graph

• Card

Multiple Choice

Which key can you press to activate the Go To command?

• F1

• CTRL+H

• Ctrl+G

• F6

Multiple Choice

How is the COLUMN in a MS Excel Spreadsheet named?

• Numbers

• Letters

• Cells

• Columns

Multiple Choice

A program using a table comprising of rows, columns and cells.

• MS Word

• MS PowerPoint

• MS Outlook

• MS Excel

Multiple Choice

Can be used travel from cell to cell in a spreadsheet:

• tab
• enter
• arrow keys
• all of the above

Multiple Choice

What is the difference between a workbook and a worksheet?

• A workbook is the actual file that contains the worksheets, which turn contain the data.

• A workbook is a section that contains the worksheet reports; both are contained in a spreadsheet.

Multiple Choice

What displays when you activate the Cut or Copy command?

• A dialog box appears prompting you to proceed with the command.

• A marquee appears around the selected cells for the Cut or Copy command.

Multiple Choice

Which is the best way to set a column to a specific width?

• On the Home tab, in the Cells group, click Format, click Column Width and enter the measurement.

• Press CTRL+W to specify the width for the column.