Home
Subjects
Explanations
Create
Study sets, textbooks, questions
Log in
Sign up
Upgrade to remove ads
Only $35.99/year
Other
Computer Skills
Excel
CGS EXAM 1 REVIEW CH 2
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (13)
this excel feature allows users to use common arithmetic operations to perform a calculation:
a. Formulas
b. Formatting
c. Filters
d. Insertions
e. Components
Formulas
This symbol alerts Excel that you are entering a formula and not text:
a. *
b. $
c. =
d. #
e. ^t
=
When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns:
a. An error message that begins with an exclamation point (!)
b. A blank cell
c. An error message that begins with a number sign (#)
d. A green alert
e. A red alert
An error message that begins with a number sign (#)
The Excel tool button that allows you to step through each part of a formula is called:
a. Trace Precedents
b. Trace Dependents
c. Error Checking
d. Evaluate Formula
e. Watch Window
Evaluate Formula
When you are creating formulas using a cell location, the default cell reference is:
a. Relative
b. Absolute
c. Constant
d. Fixed
e. Mixed
Relative
This type of cell reference does not change when copied and remains in a fixed position during operations:
a. Relative
b. Absolute
c. Constant
d. Fixed
e. Mixed
Absolute
a handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding the dollar sign ($) in front of the column and row addresses, is:
a. F1
b. F5
c. ^$
d. Ctrl+*
e. F4
F4
It is important to remember that Excel calculates these operations before any others are performed:
a. Exponents
b. Items in parentheses
c. Mathematical expressions
d. Fixed cell references
e. Mixed cell references
Items in parenthesis
Excel comes with many built-in formulas called:
a. Formulas
b. Factors
c. Functions
d. Operations
e. Calculations
Functions
This Excel feature allows you to view totals, averages, or other statistical information without creating a formula:
a. AutoCalculate
b. AutoSum
c. AutoCount
d. AutoFunction
e. AutoRun
AutoCalculate
This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate:
a. STDEV
b. AMORLINK
c. PMT
d. PERLOAN
e. PAYPCT
PMT
This useful Excel function evaluates a specified condition or statement and returns one value if the condition or statement is true and another value if it is false:
a. COUNT
b. LOOKUP
c. HLOOKUP
d. IF
e. EVAL
IF
To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:
a. 3D cell reference
b. Link
c. LOOKUP
d. Relative cell reference
e. FINDIF
3D cell reference
Sets found in the same folder
CGS EXAM 1 REVIEW CH 1
10 terms
CGS EXAM 1 REVIEW CH 3
10 terms
CGS EXAM 1 REVIEW CH 6
9 terms
Other sets by this creator
FL RE Sales Associate # of Days Questions
33 terms
FL RE Sales Associate Flashcards
352 terms
FL RE Sales Associate Flashcards
37 terms
Seneff Exam 2
26 terms
Other Quizlet sets
Psych 410 exam 2
72 terms
Christ Civ
18 terms
qwqwdq
565 terms