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