Excel Tut Quiz 1

The name of the active workbook appears in the status bar of the Excel window.

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

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

The AutoComplete feature automatically completes an entry based on previous entries in a column.

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

Speed Fill enters text based on patterns it finds in the data.

The worksheet is organized into individual cells.

An adjacent range is a collection of separate ranges.

Numeric data is any number that can be used in a mathematical calculation.

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row.

Contains a grid of rows and columns into which you can enter text, numbers, dates, and formulas, and display charts.

Multiplication before addition

When you copy a range of cells, you must press this key while you drag the selection to its new location

A named operation that replaces the arithmetic expression in a formula

A group of worksheet cells

Press Ctrl + ` to switch to this view

Displays the cell reference of the active cell

Shows the contents of the worksheet

Displays the name of the sheets in the workbook

A preformatted workbook with many design features and some content already filled in.

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

In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

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

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

In the figure above, Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.

When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

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

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

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

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.

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

Which of the following takes precedence over multiplication?

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

According to the order of operation in Excel:

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

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

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

A(n) ____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

____________________ removes the data from the row or column as well as removes the row or column itself.

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