Excel Exam

All formulas and functions begin with a(n) ___.

= (equal sign)

A(n) ___ cell reference refers to a cell with a fixed position in the worksheet.

Absolute

Which symbol indicates multiplication in Excel 2016?

Asterisk *

___ adjusts the width of the column(s) to fit the cell content of the widest cell in the column

Autofit

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

By using a function button on the status bar

Hold down the ___ key to select nonadjacent cells.

Ctrl

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

Ctrl + =

In Excel, what is the keyboard shortcut for flash fill?

Ctrl + E

The keyboard shortcut to display Print Preview is ___.

Ctrl + F2

What happens to the displayed results of a formula if you change the value of a cell that is referenced in the formula?

Displayed value recalculates

When shown as part of a cell reference in a formula, what symbol indicates the cell address is an absolute reference?

Dollar Sign $

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

F4

What is the keyboard command to make a cell reference absolute?

F4

___ is the keyboard shortcut for the Spelling command in Excel, just as in other Office programs.

F7

Go to the ___ tab, then choose Export to create a PDF of an Excel worksheet.

File

Under which excel ribbon tab will you find the command to export a document as a PDF fiel

File tab

In Excel, ___ refers to the process of specifying the appearance of cells and the overall layout of your worksheet.

Formatting

In Excel, use the Show Formulas command on the ___ ribbon to display the formula or function in each cell instead of the resulting value.

Formulas

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

Move Chart button

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

Number symbol #

You must go to the ___ dialog box in order to create a header or footer in Excel

Page Setup

Arguments in an Excel function are surrounded by ___.

Parentheses

To calculate a percentage, you divide the ___ by the ___.

Part; total

The ___ button displays when you select a range of data, putting common commands close to your mouse pointer.

Quick analysis

In Excel, go to the ___ tab to access the Spelling function.

Review

To insert a new row in an Excel worksheet, ___ click on the row ___ where you want the new row to appear and choose Insert from the Shortcut menu.

Right; below

In Excel, ___ shrinks the width or height of the printed worksheet to fit a maximum number of pages and is convenient for printing formulas; which typically take up more space than the actual data.

Scaling

Another commonly used and more traditional term for worksheet

Spreadsheet

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

Three decimal places

When you insert a new column into an Excel worksheet, where does the new column appear?

To the left of the current column

In Excel, if the text in a cell is too long to fit into the cell, and the cell to the right contains data, the too long text in the cell on the left appears to be ___ -- cut off. The entire value continues to exist, but it is not completely visible.

Truncated

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

a colored border with small boxes on each side

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

a data point

In an Excel worksheet, an outlined cell with its column letter and row number highlighted is known as the ___.

active cell

The values that an Excel function uses to perform calculations or operations is called the ___; may include ranges, criteria, and/or comparisons.

argument

When you select a range of numerical data, the ___ feature display three calculations by default: Sum, Subtraction, and Multiplication.

autocalculate

In Excel, ___ generates and extends a series of data; a series being a group of things that come one after another in succession, such as days of the weeks, months of the year, or numeric data.

autofill

What is the quickest and simplest way to correct a cell displaying ##### in an Excel worksheet?

autofit the column to fit the widest entry in the cell column

The ___ function adds the values in a range of cells, and then divides the result by the number of values in the range.

average

The x-axis is also known as the ___ axis in an Excel chart.

category

intersection of the vertical and horizontal groups of data in an excel worksheet; identified by the combined headings of those groupings

cell

In an Excel worksheet, the location of a cell is identified by the column letter and the row number known as one of two terms; what are the two terms?

cell address or cell reference

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

cell style

A/n ___ is a defined set of cell formatting characteristics, such as font, font size, font color, cell, borders, cell shading, and others; used to maintain a consistent look in a worksheet and across worksheets in a workbook

cell styles

A graphic representation of data in an Excel worksheet.

chart

a vertical groups of cells in an excel worksheet; each group is identified by a unique letter or letters

column

A chart type useful for illustrating comparisons among related numbers using vertical rectangles of differing heights to represent each value being compared.

column chart

The <, >, and <> can be described as ___.

comparison operators

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

contain a number

Which of the following would correctly refer to a range of adjacent cells in an Excel worksheet?

d6:g12

Text or numbers located in a cell in a worksheet are referred to as ___.

data

A collection of related data points is called a/n ___.

data series

The Chart ___ Button appears as a green plus symbol to the right of an Excel chart and enables you to add, remove, or change chart characteristics such as the title, legend, gridlines, and data labels.

elements

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

___ means to change the appearance of cells in an Excel worksheet to make it more attractive and easier to understand for the reader.

format

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

format and design

An equation created in Excel to perform calculations; may use numbers, cell references, or both.

formula

the ___ in excel displays the value or formula in the active cell; also permits entry or editing

formula bar

Under which excel ribbon tab will you find the command to display formulas on the screen

formulas tab

A(n) ___ is a predefined formula such as SUM or MEDIAN. FUNCTION

function

In excel, a prewritten mathematical calculation that looks at one or more values, performs an operation, then returns a value; each has its own name and bases calculations on an argument

function

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

Under which excel ribbon tab will you find the command to autofit column widths

home tab

Where is the fill handle located?

in the lower right corner of a selected cell

Under which excel ribbon tab will you find the command to create a recommended chart

insert tab

Which of the following is false about workbook

it contains only one worksheet

A text value in excel is also referred to as a

label

Provides information and identification for the numeric data presented in an Excel worksheet.

label

What are the two types of data that can be entered into a cell in an Excel worksheet?

labels and values

When you type text in a cell it is ___.

left aligned

A chart element that identifies the patterns or colors that are assigned to the categories in the chart.

legend

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

maximum

The ___ command joins selected cells into one larger cell and centers the contents in the merged cells.

merge and center

displays the name given to a selected cell, table, chart, or object in an excel worksheet

name box

which view maximizes the number of cells visible on your screen in excel

normal

In Excel, row headings are identified by

numbers

under which excel ribbon tab will you find the command to change a worksheet to landscape orientation

page layout tab

A(n) ___ is a point of light measured in dots per square inch; used in excel to measure the width of a column.

pixel or picture element

Two or more cells in a worksheet—adjacent or not— which Excel treats as a unit for purposes of formatting or for use in functions.

range

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

red diamond

In an Excel formula, a ___ cell reference refers to a cell by its position relative to the cell that contains the formula.

relative

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

rounding

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

sparklines

Tiny charts located within a cell that provide a visual trend summary of data.

sparklines

Displays the current cell mode, the page number, and the zoom buttons in an excel worksheet

status bar

displays the current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average

status bar

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

the cell below

What does it mean if you see ##### displayed in the cell of an Excel worksheet?

the cell contains a value that is too large to display in the current column width

The MEDIAN function finds ___.

the middle value in a range of cells

The COUNTIF function has two arguments ___.

the range of cells to check and the criteria

What happens when you delete a column in an Excel worksheet?

the remaining columns shift to the left, and Excel adjust all formulas in the worksheet accordingly

What does a data bar in a cell represent?

the value of a cell relative to other cells

A(n) ___ is a predefined set of colors, fonts, line, and fill effects that coordinate for an attractive look across all worksheets in an Excel workbook file.

theme

Comma Style format displays a number with ___.

two decimal places

Any data in an Excel worksheet that may be used in calculations.

value

a ___ is an excel document that stores data in one or more ___, made up of rows and columns

workbook; worksheets

The value axis is also known as the ___.

y-axis

The Percent Style button formats selected cells as a percentage with ___ by default.

zero decimal places