Exam (elaborations)
CGS 2518 FSU exam 1 with correct answers
- Course
- Institution
CGS 2518 FSU exam 1 with correct answers
[Show more]
Content preview
CGS 2518 FSU exam 1 with correctanswers
If cell E15 contains the formula =$C$5*J$15, what type of cell reference is the J$15 in
the formula?
(a) Relative Reference
(b) Absolute Reference
(c) Mixed Reference
(d) Syntax - Answers -(c) Mixed Reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)/5?
(a) =SUM(B5:F5)/5
(b) =AVERAGE(B5:F5)
(c) =MEDIAN(B5:F5)
(d) =COUNT(B5:F5) - Answers -b) =AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined
names?
(a) Function ScreenTip
(b) Formula AutoComplete
(c) Insert Function dialog box
(d) Functions Arguments dialog box - Answers -(b) Formula AutoComplete
A formula containing the entry =$B3 is copied down to a cell one column to the right and
two rows down. How will the entry appear in its new location?
(a) =$B3
(b) =B3
(c) =$C5
(d) =$B5 - Answers -(d) =$B5
Which of the following functions should be used to insert the current date and time in a
cell?
(a) =TODAY()
(b) =CURRENT()
(c) =NOW()
, (d) =DATE - Answers -(c) =NOW()
You have a workbook that contains sales data for different regional sales reps of a
company. Which task is the least like to be done while the worksheets are grouped?
(a) Fill the sales categories across the worksheets.
(b) Format the column and row labels at the same time.
(c) Enter specific values for the first sales rep.
(d) Format the values with an appropriate number style. - Answers -(c) Enter specific
values for the first sales rep.
Your manager sent you a workbook that contains data validation rules. One rule
specifies a maximum value of 15% with a warning alert. You try to enter 22% in that
cell. What happens?
(a) Excel enters the 22% with no message boxes.
(b) Excel enters the 22% and provides message box to inform you that your entry
violates the validation rule.
(c) Excel displays a message box and prevents you from entering 22%.
(d) Excel displays a message box informing you the value is above the maximum value
and lets you choose to go ahead and enter that value or a different value. - Answers -(d)
Excel displays a message box informing you the value is above the maximum value and
lets you choose to go ahead and enter that value or a different value.
Which of the following is not an argument of the IF function?
(a) value_if_true
(b) value_if_false
(c) logical_test
(d) lookup_value - Answers -(d) lookup_value
Which of the following is not true about the VLOOKUP function?
(a) the lookup table much be in ascending order
(b) the lookup table must be in descending order
(c) the default match type is appropriate
(d) the match type must be false when completing an exact match - Answers -(b) the
lookup table must be in descending order
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?
(a) APR
(b) Periodic interest rate
(c) Loan amount
(d) Number of payment periods - Answers -(b) Periodic interest rate
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller millyphilip. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
60281 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now