Dr. L

Name Five Operators_

+ - * / ^

A key feature of Microsoft Excel is the ease with which you can ____.

Organize the data in a worksheet

When you ____________________ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.

freeze

The operator for performing multiplication is the ____.

*

Name Three Wildcards used in Electronic Searches

* ? ~

The little black box at the bottom of a selected cell is called a/an

Fill Handle

If you enter hte, which feature will automatically change the text to the?

Auto correct

Which feature can Lino use to quickly fill in a series of dates?

Autofill

All shortcuts in Microsoft Word are the same in Excel. (True or False)

False

Contiguous means located at two or more points away from each other.

False

Dynamic means about the same thing as Static

False

Generally, values are used in formulas rather than cell references.

False

Logic is closely associated with Word Processing in the academic World, but not so much Excel.

False

The default currency formats in Excel are fixed and not subject to reformatting or changing.

False

To create an absolute cell reference, you insert an equal sign (=) before the column letter and/or row number of the cell reference you want to stay the same.

False

Using AutoFill is not as fast as copying and pasting.

False

When you add a new row, the data shifts up a row.

False

When you edit the data in a worksheet, you must edit the data in the chart as well

False

When you split a worksheet horizontally, the panes appear side by side on the screen

False

You can only have one Excel workbook open at a time

False

You cannot rename sheet tabs

False

When you ____________________ data, you screen data that matches specified criteria.

filter

You can use multiple fonts in one document

True

Zoom settings allow you to change the magnification.

True

The VLOOKUP AND HLOOKUP functions allow one to access data from spreadsheets other than the one currently

Viewed

Excel refers to a spreadsheet as a ____.

Worksheet

If text doesn't fit on one line, you can use the ____ button to allow all the text to wrap to new lines within the cell.

Wrap text

The ____ shows the cell contents

Formula bar

How can Sam remove the dividing line in the split worksheet?

click the remove split button

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

columns

A/an _________________ is an imaginary product used to teach an academic lesson or provide examples.

widget

Macy sees the error #NULL! in a cell of her worksheet. What is likely the problem?

A space is used where it is not appropriate

The formula =$A1 is an example of a(n) ____ cell reference

Absolute

The Name box shows the ____.

Active cell

When a cell is selected, it is called the ____.

Active cell

When you select a group of cells, the group is called a(n) ____________________.

range

Sections of Cells can be named and processed as individual entities, they are called named

.

____ are often used in summary worksheets to condense and total data from other worksheets.

3D references

All Excel formulas begin with ____.

=

Macy wants to show the organization's total dollar amount of dues collected in the cells B2 to B40. Which is the correct formula?

=SUM(B2:B4)

What is the arrow pointing to in Figure 17-2 above?

Cancel, enter, and insert function buttons

A1 and B4 are examples of ____.

Cell references

The ____ allows you to remove the contents and the formatting in a cell.

Clear button

What should Lino click to select an entire column so that he can change its formatting?

Column heading

Name Five Kinds of Charts

Column, Line, Pie, Bar, Area

A ____ is used to separate cell references that are not adjacent.

Comma

Formulas containing more than one operator are called ____.

Complex formulas

The ____ command scales the worksheet up or down as necessary so it fits on the number of pages you designate.

Fit to

Which button should she use to copy the formatting of a cell without copying the contents of the cell?

Format painter

When you enter text in a cell, it also appears in the ____.

Formula bar

Sam has selected a range of cells he wants to freeze. Which option will allow him to freeze panes based on selected cells?

Freeze panes

Which view hides the Ribbon, the formula bar, and the status bar?

Full screen

A(n) ____ is a special formula that names a function instead of using operators to calculate a result.

Function formula

A ____ contains column headings or field names in a data source, such as a table or spreadsheet.

Header row

Inserting this tools or feature allows for the use of Screen tips

Help Tools

Press the ____ key to move the insertion point to the first cell in a row.

Home

The Excel error ########## means?

The cell cannot fit the number

When you want to add a new category to an Excel workbook, you click the ____ at the bottom of the screen.

Insert worksheet button

____ are computer programs that are so necessary or desirable that they prove the core value of some larger technology, and as a result, they substantially increase the sales of the platform that they run on.

Killer Apps

Where are the sizing buttons that control the application and worksheet windows?

Lower right corner of the status bar

The ____ button spans text across several columns.

Merge and center

Which button is the black arrow pointing to in Figure 18-2 above?

Merge and center

This Man invented Lotus 123, the precursor to MS Excel

Mitch Kapor

Name four types or Categories of Data

Numbers, Text, Functions, Formulas

The sequence used to calculate the value of a formula is called the ____.

Order of evaluation

Which view separates the column and row labels from the worksheet cells?

Page layout

A ____ is identified by the cell in the upper-left corner and the cell in the lower-right corner, separated by a colon.

Range

A1:D4 is an example of a ____.

Range

____ is a mathematical function.

SUM

Kristin wants to insert three new columns. What should she do before executing the Insert Sheet Columns command?

Select three columns

Kristin is entering data in cells. Why does she see ### in some of the cells?

She entered more than can fit into the cell

____ at the bottom of the screen provide quick and easy access to worksheets

Sheet tabs

You can base a sort on as many as six columns.

True

When the header row scrolls out of view, it is difficult to identify the data. Which of the following is not an option to help overcome this problem?

Sort data

An alternative way to freeze rows and columns is to ____ a worksheet, which divides the worksheet into two panes.

Split

When using the AutoComplete feature, you can press ____ to accept a proposed entry

Tab

A + (plus sign) is an example of an operator

True

A formula consists of two components: an operand and an operator

True

AVERAGE is a statistical function.

True

Computer software engineer is one of the fastest growing occupations.

True

Computers evaluate and assess worksheet values.

True

Copying data saves you from having to enter the same data into another location

True

Excel has more than 400 built-in formulas for performing calculations.

True

The arrow keys move the insertion point one cell in any direction

True

The default Currency format has two decimal places and a dollar sign.

True

The way Excel determines data from equations is by the use of Operators.

True

Usually the top row of a worksheet is used for explanatory text or column headings that identify the type of data in each column.

True

Watermarks in excel are never recommended because Excel is not an Art Program

True

When a cell is selected, the column and row headings for the selected cell are highlighted.

True

When you delete the contents of a cell using the Delete key or the Backspace key, the formats for the cell remain in the cell.

True

When you insert or delete a row or a column in Excel, it affects the entire worksheet

True

A(n) ____________________ cell reference does not change when the formula is copied or moved to a new location.

absolute

The ____________________ is a value, a cell reference, a range, or text that acts as an operand in a function formula, and it is enclosed in parentheses after the function name.

argument

You can drag a column ____________________ to change the column width

boundary

A(n) ____________________ style is a set of predefined formats that you can apply to all the worksheet data with a single click.

cell

The intersection of a single row and a single column is called a(n) ____________________.

cell

Pablo decides a bar chart would illustrate the data more effectively. Which button will enable him to choose a new chart?

change chart type

____________________ orientation formats the document sideways with the long edge of the page at the top.

landscape

You can change the order of evaluation by using ____________________.

parenthesis

A(n) ____________________ is a grid of rows and columns into which you enter text data and numerical data.

spreadsheet