# Excel Chapters 2-5

## Unlock all answers in this set

question
A(n) ____ is a group of cells in a rectangular block.
Range
question
According to the order of operation in Excel:
Excel performs exponentiation, then multiplication and division, then addition, and subtraction.
question
What is the result of the expression =50+20/10*5?
60
question
To move the active cell up one row, press ____.
Shift + Enter
question
To switch to ____ mode, you double-click the cell.
Edit
question
To change the order of operations, enclose part of the formula in ____.
Parentheses
question
An Excel formula always begins with a(n) ____.
equals sign
question
Which of the following takes precedence over multiplication?
exponentiation
question
The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.
COUNT
question
Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.
shortcuts
question
A(n) ____________________ of the original range is placed in the new location without removing the original range from the worksheet.
copy
question
When you ____________________ a workbook, a dialog box might open, asking whether you want to save the workbook.
close
question
A(n) ____________________ is a grouping of text and numbers in a rectangular grid or table.
question
A(n) ____________________ is a named operation that replaces the arithmetic expression in a formula.
function
question
____________________ enters text based on patterns it finds in the data.
Flash Fill
question
____________________ removes the data from the row or column as well as removes the row or column itself.
Deleting
question
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
question
The ____________________ font size for worksheets is 11 points.
default
question
AutoFit changes the column width or row height to display the longest or tallest entry within the column or row.
True
question
A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell.
False
question
The name of the active workbook appears in the status bar of the Excel window.
False
question
Normal view shows how the worksheet will appear when printed.
False
question
Column width is expressed in terms of the number of characters a column can contain or the size of the column in points.
False
question
File Explorer provides ____ ways to view the contents of a folder
8
question
File Explorer displays the contents of your computer by using ____ to represent drives, folders, and files.
icons
question
Swiping from the right edge of the screen toward the center ____.
displays the Charms bar
question
In most cases, a file deleted from a USB drive ____
is deleted permanently
question
Windows 8 stores compressed files in a special type of folder called a(n) ____.
archive
question
The hard disk is assigned to drive ____.
C
question
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
question
The ____ character is allowable in a folder name.
-
question
Moving fingers apart on the screen ____.
zooms the display in
question
A folder name can have up to ____ characters.
255
question
Windows 8 automatically saves files after every update or change, so manually saving is no longer necessary.
False
question
Windows Vista, Windows 7, and Windows 8 were all designed for touch-screen computers such as tablets.
False
question
Every file you save must have a storage location and a(n) filename.
True
question
Using Windows 8 with a touch screen, pinch two fingers on the screen to zoom out.
True
question
Sorting files means listing them in ascending order or descending order by a file detail.
True
question
Boxes D, E, and F in the accompanying figure point to items in the ____________________ pane.
question
In the path "Computer Ã¨ Removable Disk (G:) Ã¨ Wizard Widgets Ã¨ Stock Ã¨ Staff.jpg" the name of the file is ____________________ .
Staff.jpg
question
Windows stores folders and important files that it needs when you turn on the computer in the ____________________ directory.
root
question
You can open a file using File Explorer by ____________________ it in the right pane of File Explorer.
double-clicking
question
A duplicate copy of important files is known as a(n) ____________________.
backup
question
The non-icon views available in File Explorer include ____________________, Details, Tiles, and Content.
list
question
Windows provides ____________________ in File Explorer so you can organize files by category -- documents, music, pictures, and video.
libraries built-in libraries
question
In order to use SkyDrive, you need to have a(n) ____________________ account.
Microsoft
question
When working in any view besides Details view, you sort by using the ____________________ tab on the ribbon.
View
question
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
question
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
question
The code _____ will display the filename of the current workbook.
&[File]
question
_____ merges each of the rows in the selected range across the columns in the range.
Merge Across
question
The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate
Find
question
Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.
question
Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.
numbers
question
By default, numbers appear in the _____ and generally display values exactly as you type them.
General format
question
A(n) ____________________ is a selection of formatting options using a specific font and color from the current theme.
style
question
To remove conditional formatting in Excel, click ____________________ after clicking the Conditional Formatting button.
Clear Rules
question
One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.
formatting
question
Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.
increase indent
question
The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.
Format Painter
question
The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.
Alingment
question
One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.
Merge
question
The region that is sent to the printer from the active sheet is known as the ____________________.
Print Area
question
A(n) ____________________ is a key that shows each color used in the worksheet and what it means.
Legend
question
A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.
theme
question
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
question
Each header and footer has three sectionsâ€”a left section, a center section, and a right section.
True
question
Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.
False
question
Text and numbers are displayed vertically within cells.
False
question
Calculated values too large to fit into the cell are displayed in scientific notation.
True
question
____ 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
question
The Insert Function button is in the ____ group.
Function Library
question
Absolute references are marked with a ____.
\$
question
Use ____ references when you want different formulas to refer to the same cell.
absolute
question
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
question
When you nest functions, you should have ____.
the same number of left and right parentheses
question
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
question
=IF(G22= "x ", SUM(H22:J22), " ") will display ______ if G22 is not equal to "x".
a blank cell
question
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.
nested
question
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
question
____________________ is a set of rules which specifies how a function should be written.
Syntax
question
TODAY is an example of a(n) ____________________ function.
date
question
An ___________________ occurs when the lookup value falls within a range of numbers in the first column of the lookup table.
approximate match lookup
question
Functions can also be ____________________ or placed inside another function.
nested
question
A(n) ____________________ reference contains both relative and absolute references.
mixed
question
The small black plus sign in the lower-right corner of a selected cell or range is called the ____________________.
fill handle
question
The ____________________ organizes all of the functions by category and allows you to search for functions that perform particular calculations.
Insert Function dialog box
question
____________________ is an Excel function category that returns information about the format, location, or contents of worksheet cells.
information
question
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
question
When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell.
True
question
One challenge of nesting functions is to make sure that you include all of the parentheses.