Excel Test

What is the order arithmetic operation?

(), E, *,/, +,- (please excuse my dear aunt shelly)

In an Excel worksheets, the rectangular area where a column and a row intersect (such as A1) is called a ______,

Cell

A cell referenced in a formula that does not change when copied to another cell is a(n) ______reference.

absolute

A ____ shows the name of a worksheet contained in the workbook.

sheet tab

The name box can be used to:

*go to a cell *assign a name to one or more cells *select a function

What is the default extension that Excel 2013 assigns to files?

.xlsx

Write the resulting value of the expression =3+4*5

23

A ___ workbook is a workbook that has multiple worksheets containing one or more linking formulas.

3D workbook

Write the formula used to multiply cell B6 by cell H1.

=B6*H1

The ____ cell is the current cell, which is indicated by a dark green border.

Active

As you begin typing a label into a cell, the _____ feature searches for and automatically displays any other label in that column that matches the letters you typed.

AutoComplete

How to insert a new worksheet to the right of the current worksheet?

Click Box + at the bottom

To get ot of edit mode without making any changes, press the _____ key.

ESC

When you enter or edit data, click ____ to accept data typed in the active cell and keep the current cell active.

Enter (Blue check mark)

The fill handle is simply a tool used to select multiple cells. (T or F)

False. This is a copy tool.

_____ combine cell references, arithmetic operations, values, and/or functions used in a calculation and must begin with an (=) sign.

Formulas

The ____ _____ feature in Excel allows you to keep one or more rows and/or columns visible on the screen when scrolling a worksheet.

Freeze Panes

Click the _____ to display the dialog box to search for and select a function to insert into the active cell.

Insert Function (Green Fx)

Column headings are ______ at the top of each column.

Lettered

The _____ is an identifier that displays the address of the current cell in the worksheet.

Name Box

________ indicates where the worksheet will be divided into pages.

Page Break Preview

What view shows the margins, header and footer area, and a ruler.

Page layout view.

D5:k27 represents a group of cells, otherwise commonly referred to as a _____ in Excel.

Range

The ______ button is the rectangle with a triangle in it located in the upper-left corner of the worksheet where the row and column headings meet.

Select All- Click it to select everything contained in the active worksheet.

If you workbook contains several worksheets, use the ________ to display the first,previous, next, or last worksheet.

Sheet tab navigation bottons

When you create a new Excel workbook, the default worksheet is named ____.

Sheet1

The ______ displays information about a selected command or operation in progress.

Status bar

When in a cell and you add a row or column, where is it placed.

The added row is above the cell and the column is to the left of the cell.

By default, the formula bar displays formulas the user has entered into a cell, while the result of the formula displays in the worksheet cell. (T or F)

True

Double click on a cell puts you in edit mode and edit is displayed at bottom of the worksheet. (T or F)

True

Formulas always start with an = sign or excel will think it is text. (T or F)

True

Numbers are right aligned by default. (T or F)

True

Text is left aligned by default. (T or F)

True

To select a nonadjacent range, you begin by selecting an adjacent range, and then you press and hold sown the Ctrl key and select other adjacent ranges. (T or F)

True. (only after the first range is selected)

Click the ______to display the worksheet in Normal,Page Layout or Page Break Preview.

View Control

Excel Stores its "documents" as files called______.

Workbooks

The ____ is the current cell.

active cell

When you enter or edit date, click ___ to cancel the data entry or edit and revert back to the previous data in the cell.

cancel (RED X)

The intersection of a of column & a row is a ___.

cell

Each cell has a unique ________.

cell address

In Excel charting, the chart legend identifies the format or color of each ______ series.

data

The forward slash (/) symbol is used as an arithmetic operator in Excel to perform a ____ operation.

division

You can enter or ____ cell contents here or directly in the active cell.

edit

The _____ shows the contents of the active cell.

formula bar

A specific region you create in the worksheet to store and change the variables used in calculations

input area

In Excel charting, the chart ______ identifies the for format or color of each data series.

legend

Numeric values may appear as #### if a column is too _____.

narrow

Row heading are ____ to the left of the rows.

numbered

The region in the worksheet to contain formulas dependent on the values in the input area .

output area

A _____ is an electronic file that contains a grid of columns and rows used to organize related data and to display results of calculations, enabling interpretation of quantitative data for decision making.

spreadsheet

In Excel, formulas and functions must be written according to specific set of rules called the ___.

syntax

Normal view displays the worksheet _____ showing margins, headers, footers, and page breaks.

without

A ______ is a collection of one or more related worksheets contained within a single file.

workbook

In Excel, a _____ is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data.

worksheet