Exam (elaborations)
CGS 2518 Exam 1 Armstrong (chapters 1, 2, 3, 7, & 8) Questions and Answers
- Course
- Institution
CGS 2518 Exam 1 Armstrong (chapters 1, 2, 3, 7, & 8) Questions and Answers
[Show more]
Content preview
CGS 2518 Exam 1 Armstrong (chapters1, 2, 3, 7, & 8) Questions and Answers
The recent documents list shows documents that have been previously... (ch. 1) -
Answers -opened
In Word or PowerPoint a quick way to select an entire paragraph is to... (ch. 1) -
Answers -triple-click inside the paragraph
When you want to copy the format of a selection but not the content, you should... (ch.
1) - Answers -click Format Painter in the Clipboard group
Which of the following is NOT a benefit of using OneDrive? (ch. 1) - Answers -hold
video conferences with others
What does a red wavy underline in a document, spreadsheet, or presentation mean?
(ch. 1) - Answers -A word is misspelled or not recognized by the Office dictionary
Which of the following is true about headers and footers? (ch. 1) - Answers -headers
appear at the top of every page in a document
Live Preview (ch. 1) - Answers -provides a preview of the results of a choice you are
considering before you make a final selection
You can get help when working with an Office application in which one of the following
areas? (ch. 1) - Answers -The "tell me what you want to do" box
A workbook contains sales information for the first quarter and you are interested in
finding the total sales generated in January by the sales rep Jim Anderson. What
function is best suited to handle the task? (ch. 8) - Answers -SUMIFS
What function would you use to identify a value's rank as a percent, excluding 0 and 1?
(ch. 8) - Answers -PERCENTRANK.EXC
What does a negative COVARIANCE indicate? (ch. 8) - Answers -an inverse
relationship between datasets
A worksheet contains sales dollars for agents with your company. The values are
$1,250, $1090, $985, $985, $880, $756, $675, $650, and $600. Using the RANK AVG
function that is considered a best practice, what is the rank of the third values which are
both 985? (ch. 8) - Answers -none of the above
, In Powerpoint, a file that includes formatting elements such as a background, a color
scheme, and slide layout is a... (ch. 1) - Answers -template
A document or worksheet printed in landscape orientation is... (ch. 1) - Answers -wider
than it is tall
If cell E15 contains the formula =$C$5*J$15, what type of cell reference is the J$15 in
the formula? (ch. 2) - Answers -mixed reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)/5? (ch. 2) - Answers -=AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined
names? (ch. 2) - Answers -Formula AutoComplete
A formula containing the entry =$B3 is copied to a cell one column to the right and two
rows down. How will the entry appear in its new location? (ch. 2) - Answers -=$B5
Which of the following functions should be used to insert the current date and time in a
cell? (ch. 2) - Answers -=NOW()
Which of the following is not an argument of the IF function? (ch. 2) - Answers -
lookup_value
Which of the following is NOT true about the VLOOKUP function? (ch. 2) - Answers -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?
(ch. 2) - Answers -periodic interest rate
Which of the following is NOT an appropriate use of the SUM function? (ch. 2) -
Answers -=SUM(D15-C15)
What is the keyboard shortcut to create an absolute reference? (ch. 2) - Answers -F4
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years? (ch. 3) - Answers -pie chart
Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the
category axis? (ch. 3) - Answers -CIS managers
Which of the following is not a type of sparkline? (ch. 3) - Answers -bar
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