Computer Applications SPREADSHEET EXAM

All formulas and functions begin with a(n) _____________

= (equal sign)

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

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

Absolute

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

Active cell

Which symbol indicates multiplication in Excel 2016?

Asterisk *

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

___________ 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

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

Category

Intersection of the vertical and horizontal groupings 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 group 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

Hold down the ______________ key to select nonadjacent cells.

Ctrl

The keyboard shortcut to display Print Preview is _________________

Ctrl + F2

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

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 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

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

To display the document properties, click the ______________ tab.

File

Under which Excel ribbon tab will you find the command to export a document as a PDF file?

File tab

______________ 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

In Excel, _________________ refers to the process of specifying the appearance of cells and the overall layout of your

Formatting

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

Formula

The _________ in Excel 2016 displays the value or formula in the active cell; also permits entry or editing

Formula bar

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

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

Formulas tab

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, 11 pt

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

What is FALSE about a workbook?

It can contain 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

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

Move Chart Button

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 2016, 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

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

Page setup

To calculate a percentage, you divide the ____________ by the ______________.

Part; total

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

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

Quick analysis

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

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

Relative

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

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

Rounding

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

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

Another commonly used and more traditional term for worksheet

Spreadsheet

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

Displays the current cell mode, the page number, and the the zoom buttons in an Excel Worksheet

Status bar

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

The cell below

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

The remaining columns shift to the left, and Excel adjusts all formulas in the worksheet accordingly.

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

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

Three decimal places

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

Comma Style format displays a number with _____________.

Two decimal points

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

Value

A/n ____________ 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

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

d6:g12