Excel Accounting Crash WALL STREET Retake
Exam FALL SEMESTER GRADED A+
A table can be created only if data has already been entered in a list within Excel -
ANSWER: False
T/F: Excel tables allow calculated columns and filtering - ANSWER: True
T/F:A table can include both a header row and a total row - ANSWER: True
T/F: Table column headings can include any special characters, such as the pound
sign or brackets - ANSWER: False
T/F: The factor variable in a double-declining balance function is optional - ANSWER:
True
T/F: A structured reference is one that uses standard cell references, such as A1 -
ANSWER: False
T/F: A structured reference includes both brackets and the at symbol (@) - ANSWER:
True
T/F: Autofilter buttons allow you to sort and filter data in a table - ANSWER: True
T/F: Records in a table that do not meet applied filtering criteria are hidden from
view - ANSWER: True
T/F: The quick analysis button provides access to features not included on the ribbon
- ANSWER: False
Features specific to tables include each of these EXCEPT:
a. calculated columns
b. depreciated functions
c. table styles
d. automatic expansion - ANSWER: Depreciation functions
Which special character can be used in a table header? - ANSWER: Dollar sign ($)
Which of these is NOT an accelerated depreciation method?
a. SYD
b. straight line
c. DDB
d. triple declining balance - ANSWER: Straight-line depreciation
Which of these is NOT a table style option available on the ribbon?
a. total row
, b. banded columns
c. calculated rows
d. header row - ANSWER: Calculated rows
When the right-most cell of the last data row in a able is active, tapping ______
creates a new row at the bottom of the table - ANSWER: [Tab]
The table styles option appears under the ___ tab of the ribbon - ANSWER: Design
Which of these is NOT required when using depreciation functions (SLN, SYD, or
DDB)
a. factor
b. useful life
c. salvage value
d. cost - ANSWER: Factor
Structured references allow formulas to adjust automatically when each of these
actions EXCEPT ____ is taken
a. deleting columns
b. editing column headings
c. renaming tables
d. deleting tables - ANSWER: d. deleting tables
what autofilter button image indicates that a list is sorted from lowest to highest? -
ANSWER: An up arrow
Which of these is NOT available via the quick analysis button menu? - ANSWER:
Alignment
T/F: The round function requires the insertion of two arguments in a formula -
ANSWER: True
T/F: The logical_test must be entered as the first argument in an IF function -
ANSWER: true
T/F: The Value_if_false argument is optional in the IF function - ANSWER: false
T/F: A nested IF function contains at least two standard IF functions - ANSWER: True
T/F: when a formula is copied, any absolute cell reference in it will change based on
the distance between the original and the copied formula - ANSWER: false
T/F: A mixed cell reference contains a dollar sign in front of the column or row
reference, but not both - ANSWER: true
T/F: you can use [F4] to toggle the dollar sign in front of one, both, or no column/row
references in a cell reference - ANSWER: true
Exam FALL SEMESTER GRADED A+
A table can be created only if data has already been entered in a list within Excel -
ANSWER: False
T/F: Excel tables allow calculated columns and filtering - ANSWER: True
T/F:A table can include both a header row and a total row - ANSWER: True
T/F: Table column headings can include any special characters, such as the pound
sign or brackets - ANSWER: False
T/F: The factor variable in a double-declining balance function is optional - ANSWER:
True
T/F: A structured reference is one that uses standard cell references, such as A1 -
ANSWER: False
T/F: A structured reference includes both brackets and the at symbol (@) - ANSWER:
True
T/F: Autofilter buttons allow you to sort and filter data in a table - ANSWER: True
T/F: Records in a table that do not meet applied filtering criteria are hidden from
view - ANSWER: True
T/F: The quick analysis button provides access to features not included on the ribbon
- ANSWER: False
Features specific to tables include each of these EXCEPT:
a. calculated columns
b. depreciated functions
c. table styles
d. automatic expansion - ANSWER: Depreciation functions
Which special character can be used in a table header? - ANSWER: Dollar sign ($)
Which of these is NOT an accelerated depreciation method?
a. SYD
b. straight line
c. DDB
d. triple declining balance - ANSWER: Straight-line depreciation
Which of these is NOT a table style option available on the ribbon?
a. total row
, b. banded columns
c. calculated rows
d. header row - ANSWER: Calculated rows
When the right-most cell of the last data row in a able is active, tapping ______
creates a new row at the bottom of the table - ANSWER: [Tab]
The table styles option appears under the ___ tab of the ribbon - ANSWER: Design
Which of these is NOT required when using depreciation functions (SLN, SYD, or
DDB)
a. factor
b. useful life
c. salvage value
d. cost - ANSWER: Factor
Structured references allow formulas to adjust automatically when each of these
actions EXCEPT ____ is taken
a. deleting columns
b. editing column headings
c. renaming tables
d. deleting tables - ANSWER: d. deleting tables
what autofilter button image indicates that a list is sorted from lowest to highest? -
ANSWER: An up arrow
Which of these is NOT available via the quick analysis button menu? - ANSWER:
Alignment
T/F: The round function requires the insertion of two arguments in a formula -
ANSWER: True
T/F: The logical_test must be entered as the first argument in an IF function -
ANSWER: true
T/F: The Value_if_false argument is optional in the IF function - ANSWER: false
T/F: A nested IF function contains at least two standard IF functions - ANSWER: True
T/F: when a formula is copied, any absolute cell reference in it will change based on
the distance between the original and the copied formula - ANSWER: false
T/F: A mixed cell reference contains a dollar sign in front of the column or row
reference, but not both - ANSWER: true
T/F: you can use [F4] to toggle the dollar sign in front of one, both, or no column/row
references in a cell reference - ANSWER: true
