Midterm Prep

What is an Excel Table?

A series of rows and columns that contains related data that can be managed independently from other data in a worksheet

What is a summary sheet?

A worksheet where totals from other worksheets are displayed

A chart value that originates in a worksheet cell is referred to as

a data point

you can save an excel file as a text file with which of the following file extensions?

.txt

By default, Excel 2016 files are saved in the native microsoft excel workbook file format with the following file extension

.xlsx

All formulas begin with a(n)

= sign

If a sheet tab has ___ you know that it is not selected

A background color

___ is a group of related data points represented by data markers

A data series

which of the following displays trends over time?

A line chart

Which of the following is NOT a way to create a formula?

By using a Function button on the status bar

Which of the following are some frequently and commonly used file formats for excel?

Excel template, excel 97-2003 workbook, CSV or tab delimited

Which of the following is the second order of operations?

Exponentiation

Which of the following is the first order of operations?

Expressions within parentheses

The quickest way to repeat an action in Excel is the ___ function key

F4

___ is the keyboard shortcut for the Spelling command

F7

To display the document properties, click the ___ tab

File

Which of the following excel features recognizes a pattern in the data of a worksheet?

Flash fill

What are the two contextual tabs that display under Chart Tools when a chart is selected?

Format and Design

You can create a custom table style by clicking

Format as table

When you start typing a formula, such as =SUM(B excel will display the ___, which contains all of excel's built in functions starting with the letter B

Formula autocomplete list

To freeze column and row titles on the screen so that the y are visible while you scroll, which of the following command(s) would you use?

Freeze panes

In the Excel PMT function, the term used to indicate the interest rate for a loan is called

Future value

The default number format for cells is the ___ number format

General

Which of the following is the default number format in Excel 2016?

General format, Calibri, 11pt

To move to a specific cell or range of cells in a large worksheet use the ___ command

Go to

To move to cells that have special characteristics, are blank, or contain constants, use the ___ command

Go to Special

____ is an excel tool that finds the input needed to arrive at a desired result

Goal Seek

A method to find a specific value for a cell by adjusting the value of one other cell is

Goal seek

The ___ function looks up values in a table array arranged in horizontal rows

HLOOKUP

In the data validation dialog box, you can create a ___ that will display when the cell is selected and that provides instruction to the person entering the data

Screen tip

All of the following are methods to define a name for a cell or group of cells except:

Select the range, click in the formula bar, and then type the name

What are the default names of worksheets

Sheet 1, Sheet 2, etc

To size a chart proportionately, hold down the ___ key and ___

Shift; drag a corner sizing handle

When using a touchscreen, which of the following actions is the same as clicking an item?

Tap an item

Hyperlinks can be attached to which of the following items?

Text and graphics

Which of the following is FALSE about worksheet tabs?

The active worksheet tab displays in red font

When you type data in a cell and press Enter, what cell becomes the active cell?

The cell below

Where does Excel's NOW function retrieve the data from?

The computer's clock

on your keyboard, which two symbols function identically in date formats?

The hyphen key and the forward slash key

What does a data bar in a cell represent?

The value of a cell relative to other cells

In a line chart, which of the following resides along the bottom of the chart?

The x-axis

Which of the following resides along the left side of a column chart?

The y-axis

Which of the following is NOT part of the Accounting Number Function?

Three decimal places

In Goal Seek, you enter the specific value that you want to achieve in the box ____

To value

___ display arrows that indicate what cells are affected by the value of the currently selected cell

Trace dependents command

Use the ___ command to locate and resolve an error in a formula

Trace error

A command that displays arrows to indicate what cells affect the value of the cell that is selected is the___

Trace precedents command

To what extent can a pie chart be rotated?

Up to 360 degrees

An excel function that looks up values in a table array arranged as vertical columns is the ___ function

VLOOKUP

What is a pane bounded by?

Vertical and horizontal bars

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as

What-if-analysis

The process of changing the values in cells to see how those changes can affect the outcome formulas in a worksheet is called

What-if-analysis

Using various interest rates to determine the amount of loan payments in an example of using

What-if-analysis

A defined set of formatting characteristics for a cell, such as fonts, font sizes, number formats, cell borders, and cell shading is known as

a cell style

When a cell is part of an active formula, it is surrounded with___

a color border with small boxes on each side

A defined set of formatting characteristics such as font, font size, and font color are known as a

cell style

Apply styles to cells such as Heading and Titles and Data and Model, by using the __ command in the style group

cell styles

A chart and all of its elements is known as the

chart area

Saving an Excel worksheet as a CSV file separates the cells of each row with:

commas

The COUNT function counts the number of cells in a range that ___

contain a number

To apply complex criteria to a single column, us a(n)

custom filter

use a(n) to apply complex criteria to a single column

custom filter

A defined name provides a logical reference to

data

A ___ in apie chart identifies the pie slices

data label

A range of cells that shows how changing a certain value in your formula affects the results of those formulas and that makes it easy to calculate multiple versions in one operation is a(n)

data table

An organized collection of facts related to a specific topic is known as a

database

Subtotaled rows that are totaled and summarized are referred to as ________ data.

detail

A data table is useful for all of the following except for___

determining the future values (Fv)

When formatting a worksheet to be printed, ___ show where page breaks are located

dotted lines

instead of displaying a filtered list, you can copy the results to another area of your worksheet for comparison purposes; this action is known as

extracting

A ___ is a single piece of information that is stored in every record

field

The first step in adding subtotals to a group or list is to sort the data by the ___ for which you want to create subtotal

field

___ displays only the rows that meet criteria or conditions you specify to limit which records are included in the results

filtering

An advantage to naming a range of cells is that you can use the name in a

formula

In the Excel window, where does [Group] display when worksheets are grouped

on the title bar

To see how different interest rates affect a monthly payment, use a

one-variable data table

Before printing or distributing a large worksheet, the print preview option enables you to see

orientation and page breaks

The portions of a worksheet window bounded by and separated from other portions by vertical or horizontal lines as a result of using the Freeze Panes command are referred to as

panes

In a lookup formula, the defined range is referred to as the

table array

A theme combines font sets for

text and headings

The MEDIAN function finds

the middle value in a range of cells

if you edit data in a worksheet that is associated with a pie chart __

the pie slices will be automatically updated

The COUNTIF function has to arguments

the range of cells to check and the criteria

A pre-designed set of colors, fonts, lines, and fill effects that look good together and that can be applied across all Office 2016 applications is called a

theme

An indicator that shows the relationship between the active cell and its related cell is called a(n)

tracer arrow

Comma Style format displays a number with

two decimal places

You must select __ on a worksheet to create a pie chart

two ranges

To see how different interest rates and different payment periods will affect a monthly payment, use a

two- variable data table

Sheet tab names are___ when they are grouped together

underlined

Defined names can contain

uppercase and lowercase letters

A ___ is a list of values that are acceptable for a range of cells

validation list

When preparing a document for printing, a ___ indicates that only the columns to the left will be printed on the first page.

vertical dotted line between columns

AutoFill will fill a series when you establish a pattern

with two or more cells

The vertical axis is also known as the

y-axis

The future value at the end of the time period in an excel function is usually___ for loans

zero

The percent style button formats selected cells as a percentage with

zero decimal places

What is the keyboard shortcut for flash fill?

Ctrl + E

The keyboard shortcut to display print preview is

Ctrl + F2

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be enters is called

Data validation

A word or string of characters in excel that represents a cell, a range of cells, a formula, or a constant value is called a ___

Defined name

Each of the following is a rule for that defining names except:

Defined names can contain spaces

The ___ command checks for common errors that occur when using formulas

Error checking

How do banded rows display?

Even rows are formatted differently from odd rows

Which symbol does excel use to indicate that a cell is not wide enough to display a formula or function result?

#

Which symbol represents that a cell is an absolute cell reference in a function or formula?

$

___ is the process of examining a worksheet for errors in formulas

Auditing

Which of the following file formats is commonly used to import data into a database program?

CSV

The ____ is the temporary storage location for cell contents copied from a worksheet

Clipboard

Hold down the _____ key to select nonadjacent cells

Ctrl

Use the ___ key to select A5:A8 and D5:D8

Ctrl

Which of the following is NOT a way to insert the SUM function into a cell?

Ctrl + =

Where is the fill handle located?

In the lower right corner of a selected cell

Which of the following is FALSE about a workbook?

It can contain only one worksheet

When you print a chart sheet, how is it automatically formatted?

It is centered on the page

Which of the follow is FALSE about the NOW function?

It remains constant even when the workbook is opened

Which of the following is true about a pie chart?

It shows the relationship of each part to a whole

Where do sheet tabs display in a workbook?

Lower area of the workbook window

Which of the following is NOT one of the default calculations displayed by AutoCalculate?

Maximum

If the files to which a hyperlink refers to is moved or renamed, or a webpage to which a hyperlink refers has a new address, which of the following do you need to do to the hyperlink to make it work correctly?

Modify the hyperlink to reflect the change

Which of the following does not display to the right side of a selected chart?

Move chart button

Where is the format painter button located?

On the mini toolbar and the home tab

IN a cell that contains a function, to copy the VALUE to another cell- rather than the function_ use the ___

Paste special command to display commands for paste values

Using the touchscreen, which of the following actions is the same as right-clicking the mouse?

Press and hold for a few seconds

in a large worksheet, which two excel commands help to make the worksheets attractive and easier to read?

Print titles and scale to fit

Which of the following describes all of the categories of data pertaining to one person, place, thing, event, or idea within a table row?

Record

___ is the procedure that determines which digit to the right of a number will be the last to be displayed

Rounding

How do you know if some rows of a table have been hidden from view when a filter is invoked?

Row numbers display in blue

A(n) ___ refers to a cell by its fixed position in the worksheet

absolute cell reference

If you want every one of the comparison criteria that you specify to be true, you would use

and comparison operator

A hyperlink in a worksheet may take you to which of the following of the following locations

another page in the worksheet or the company intranet

To tile multiple open worksheets on the screen, use the ___ command

arrange all

The page break view shows where the page breaks will occur by displaying

blue dashed lines and the page number on the worksheet

A ___ triangle in the upper left corner of a cell indicates that the formula in the cell is suspect for some reason and could be a potential error.

green

Which of the following is NOT one of the three spatial dimensions of 3-D?

height

Scaling reduces the ___ size of the printed data by a percentage or by the number of pages you specify

horizontal and vertical

Clicking a ___ will take you to another location in the worksheet, another file location, a web page on the intranet, or to your organization's internet

hyperlink

For lookup functions to work properly, the data in the table array must be sorted

in ascending order

The amount charged for the use of borrowed money is called

interest

How can you identify the Chart Elements button when you select a chart?

it is a green plus sign

A text value in excel is also referred to as a

label

When you type in a cell it is

left-aligned

A series of rows that contains related data is known as a

list

The defined table range will automatically display as the ___ range in the advanced filter dialog box

list

___ functions look up a value in a defined range of cells located in another part of the workbook to find a corresponding value

lookup

Fonts are associated with different themes and can be customized by:

mixing colors and fonts from any of the supplied themes

In Excel 2016, row headings are identified by

numbers

___ cells are cells that are referred to by a formula in another cell

precedent

Cells that referred to by a formula in another cell are called

precedent cells

The total amount that a series of future payments is worth is called the

principal

you can share worksheets or workbooks with others by

printing paper copies, sending file electronically, or posting the file to the web

To rotate text in a worksheet, in the Format Cells dialog box, you can click and drag the ___

red diamond

The Error Checking button displays as a

red square

Excel's formula auditing features can show___ between cells and formulas to ensure that formulas are logical and correct and also to resolve error messages

relationships

To save an Excel file in another file format, use the___ command

save as

You can force the data in worksheet into a selected number of pages by using the ___ command

scaling

The location within which a defined name is recognized without qualification is referred to as the

scope

In Goal Seek, the ____ box contains the formula that calculates the information that you seek

set cell

The outlier bar along the left side of a worksheet enable you to __ levels of detail with a single mouse click

show and hide

Tiny charts embedded in a cell that display a visual trend summary alongside your data are called

sparklines

The ___ displays the current cell mode, the page number, and the zoom buttons

status bar

Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.

tab delimited text file