Exam (elaborations)
CGS 2518 Final Exam Study Guide with correct Answers
- Course
- Institution
CGS 2518 Final Exam Study Guide with correct Answers
[Show more]
Content preview
CGS 2518 Final Exam Study Guide withcorrect Answers
What is the name of the Seminole Indian leader that one selected FSU portrays at the
various FSU events? - Answers -Osceola
How many different FSU students have portrayed this famous Seminole? - Answers -16
What is the name of the horse that they ride? - Answers -Renegade
What is the breed of the horse? - Answers -Appaloosa
How many different horses have had this honor? - Answers -6
The lookup_value of a HLOOKUP function can be a contiguous cell range - Answers -
False
In a VLOOKUP formula with a TRUE lookup type, the first column of the lookup table
referenced must be in ascending order to retrieve the correct value - Answers -True
The result vector of a LOOKUP function must be sorted in ascending order - Answers -
True
Reference and lookup functions may not contain nested functions as arguments -
Answers -False
The default range-lookup type for the VLOOKUP and HLOOCKUP functions is true -
Answers -True
Excel matches the lookup-value "tom" with the entry "TOM" in a lookup value - Answers
–True
When should you use a PivotTable report to analyze data? - Answers -Interactive, used
to analyze a data set and summarize selected fields from a list or data from an external
source, such as a database.
List and describe the four areas of a PivotTable report. - Answers -Filters: filters data by
those values
Rows: displays data from that filed in rows
Columns: displays data from that field in columns
Values: the field that you want to summarize
, How is a PivotChart different from a normal chart in Excel? - Answers -You can change
the layout and data displayed in a PivotChart report by moving fields in addition to
changing the chart type.
List and describe the differences and similarities between HTML and XML. - Answers -
HTML is the markup language that creates web pages by embedding tags in the
document to describe the formatting. XML is used to transfer information between
different applications through a language that defines the structure and rules for
creating markup elements.
The row and column arguments in the INDEX function can be numeric values, Boolean
values, or text - Answers -False
The formula =INDEX((B2:D7,B12:D17,B22:D17),2,3,1) returns the value in cell D3 -
Answers -True
The formula =AVERAGE(CHOOSE(1,B12:D17,B22:D17),2,3,1) averages the value 1
with the values in cells B12 to D17 and B22 to D17 - Answers -False
The formula =MATCH(40,{10,20,40,50},0) returns the value of 3 - Answers -True
What happens when Excel is solving a HLOOKUP formula with a FALSE range_lookup
type and does not find an exact match in the lookup table? - Answers -#N/A
What is the difference between the LOOKUP function and the VLOOKUP or HLOOKUP
function? - Answers -VLOOKUP: Uses the leftmost column as the lookup vector
HLOOKUP: Uses the top row as the lookup vector
LOOKUP: Uses a specified column or row and is backwards compatible
Which Excel function should you use when you want to lookup a value from a two-
dimensional table, where both the columns and rows can be varied? - Answers -INDEX
Write a formula to choose the third day of the week from the list starting with Sunday,
Monday, Tuesday,...Saturday - Answers -
=CHOOSE(3,"SUNDAY","MONDAY","TUESDAY","WEDNESDAY","THURSDAY","FRID
AY","SATURDAY")
What function returns the relative position of an item from a list? - Answers -MATCH
Write a formula in cell C13 in the Pricing worksheet to determine the total cost of
making copies for this order (275 copies). Write a formula so that it works when copied
into cells C14:C15. - Answers -=VLOOKUP(B13,$B3:$C9,2,TRUE)*B13
Function to calculate the value at the end of a financial transaction? - Answers -FV
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 $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
62890 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now