Excel Chapters 2-5

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

Range

According to the order of operation in Excel:

Excel performs exponentiation, then multiplication and division, then addition, and subtraction.

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

60

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

Shift + Enter

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

Edit

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

Parentheses

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

equals sign

Which of the following takes precedence over multiplication?

exponentiation

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

COUNT

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

shortcuts

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

copy

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

close

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

spreadsheet

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

function

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

Flash Fill

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

Deleting

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

planning analysis sheet

The ____________________ font size for worksheets is 11 points.

default

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

True

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

False

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

False

Normal view shows how the worksheet will appear when printed.

False

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

False

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

8

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

icons

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

displays the Charms bar

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

is deleted permanently

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

archive

The hard disk is assigned to drive ____.

C

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

Clipboard

The ____ character is allowable in a folder name.

–

Moving fingers apart on the screen ____.

zooms the display in

A folder name can have up to ____ characters.

255

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

False

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

False

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

True

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

True

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

True

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

navigation

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

Staff.jpg

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

root

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

double-clicking

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

backup

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

list

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

libraries built-in libraries

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

Microsoft

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

View

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

Move to, Copy to Copy to, Move to

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

Format cells

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

&[File]

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

Merge Across

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

Find

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

nonadjacent

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

numbers

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

General format

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

style

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

Clear Rules

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

formatting

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

increase indent

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

Format Painter

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

Alingment

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

Merge

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

Print Area

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

Legend

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

theme

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

False

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

True

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

False

Text and numbers are displayed vertically within cells.

False

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

True

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

Mixed

The Insert Function button is in the ____ group.

Function Library

Absolute references are marked with a ____.

$

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

absolute

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

fill handle

When you nest functions, you should have ____.

the same number of left and right parentheses

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.

relative

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

a blank cell

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

nested

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.

IF

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

Syntax

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

date

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

approximate match lookup

Functions can also be ____________________ or placed inside another function.

nested

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

mixed

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

fill handle

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

Insert Function dialog box

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

information

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.

optional

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

True

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

True

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

False

A lookup table organizes numbers or text into categories.

True

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

False