34 questions
To select a worksheet cell, you click it.
True
False
You can format a worksheet so that negative numbers appear in red.
True
False
In most spreadsheet programs, a file can hold only one worksheet.
True
False
To view a worksheet in a workbook, just click the worksheet's tab.
True
False
You can move a worksheet to a new location within its workbook, but a worksheet cannot be moved to a different workbook.
True
False
The data series 10, 8, 6, 4 decreases by an increment of 2.
True
False
A data series can be made up of text, numbers, or dates.
True
False
When you want to total the values in a group of cells, you start by selecting the cell where the total will appear.
True
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.
True
False
The COUNT function counts the number of cells in a worksheet.
True
False
A function's argument is the data that the function must use.
True
False
If you want to use a cell range in a function, you must name each of the cells in the range.
True
False
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.
True
False
The cell reference A1 is an example of an absolute cell reference.
True
False
A spreadsheet program displays data in a special document, called a ________.
Spreadsheet
Work Table
Worksheet
Table
Before you format a cell, you should do this to it.
Enter Data In It
Select It
Delete It
None of the Above
How do you select an entire column of cells in a worksheet?
Click Any Cell In The Column
Click The Column's Heading In The Worksheet Frame
Hold Down The Shift Key While You Click The Last Cell In The Column
Hold Down The Control Key While You Click Each Cell In The Column
In a spreadsheet program, a group of cells is called a ________.
Series
Reference
Range
Chart
This term refers to the typeface used for data in worksheet cells.
Point
Style
Font
Text
To show this type of number in a worksheet, you might place it in parentheses.
Currency
Percentage
Decimal
Negative
You can format this in a worksheet by giving it a background color or a border.
Cell
Text
Currency
Font
To change a column's width, you can drag this.
Its Lower-right Corner
Its Border
Its Heading's Right Edge
Its Heading's Left Edge
To change a worksheet's name, double-click this.
Tab
Frame
Heading
None of the Above
This is a set of data that changes by a constant value.
Data Fill
Data String
Data Series
Data Set
This spreadsheet feature can enter a data series automatically.
AutoFill
AutoSeries
AutoCell
AutoEnter
A data series is a set of data that changes by a ________ value.
Odd
Substitute
Random
Constant
If you want a column to automatically resize itself to accommodate its longest data, do this.
Select It
Double-click its Heading's Right Edge
Drag Its border
Double-click Its Heading's Left Edge
This type of chart shows changes over time emphasizing fixed points in time.
Column
Bar
Line
Pie
This type of chart shows different parts in relation to the whole.
Column
Bar
Line
Pie
Which of the following is a commonly used spreadsheet function?
Average
Count
Sum
All Of The Above
This term refers to the rules of wording, which govern how a spreadsheet function must be written.
Formula
Syntax
Keyboard
Argument
In a function, a symbol such as @ or = acts as the function's ________.
Name
Identifier
Keyword
Aurgument
This term describes a cell reference that changes when it is copied or moved.
Absolute
Relative
Flexible
Incremental
This type of cell reference does not change when you copy or move it.
Absolute
Relative
Incremental
Decremental