Excel Chapters 2-5

A(n) ____ is a group of cells in a rectangular block.

According to the order of operation in Excel:

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

To move the active cell up one row, press ____.

To switch to ____ mode, you double-click the cell.

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

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

Which of the following takes precedence over multiplication?

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

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

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

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

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

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

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

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

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

The ____________________ font size for worksheets is 11 points.

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

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

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

Normal view shows how the worksheet will appear when printed.

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

File Explorer provides ____ ways to view the contents of a folder

File Explorer displays the contents of your computer by using ____ to represent drives, folders, and files.

Swiping from the right edge of the screen toward the center ____.

In most cases, a file deleted from a USB drive ____

Windows 8 stores compressed files in a special type of folder called a(n) ____.

The hard disk is assigned to drive ____.

The ____ is a temporary Windows 8 storage area for files and information that you copy or move from one location to place in another.

The ____ character is allowable in a folder name.

Moving fingers apart on the screen ____.

A folder name can have up to ____ characters.

Windows 8 automatically saves files after every update or change, so manually saving is no longer necessary.

Windows Vista, Windows 7, and Windows 8 were all designed for touch-screen computers such as tablets.

Every file you save must have a storage location and a(n) filename.

Using Windows 8 with a touch screen, pinch two fingers on the screen to zoom out.

Sorting files means listing them in ascending order or descending order by a file detail.

Boxes D, E, and F in the accompanying figure point to items in the ____________________ pane.

In the path "Computer è Removable Disk (G:) è Wizard Widgets è Stock è Staff.jpg" the name of the file is ____________________ .

Windows stores folders and important files that it needs when you turn on the computer in the ____________________ directory.

You can open a file using File Explorer by ____________________ it in the right pane of File Explorer.

A duplicate copy of important files is known as a(n) ____________________.

The non-icon views available in File Explorer include ____________________, Details, Tiles, and Content.

Windows provides ____________________ in File Explorer so you can organize files by category -- documents, music, pictures, and video.

In order to use SkyDrive, you need to have a(n) ____________________ account.

When working in any view besides Details view, you sort by using the ____________________ tab on the ribbon.

The ____________________ and ____________________ buttons are ideal when you want to move or copy files without leaving the current folder.

You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu.

The code _____ will display the filename of the current workbook.

_____ merges each of the rows in the selected range across the columns in the range.

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.

By default, numbers appear in the _____ and generally display values exactly as you type them.

A(n) ____________________ is a selection of formatting options using a specific font and color from the current theme.

To remove conditional formatting in Excel, click ____________________ after clicking the Conditional Formatting button.

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.

The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.

One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.

The region that is sent to the printer from the active sheet is known as the ____________________.

A(n) ____________________ is a key that shows each color used in the worksheet and what it means.

A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.

A(n) theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.

Each header and footer has three sections—a left section, a center section, and a right section.

Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.

Text and numbers are displayed vertically within cells.

Calculated values too large to fit into the cell are displayed in scientific notation.

____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

The Insert Function button is in the ____ group.

Absolute references are marked with a ____.

Use ____ references when you want different formulas to refer to the same cell.

Referring to the figure above, the last entry shown in Column K is 644.7953813. There is a black "plus sign" on the lower right edge of the cell that is the ____.

When you nest functions, you should have ____.

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

=IF(G22= "x ", SUM(H22:J22), " ") will display ______ if G22 is not equal to "x".

=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.

The ____________________ function is a logical function that returns one value if the statement is true and returns a different value if the statement is false.

____________________ is a set of rules which specifies how a function should be written.

TODAY is an example of a(n) ____________________ function.

An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.

Functions can also be ____________________ or placed inside another function.

A(n) ____________________ reference contains both relative and absolute references.

The small black plus sign in the lower-right corner of a selected cell or range is called the ____________________.

The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.

____________________ is an Excel function category that returns information about the format, location, or contents of worksheet cells.

Not all functions have arguments, and some functions have ____________________ arguments, which are not required for the function to return a value, but can be included to provide more control over the returned value.

When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell.

One challenge of nesting functions is to make sure that you include all of the parentheses.

To display the current date and time, which is updated each time the workbook is reopened, use the TODAY function.

A lookup table organizes numbers or text into categories.

The statement "A1 >= B1" tests whether the value in cell A1 is lesser than or equal to the value in cell B1.