Computer Final Reveiw #1

Answer:D

.A data series is a set of data that changes by a ___________ value. a.odd b.substitute c.random d.constant

True

.Charts are also called graphs.

False

.If you see a set of symbols such as ##### or ***** in a cell, it means that the cell is too large to display the value you have typed into it.

Answer:D

.Messages from the program appear in this part of the worksheet. a.active cell b.formula bar c.tab d.status bar

True

.When you want to total the values in a group of cells, you start by selecting the cell where the total will appear.

Answer:B

.Which of these formulas divides 7 by 3? a.=7^3 b.=7/3 c.=7=3

Answer:A

28.This type of chart shows changes over time emphasizing fixed points in time. a.column b.bar c.line d.pie

True

A data series can be made up of text, numbers, or dates.

True

A formula is a mathematical expression.

False

A formula such as =5*3 uses cell references.

True

A function's argument is the data that the function must use.

Answer:D

A spreadsheet is a program that processes information that is set up in these. a.rows b.columns c.forms d.tables

Answer:C

A spreadsheet program displays data in a special document, called a _____. a.spreadsheet b.work table c.worksheet d.table

Answer:A

After you edit a cell's data, you can press this key to place it back in the cell. a.Enter b.Backspace c.Delete d.Escape

False

Although you can format a worksheet in many ways, you cannot add rows or columns.

Answer:B

Before you format a cell, you should do this to it. a.enter data in it b.select it c.delete it d.none of the above

Answer:B

How do you select an entire column of cells in a worksheet? a.click any cell in the column b.click the column's heading in the worksheet frame c.hold down the Shift key while you click the last cell in the column d.hold down the Control key while you click each cell in the column

True

If a function must always refer to a specific cell but there is a chance that the function will be moved to a different location, then the function should use an absolute cell reference.

False

If data is too wide to fit in a cell, part or all the data will be hidden and there is no way to view it.

Answer:A

If you change the appearance of data in a cell, this is called _____. a.formatting b.editing c.deleting d.moving

Answer:B

If you want a column to automatically resize itself to accommodate its longest data, do this. a.select it b.double-click its heading's right edge c.drag its border d.double-click its heading's left edge

Answer:C

If you want to print only a specific portion of a worksheet, you can specify this. a.chart b.formula c.print area d.print command

False

If you want to use a cell range in a function, you must name each of the cells in the range.

Answer:D

In a formula, the symbol ^ represents this operation. a.addition b.subtraction c.division d.exponentiation

Answer:B

In a function, a symbol such as @ or = acts as the function's _____. a.name b.identifier c.keyword d.argument

False

In a spreadsheet formula, operations within parentheses are most important, so they are always done last.

Answer:B

In a spreadsheet program, "C3" would be an example of this. a.worksheet b.cell address c.row d.column

Answer:C

In a spreadsheet program, a group of cells is called a _____. a.series b.reference c.range d.chart

True

In a worksheet, labels are typically used for headings or explanations.

Answer:C

In a worksheet, the cell that is currently in use is called the _____ cell. a.used b.identified c.active d.inactive

False

In most spreadsheet programs, a file can hold only one worksheet.

False

In the formula =(7*23)/12, the spreadsheet would perform division first, then multiplication.

True

Linking is a way to export data that keeps objects up-to-date.

true

Spreadsheets are used primarily for numerical data.

False

The COUNT function counts the number of cells in a worksheet.

False

The cell reference A1 is an example of an absolute cell reference.

False

The data series 10, 8, 6, 4 decreases by an increment of 2.

False

The status bar appears above the menu bar at the very top of the worksheet.

Answer:B

The term cell reference is another name for this. a.cell identifier b.cell address c.cell format d.cell tab

Answer:B

This area of a worksheet displays what you type. a.cell identifier b.formula bar c.status bar d.scroll bar

Answer:D

This can be text alone or a combination of numbers and text. a.value b.cell c.heading d.label

Answer:A

This forms the top and left borders of a worksheet and includes the column and row headings. a.frame b.cell identifier c.formula bar d.worksheet tabs

Answer:A

This is a commonly used formula, which is already built into a spreadsheet program. a.function b.fraction c.format d.frame

Answer:A

This spreadsheet feature can enter a data series automatically. a.AutoFill b.AutoSeries c.AutoCell d.AutoEnter

Answer:B

This term describes a cell reference that changes when it is copied or moved. a.absolute b.relative c.flexible d.incremental

Answer:B

This term refers to the rules of wording, which govern how a spreadsheet function must be written. a.formula b.syntax c.keyword d.argument

Answer:C

This term refers to the typeface used for data in worksheet cells. a.point b.style c.font d.text

Answer:D

This type of chart shows different parts in relation to the whole. a.column b.bar c.line d.pie

Answer:C

This type of chart shows how parts relate to the whole. a.bar b.line c.pie d.graph

Answer:B

This type of data is automatically formatted to align to the right in a cell. a.label b.value c.tab d.function

Answer:C

To change a column's width, you can drag this. a.its lower-right corner b.its border c.its heading's right edge d.its heading's left edge

Answer:A

To change a worksheet's name, double-click this. a.tab b.frame c.heading d.none of the above

:True

To select a worksheet cell, you click it.

Answer:D

To show this type of number in a worksheet, you might place it in parentheses. a.currency b.percentage c.decimal d.negative

True

To view a worksheet in a workbook, just click the worksheet's tab.

True

Using the keyboard's arrow keys, you can move in any direction in a worksheet.

Answer:C

When sharing data the file that contains the original data is called the________. a.destination file b.original file c.source file d.linked file

False

When you use a spreadsheet program, your data goes into a special kind of document called a table

Answer:C

When you write a formula, you start it with one of these to identify it as a formula. a.letter b.number c.symbol d.function

Answer:D

Which of the following is a commonly used spreadsheet function? a.AVERAGE b.COUNT c.SUM d.all of the above

Answer:C

Which of the following series of letters can help you remember order of evaluation used by a spreadsheet? a.PDEMSA b.PDMESA c.PEMDAS d.PMDEAS

True

You can format a worksheet so that negative numbers appear in red.

Answer:A

You can format this in a worksheet by giving it a background color or a border. a.cell b.text c.currency d.font

False

You can move a worksheet to a new location within its workbook, but a worksheet cannot be moved to a different workbook.

True

You can move data from one cell to another by dragging it.

True

You can use formulas to represent data in different cells.

Answer:C

You cannot use this key to move around in a worksheet. a.Home b.End c.Esc d.Tab

Answer:C

his is a set of data that changes by a constant value. a.data fill b.data string c.data series d.data set