Your Social Security Number (only needed if you are told to use it by your institution)
Your Authorization code (if using the NCA&T distance faculty development program)
NC A&T State University
Western Carolina University
UNC Chapel Hill
UNC Greensboro
NC State University
Elizabeth City State University
UNC Wilmington
Tyrell County Schools
Robeson County Schools
Moore County Schools
Iredell Statesville Schools
Cabarrus County Schools
Thomasville City
Schools
Questions provided by Western Carolina University. Choose the best answer.
1. A spreadsheet template is:
spreadsheet plan for doing many jobs
short forms for functions
a predefined spreadsheet plan for doing a specific job
labels that are too long for one cell
2. The formula function of a spreadsheet can be defined as:
making the spreasheet program a popular tool
store, print, merge, and sort information
prints a grid so you can see where to enter data
are mathematical expressions containing constant values and variables
3. A spreadsheet cell address:
is the location of a person who has committed a crime
is where the columns and rows intersect
represents formatting specifications
loads the spreadsheet program
4. Spreasheets:
are worksheets that are used to keep track of numbers
look like a table
can function like a calculator and are used to solve mathematical problems
are all of the above
5. Cell protection means:
contains the corresponding data of another cell
erases combined data corresponding to the protected cell
prevents changes in the cell from being made
clears all settings
6. Range refers to:
the extension of combined data from another spreasheet
a group of cells to which a command is to apply
the distortion of reality by using a nonzero origin
a three dimensional representation of consolidated spreadsheets
7. A spreadsheet absolute address:
remains constant throughout the copy operation
transfers any cell within a spreasheet from one place to another
is a convenient way to improve the appearence of a spreadsheet agter it has been developed
changes during a copy operation
8. A spreadsheet relative address:
remains constant throughout the copy operation
transfers any cell within a spreasheet from one place to another
is a convenient way to improve the appearence of a spreadsheet agter it has been developed
changes during a copy operation
9. The edit mode in a spreadsheet:
refers to a sequence in which a command and the cells affected by that command are specified
must remain constant during a move command
causes the contents of the active cell to appear in the control panel
goes away when you press the home key
10. C1 + D1 is interpreted as a label rather than as a mathematical expression:
True
False