NVCC ITE 140 Exam 1

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

a data point

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

cell style

A text value in Excel is also referred to as a ________.

label

All formulas begin with an ________.

=

Comma Style format displays a number with ________.

two decimal places

Hold down the ________ key to select nonadjacent cells.

Ctrl

In Excel 2016, row headings are identified by ________.

numbers

The Percent Style button formats selected cells as a percentage with

________.

zero decimal places

The ________ displays the current cell mode, the page number, and the

zoom buttons.

status bar

The default number format for cells is the ________ number format.

General

The keyboard shortcut to display Print Preview is ________.

Ctrl + F2

The value axis is also known as the ________.

y-axis

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

Sparklines

To display the document properties, click the ________ tab.

File

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

Press and hold for a few seconds

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

Format and Design

When a cell is part of an active formula, it is surrounded with ________.

a colored border with small boxes on each side

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

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

Tap the item

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

The cell below

When you type text in a cell it is ________.

left-aligned

Where is the fill handle located?

In the lower right corner of a selected cell

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

Move Chart button

Which of the following is FALSE about a workbook?

It can contain only one worksheet.

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 is NOT one of the default calculations displayed by Auto Calculate?

Maximum

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

Three decimal places

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

General format, Calibri, 11 pt

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

Rounding

________ is the keyboard shortcut for the Spelling command.

F7

The symbols <,>,<> can be described as _________.

Comparison operators

How do banded rows display?

Even rows are formatted differently from odd rows

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

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

a background color

In a large worksheet, which two Excel commands help to make the

worksheets attractive and easier to read?

Print Titles and Scale to Fit

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

On the title bar

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

The hyphen key and the forward slash key

Sheet tab names are ________ when they are grouped.

Underlined

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

contain a number

The COUNTIF function has two arguments ________.

the range of cells to check and the criteria

The MEDIAN function finds ________.

the middle value in a range of cells

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

Clipboard

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

F4

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

red diamond

What are the default names of worksheets?

Sheet1, Sheet2, etc.

What does a data bar in a cell represent?

The value of a cell relative to other cells

What is a pane bounded by?

Vertical or Horizontal bars

What is a summary sheet?

A worksheet where totals from other worksheets are displayed

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 the keyboard shortcut for flash fill?

Ctrl + E

When formatting a worksheet to be printed, ________ show where page

breaks are located.

dotted lines

Where do sheet tabs display in a workbook?

Lower area of the workbook window

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

The computer's clock

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

Flash Fill

Which of the following is FALSE about the NOW function?

It remains constant even when the workbook is opened.

Which of the following is FALSE about worksheet tabs?

The active worksheet tab displays in red font.

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

Ctrl + =

A ________ in a pie chart identifies the pie slices.

data label

A chart and all of its elements is known as the ________.

chart area

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

absolute cell reference

AutoFill will fill a series when you establish a pattern ________.

with two or more cells

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

It is a green plus sign.

If you edit data in a worksheet that is associated with a pie chart ________.

the pie slices will be automatically updated

In Goal Seek, the ________ box contains the formula that calculates the

information you seek.

Set cell

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

To value

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

The x-axis

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

what-if analysis

To size a chart proportionately, hold down the ________ key and ________.

Shift; drag a corner sizing handle

To what extent can a pie chart be rotated?

Up to 360 degrees

Use the ________ key to select A5:A8 and D5:D8.

Ctrl

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

It is centered on the page.

Where is the Format Painter button located?

On the mini toolbar and the Home tab

Which of the following displays trends over time?

A line chart

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

Height

Which of the following is TRUE about a pie chart?

It shows the relationship of each part to a whole.

Which of the following is the first order of operations?

Expressions within parentheses

Which of the following is the second order of operations?

Exponentiation

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

The y-axis

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

$

You must select ________ on a worksheet to create a pie chart.

two ranges

________ is a group of related data points represented by data markers.

A data series

________ is an Excel tool that finds the input needed to arrive at a desired result.

Goal Seek

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

Validation List

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

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

Trace Precedents command

A data tables is useful for all of the following except for ________.

determining the Future value (Fv)

A defined name provides a logical reference to ________.

Data

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

Goal Seek

A range of cells that shows how changing certain values 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

A technique to improve accuracy when entering data in a worksheet by controlling the type of data or the values that can be entered 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

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.

An Excel function that looks up values in a table array arranged as vertical columns is the ________ function.

VLOOKUP

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

Formula

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

tracer arrow

Apply styles to cells, such as Headings and Titles and Data and Model, by using the ________ command in the Styles group.

Cell Styles

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

precedent cells

Defined names can contain ________.

uppercase and lowercase letters

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

Defined names can contain spaces.

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