BUSI 520 QUESTIONS AND ANSWERS
Cells formatted with Accounting format can be aligned within a cell using which
formats? - Answers - Right aligned
Solver inserts values in the changing cells until the value of the _____ cell has reached
the specified goal. - Answers - objective
Macro viruses are viruses written and stored as macros attached to Office documents
and run when opened. - Answers - True
With relational operators and text values, a greater value appears earlier in the
alphabet. - Answers - False
For the formula =3+7=10, the resulting value is _____. - Answers - TRUE
It's okay to hard-code text phrases in IF functions and conditional formatting. - Answers
- False
In financial functions, an argument Type of _____ indicates payments are made at the
end of each period. - Answers - 0
PMT should include lump sum + payments when calculating FV with beginning lump
sum and payments. - Answers - False
If one OR argument is TRUE and the other FALSE, the result is _____. - Answers -
TRUE
If the Type argument is blank in financial functions, payments are assumed at end of
period. - Answers - True
Changing payments per year affects compounding frequency. - Answers - True
Use exact match lookup for values within ranges in VLOOKUP - Answers - HLOOKUP. /
False
Constraints define the feasible solution area. - Answers - True
The function that returns a date a number of months before - Answers - after a start
date is _____. / EDATE
Once a scenario is created, changing cells cannot be edited. - Answers - False
Solver is limited to one input and one outcome. - Answers - False
, Cash paid out is considered a _____ cash flow. - Answers - negative
Shortcut to show - Answers - hide ribbon: / Ctrl+F1
Shortcut to insert current time: - Answers - Ctrl+Shift+:
The average of a set of numbers is _____. - Answers - Mean
Shortcut to toggle formulas and values: - Answers - Ctrl+`
Quick Access Toolbar shortcut can apply Accounting format. - Answers - True
########## error indicates _____. - Answers - cell too narrow
Shortcut to insert cells: - Answers - Ctrl+Shift+plus
A table used to categorize values for retrieval is a _____ table. - Answers - lookup
If date subtraction shows as a date, fix by _____. - Answers - format as General
AND returns FALSE if either condition is _____. - Answers - FALSE
End of record in CSV file is marked by _____. - Answers - paragraph mark
Format formula cells same as input cells for consistency. - Answers - False
Count "A" grades formula: - Answers - =COUNTIFS(C3:C100,"A")
=A1-B2+C3 - Answers - 10 result (2,3,10): / 0
Freeze rows at top: - Answers - use Freeze Panes
Multiple constraints can be entered as a range. - Answers - True
Test macro step-by-step using: - Answers - Step Into
CSV files preserve formulas - Answers - formatting. / False
Fill down shortcut: - Answers - Ctrl+d
F2 toggles edit - Answers - selection mode. / True
=AND(F3,NOT(OR(G3:H3))) is a(n) ____ construct. - Answers - "Only"
The "V" in VLOOKUP stands for _____. - Answers - Vertical
Cells formatted with Accounting format can be aligned within a cell using which
formats? - Answers - Right aligned
Solver inserts values in the changing cells until the value of the _____ cell has reached
the specified goal. - Answers - objective
Macro viruses are viruses written and stored as macros attached to Office documents
and run when opened. - Answers - True
With relational operators and text values, a greater value appears earlier in the
alphabet. - Answers - False
For the formula =3+7=10, the resulting value is _____. - Answers - TRUE
It's okay to hard-code text phrases in IF functions and conditional formatting. - Answers
- False
In financial functions, an argument Type of _____ indicates payments are made at the
end of each period. - Answers - 0
PMT should include lump sum + payments when calculating FV with beginning lump
sum and payments. - Answers - False
If one OR argument is TRUE and the other FALSE, the result is _____. - Answers -
TRUE
If the Type argument is blank in financial functions, payments are assumed at end of
period. - Answers - True
Changing payments per year affects compounding frequency. - Answers - True
Use exact match lookup for values within ranges in VLOOKUP - Answers - HLOOKUP. /
False
Constraints define the feasible solution area. - Answers - True
The function that returns a date a number of months before - Answers - after a start
date is _____. / EDATE
Once a scenario is created, changing cells cannot be edited. - Answers - False
Solver is limited to one input and one outcome. - Answers - False
, Cash paid out is considered a _____ cash flow. - Answers - negative
Shortcut to show - Answers - hide ribbon: / Ctrl+F1
Shortcut to insert current time: - Answers - Ctrl+Shift+:
The average of a set of numbers is _____. - Answers - Mean
Shortcut to toggle formulas and values: - Answers - Ctrl+`
Quick Access Toolbar shortcut can apply Accounting format. - Answers - True
########## error indicates _____. - Answers - cell too narrow
Shortcut to insert cells: - Answers - Ctrl+Shift+plus
A table used to categorize values for retrieval is a _____ table. - Answers - lookup
If date subtraction shows as a date, fix by _____. - Answers - format as General
AND returns FALSE if either condition is _____. - Answers - FALSE
End of record in CSV file is marked by _____. - Answers - paragraph mark
Format formula cells same as input cells for consistency. - Answers - False
Count "A" grades formula: - Answers - =COUNTIFS(C3:C100,"A")
=A1-B2+C3 - Answers - 10 result (2,3,10): / 0
Freeze rows at top: - Answers - use Freeze Panes
Multiple constraints can be entered as a range. - Answers - True
Test macro step-by-step using: - Answers - Step Into
CSV files preserve formulas - Answers - formatting. / False
Fill down shortcut: - Answers - Ctrl+d
F2 toggles edit - Answers - selection mode. / True
=AND(F3,NOT(OR(G3:H3))) is a(n) ____ construct. - Answers - "Only"
The "V" in VLOOKUP stands for _____. - Answers - Vertical
