CGS 2518 Exam 1 Study Guide Part #1
Basic Concepts well answered already
passed
When you want column and row headings displayed whether you are at the top, bottom, left, or
right of the spreadsheet, select: - correct answer ✔✔Freeze Panes
In Microsoft Excel, the file you create and edit is called a: - correct answer ✔✔Workbook
In an Excel worksheet dates and times are: - correct answer ✔✔Values (e.g. 43565.125)
When you click on a cell to activate it, the cell address appears in the: - correct answer
✔✔Name Box
When you are creating formulas using a cell location, the default cell reference is: - correct
answer ✔✔Relative
When a formula contains a typographical error, unnecessary or missing punctuation, incorrect
order of arguments, or an incorrect cell reference, it returns: - correct answer ✔✔An error
message that begins with a number sign (#)
It is important to remember that Excel calculates these operations before any others are
performed: - correct answer ✔✔Items in parentheses
This function calculates loan payment amounts when the borrower makes regular payments
and the loan has a constant interest rate: - correct answer ✔✔PMT
Basic Concepts well answered already
passed
When you want column and row headings displayed whether you are at the top, bottom, left, or
right of the spreadsheet, select: - correct answer ✔✔Freeze Panes
In Microsoft Excel, the file you create and edit is called a: - correct answer ✔✔Workbook
In an Excel worksheet dates and times are: - correct answer ✔✔Values (e.g. 43565.125)
When you click on a cell to activate it, the cell address appears in the: - correct answer
✔✔Name Box
When you are creating formulas using a cell location, the default cell reference is: - correct
answer ✔✔Relative
When a formula contains a typographical error, unnecessary or missing punctuation, incorrect
order of arguments, or an incorrect cell reference, it returns: - correct answer ✔✔An error
message that begins with a number sign (#)
It is important to remember that Excel calculates these operations before any others are
performed: - correct answer ✔✔Items in parentheses
This function calculates loan payment amounts when the borrower makes regular payments
and the loan has a constant interest rate: - correct answer ✔✔PMT
