Exam (elaborations)
OMIS 259 Final Exam with Questions 100% Solved |Latest Update| Verified Answers
- Course
- Institution
OMIS 259 Final Exam with Questions 100% Solved |Latest Update| Verified Answers
[Show more]
Seller
Follow
Content preview
OMIS 259 Final Exam with Questions 100%Solved |Latest Update| Verified Answers
What is an Excel column heading in Access? - ✔ANS Field
What is an Excel row in Access? - ✔ANS Record
What is an Excel spreadsheet in Access? - ✔ANS Table
A PivotChart is ________. - ✔ANS Just like a regular chart, only done using a PivotTable for the
chart information (it also automatically includes Filtering).
A Data Table can be used to... - ✔ANS Easily compare the results of many different
variable values quickly.
A Two-variable Data Table must have the formula... - ✔ANS In the upper left cell of the table.
The most useful thing about Scenario Manager is... - ✔ANS The easy and nicely
formatted Summary Report.
, Goal Seek can be used to... - ✔ANS Allow you to "back into" a value to give you a
desired result in a single formula and/or cell.
Solver can be used to... - ✔ANS Allow you to let the computer change multiple certain cells
to find the best or desired value for a certain result.
To get the subtotals to work well (make sense, etc.), you MUST have... - ✔ANS sorted the
data first
Outlines and/or grouping can be useful for managers to... - ✔ANS View only the subtotals
and not all of the details
Hide or view certain things, using the collapse (-) and expand (+) options
Create colorful charts
If I wanted to make this PivotTable more readble for my manager, one good option would be: -
✔ANS Insert a Pivot Table
A calculated field is simply - ✔ANS A choice which appears (under 'Field, Items & Sets')
when your mouse is in the PivotTable which allows a user to create extra fields (columns)
using formulas.
Inserting a Linear Forecast Trendline will give you __________. - ✔ANS a line that predicts
trends based on the data in your chart, plus an additional two future forecast periods.
The best way to remove a page break is...? - ✔ANS To drag it completely off the page in
"Page Break Preview" in the View Tab.
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 KenAli. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
85169 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now