NEW
Font size
WorksheetsSpreadsheet Programs Quiz
Total questions: 29
Worksheet time: 15mins
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
The 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
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?
hold down the control key while you click each cell in the column
click any cell in the column
hold down the shift key while you click the last cell in the column
In a spreadsheet program, a group of cells is called a
series
range
reference
chart
This term refers to the typeface used for data in a worksheet cells.
point
style
text
font
To show this type of number in a worksheet, you might place it in parentheses
negative
currency
decimal
percentage
You can format this in a worksheet by giving it a background color or a border
currency
text
font
cell
To change a column's width, you can drag this
its heading's left edge
its lower-right corner
its heading's right edge
its border
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 series
data set
data string
data fill
This spreadsheet feature can enter a data series automatically.
autoseries
autocell
autoenter
autofill
A data series is a set of data that changes by a ____________ value.
constant
random
substitute
odd
If you want a column to automatically resize itself to accommodate its longest data, do this:
double-click its heading's right edge
select it
drag its border
double-click its heading's left edge
This type of chart shows changes over time emphasizing fixed points in time
column
line
bar
pie
This type of chart shows different parts in relation to the whole
bar
pie
line
column
In a function, a symbol such as @ or = acts as the function's
argument
name
keyword
identifier
This term describes a cell reference that changes when it is copied or moved
absolute
incremental
relative
flexible
This type of cell reference does not change when you copy or move it
decremental
absolute
incremental
relative
