Quiz 5 Excel 1

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. _________________________

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. _________________________

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points. _________________________

A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command. _________________________

A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created. _________________________

When text wraps within a cell, the column width increases so that all of the text within the cell is displayed. _________________________

Every function follows a set of rules, or syntax, which specifies how the function should be written. _________________________

Cutting moves the selected content, whereas copying duplicates the selected content. _________________________

When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it. _________________________

In the formula, =2+6*2, addition would be calculated after multiplication. _________________________

Normal view shows how the worksheet will appear when printed. _________________________

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

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

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

You can move to the previous or next sheet by pressing the ____ keys.

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 ____.

The characters +, -, *, and / are examples of ____.

An Excel formula always begins with a(n) ____.

The formula used to multiply cell A1 by cell C1 is ____.

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.

____ makes it easier to enter repetitive text in cells.

Which of the following takes precedence over multiplication?

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

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

According to the order of operation in Excel:

Which of the following will not change the location of the active cell?

What is the syntax for a SUM formula adding the values of cell F6 to F9?

Ctrl + G is used to access the ____.

mm/dd/yyyy is known as ____.

A(n) ____________________ is a grouping of text and numbers in a rectangular grid or table.

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

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

A(n) ____________________ of the original range is placed in the new location without removing the original range from the worksheet.

The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

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