MS Excel Test #1

What is a cell in MS Excel?

• It is the rectangle at the intersection of a row and column on a spreadsheet.

• It is a highlighted rectangular box.

• It is an expression which calculates the value of a cell.

• It is a feature that allows the user to extend a series of numbers, dates, or text to have the amount of wanted cells.

Where is a name box and what does it do?

• It is a box to the right of the formula bar that displays the cell that is currently selected in the spreadsheet.
• It is a toolbar at the top of MS Excel spreadsheet .window that you can use to enter or copy an existing formula into the cells or charts.
• It is a box to the left of the formula bar that displays the cell reference of the cell that is currently selected.
• It is a single spreadsheet that contains cells organized by rows and columns.

What function will copy the formula across the adjacent cells?

• Formula

• Cell reference

• Active cell

• Fill handle

A formula is a mathematical expression which calculates the value of a(n) _________.

• Chart
• Active Cell
• Cell(s)
• Number(s)

What is a workbook?

• It is the information you enter into a spreadsheet.

• An Excel file that contains one or more worksheets.

• It is a highlighted rectangular box.

• None of the answers

When MS Excel puts a bold border around a rectangular box, it is considered a(n) __________________.

• Range
• Active cell
• Formula
• Cell reference

What is the purpose for using conditional formatting?

• To use a formatting that is applied to a cell when a specified condition is met.
• To copy the contents of a cell to adjacent cells
• To display the active cell's contents.
• None of the answers

When you have an Excel file with one or more worksheets, the document is called a(n) _____________.

• Portfolio

• Agenda

• Book

• Workbook

The data that is inside a cell in considered _____________________.

• Cell Data
• Cell Contents
• Active Cell
• Formats

A2, B3, and D6 are all examples of what?

• Cell names
• Cell data
• Cell filters
• Cell references