Exam 6: Excel Module Getting Started With Excel

The formula bar displays the value or formula of the active cell. 

In ____ orientation, a page is taller than it is wide.

The range reference for a(n) ____________________ range includes the range reference to each range, separated by a semicolon.

An Excel worksheet can have a maximum of ____ columns in a worksheet.

A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell.

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

When you copy a selection of cells using drag and drop, which appears before you release the mouse button?

To go to column A of the current row, press ____.

____ makes it easier to enter repetitive text in cells.

A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon. 

____ enters text based on patterns it finds in the data.

When you ____________________ a workbook, a dialog box might open, asking whether you want to save the workbook.

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window. 

To change the order of operations, enclose part of the formula in ____.

What is the result of the expression =50+20/10*5?

An adjacent range is a collection of separate ranges. 

A(n) ____________________ is a named operation that replaces the arithmetic expression in a formula.

To make A1 the active cell, you should press which of the following keys?