Exam (elaborations)
MIS 3300 Test 2 Questions with Correct Answers.
- Course
- Institution
MIS 3300 Test 2 Questions with Correct Answers.
[Show more]
Content preview
MIS 3300 Test 2 Questions with Correct AnswersIn Excel, a collection of similar data can be structured in a(n) ____ of
rows and columns. Correct Answer-range
A data ____ table describes the fields you plan to maintain in a table.
Correct Answer-definition
____ order arranges labels in alphabetical order, from A to Z. Correct
Answer-Ascending
The fields you use to order your data are called sort ____. Correct
Answer-fields
The ____ condition requires that all of the selected criteria be true for
the record to be displayed. Correct Answer-AND
The ____ criteria filter requires the records displayed to start with the
specified text string. Correct Answer-begins with
The ____ criteria filter requires the records displayed to have the
specified text string anywhere. Correct Answer-contains
The ____ criteria filter requires the records displayed to be greater than
or equal to and less than or equal to the specified numbers. Correct
Answer-between
, You can split the worksheet window into ____ separate panes. Correct
Answer-two or four
To calculate subtotal for a table, the first step is to use the ____ button
on the Table Tools Design tab. Correct Answer-convert to range
By default, the PivotTable report uses the ____ function for numbers in
the Values area. Correct Answer-SUM
Every ____ consists of an object that contains a button for each unique
value in that field. Correct Answer-slicer
A worksheet ____ is a collection of two or more selected worksheets.
Correct Answer-group
Like cell ____, a worksheet group can contain adjacent or nonadjacent
sheets. Correct Answer-ranges
When you reference a cell or range in a different worksheet, the ____
separates the sheet reference from the cell reference. Correct Answer-!
Which of the following is NOT an option for arranging your workbooks
Correct Answer-lateral
You can create a(n) ____ reference by deleting the $ from the row
reference in the cell reference $B$6. Correct Answer-mixed
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 cracker. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73773 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now