Computer Final

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

She entered more numbers than can fit in the cell

Computers evaluate and assess worksheet values.

false

Which button opens the Quick Styles gallery filled with table styles?

format as table

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

format painter

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

Which part of the function formula shown in Figure 19-2 above is the argument?

(B4:B8)

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

AutoCorrect

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

AutoFill

Using AutoFill is not as fast as copying and pasting.

False

You can only have one excel workbook open at a time

False

Generally, values are used in formulas rather than cell references

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

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 base a sort on as many as six columns.

false

You cannot rename sheet tabs

false

When you ______ data, you screen data that matches specified criteria

filter

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

fit to

A _________ is the design of the typeface in a document.

font face

The equation used to calculate values in a cell is known as a

formula

The ____ shows the cell contents

formula bar

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

formula bar

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

formula bar

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

freeze

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

header row

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

home

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

Upper right corner of the window

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

clear button

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

comma

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

true

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

true

When you apply a table style, the selected cells are converted to an Excel table

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

You can use multiple fonts in one document

true

Zoom settings allow you to change the magnification

true

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

A space is used where it isn't appropriate

What is pictured in Figure 18-1 above?

A worksheet split into two panes

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

range

A1:D4 is an example of a ____

range

When you select a group of cells, the group is called a

range

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

select three columns

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

sheet tabs

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

3-D 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:B40)

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

Change Chart Type

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

Column heading

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

Columns

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

Insert Worksheet button

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

Landscape

The Ribbon, tabs, and command groups are part of the ____

Microsoft Office Fluent user interface

____ is a mathematical function

SUM

Pablo wants to use only part of the data in a column chart. What should he do first?

Select the data he wants to use in the chart

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

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

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

True

An _______________ reference does not change when the formula is copied or moved to a new location

absolute cell

The Name box shows the

active cell

When a cell is selected, it is called the

active cell

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

The operator for performing multiplication is the ____

asterisk (*)

You can drag a column _________ to change the column width

border

The intersection of a single row and a single column is called a

cell

A1 and B4 are examples of

cell references

Formulas containing more than one operator are called ___

complex formulas

Text or numbers in the active cell are often referred to as

data/datum or value

The 3-D reference enables you to access data from three different dimensions in the workbook: length, width, and

depth

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

double-click it

What is the arrow pointing to in Figure 19-1 above?

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

The ____ button spans text across several columns

merge & center

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

merge & center

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

mixed

A shortcut for entering cell references is to ____

name a range of cells

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

order of evaluation

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

organize the data in a worksheet

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

page layout

You can change the order of evaluation by using

parentheses ( )

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

A ____________ is a grid of rows and columns into which you enter text data and numerical data

spreadsheet

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

tab

A _______ style is a set of predefined formats that you can apply to all the worksheet data with a single click

table

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

All cells in a range touch each other and form a rectangle

true

Computer software engineer is one of the fastest growing occupations.

true

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

true

Excel has more than 300 built-in formulas for performing calculations

true

In Excel, the header row provides labels which identify the content in the worksheet columns

true

In a 3-D reference, length and width refer to the worksheet rows and columns.

true

Many parts of a chart are positioned on the chart in a text box

true

Spreadsheets can function as basic databases.

true

Excel refers to a spreadsheet as a

worksheet

The arrows in Figure 17-1 above are pointing to ____

worksheet tabs

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