CGS 2518 Exam 1

In Microsoft Excel, the file you create and edit is called a:

workbook

By default, Excel 2019 files are saved with this extension:

.xlsx

When you click on a cell to activate it, the cell address appears in
the:

name box

When you want to delete characters in a cell to the left of the
insertion point press:

backspace

A rectangular group of cells in Excel is called a(n):

range

To quickly select all the cells in a worksheet:

Press Ctrl+A

After you select and cut cells, the cells are temporarily placed:

on the clipboard

In an Excel worksheet dates and times are:

formats

When you want column and row headings displayed whether you are at
the top, bottom, left, or right of the spreadsheet, select:

freeze panes

Use this button to combine two or more cells into one cell and
center the text over a group of columns:

merge and center

This Excel feature allows users to use common arithmetic operations
to perform a calculation:

formulas

This symbol alerts Excel that you are entering a formula and not
text:

=

When a formula contains a typographical error, unnecessary or
missing punctuation, incorrect order of arguments, or an incorrect cell
reference, it returns:

an error message that begins with #

The Excel tool button that allows you to step through each part of a
formula is called:

evaluate formula

When you are creating formulas using a cell location, the default
cell reference is:

relative

This type of cell reference does not change when copied and remains
in a fixed position during operations:

absolute

A handy keyboard shortcut that turns a cell address entered in a
formula into an absolute cell reference, adding the dollar sign ($) in
front of the column and row addresses, is:

f4

It is important to remember that Excel calculates these operations
before any others are performed:

items in parentheses

Excel comes with many built-in formulas called:

functions

This Excel feature allows you to view totals, averages, or other
statistical information without creating a formula:

AutoCalculate

This function calculates loan payment amounts when the borrower
makes regular payments and the loan has a constant interest rate:

PMT

This useful Excel function evaluates a specified condition or
statement and returns one value if the condition or statement is true and
another value if it is false:

if

To reference cells in another worksheet, but in the same workbook in
which the current formula resides, use a:

3d cell reference

When you want to visually represent the numeric data in a worksheet,
Excel helps you create an appropriate:

chart

The text label that describes each data series in a chart is called
the:

category label

In a histogram chart, the category labels are shown:

on the horizontal axis

An Excel chart that is displayed on its own sheet in the workbook is
called a:

chart sheet

To apply changes to your chart's Shape Fill, Shape Outline, or
Shape Effects separately, use the:

format tab

The type of chart that shows percentages of a whole and has no axes
is a:

pie chart

The Excel chart element that displays averages in your data and can
be used to forecast data by plotting future approximate averages is the:

trendline

A variegated blend of colors in a chart element is called a:

gradient

A chart that includes two chart types such as a line chart and a
column chart is referred to as a:

combination chart

A Miniature chart that is displayed in a cell or cell range next to
your data to illustrate a pattern or trend is called a/an:

sparkline

The Statistical function that does computations only after data
meets multiple criteria is:

COUNTIFS.

The Math & Trig function that totals cells only if they meet
specified criteria, including cells from more than one column, is:

SUMIFS.

In an OR function, if any one of the arguments is true, the result
is:

true

A function within a function is described as:

nested

This function displays the contents of the cell at the intersection
of an identified column and row:

INDEX.

A range of cells that you select in which to apply a function is
called a(n):

array

Which type of function would you use to format a value as a label?

Text

What text function that includes a delimiter argument allows you to
join or combine strings of text?

CONCAT

The Standard Deviation functions are found in this category:

statistical