Exam (elaborations)
MIS112 with questions Solved 100% Correct
- Course
- Institution
MIS112 with questions Solved 100% Correct
[Show more]
Content preview
MIS112 with questions Solved 100% CorrectWhat does the following formula return? =CHAR(68) - Answer D
Which of the following entries does Excel automatically recognize as a date (using the
U.S. settings)? - Answer None of the answers provided is correct
In Excel, if one enters a time greater than ten thousand hours, it is interpreted as
________ instead of a time value. - Answer a text string
If you want to apply a date format to serial numbers, which of the following choices will
work for you? Assume you have already done the following steps: selected a cell with
the serial number, gone to the Home tab, within that the Number group, clicked the
drop-down arrow in the Number format box) - Answer All of the options provided will
work
Which of the following is TRUE about the DATEDIF() function? - Answer You must enter
it manually
When you activate a cell that contains a date, the formula bar usually shows the cell
contents formatted using the following date format: - Answer None of the answers
provided is correct
To find a working date that falls after a number of days (e.g., 12 business days after
some date), you typically use this function: - Answer WORKDAY()
To get rid of ALL blank spaces in a string (e.g., in "Jo hn Doe "), which Excel function will
you use? - Answer =SUBSTITUTE()
,The _____________ function is used to return a specified number of letters or
characters from the end of a text string. - Answer RIGHT()
To eliminate redundant blank space from the start or end of a string (e.g., " Tucson "),
which Excel function will you use? - Answer =TRIM()
If cell A1 contained the text MR. JOHN Q. PUBLIC, what would the formula
(=PROPER(A1)) return? - Answer Mr. John Q. Public
If a pivot chart is created and the underlying table is deleted, what occurs? - Answer The
pivot chart remains.
Which of the following is one of the ways to create a Pivot Chart? - Answer Insert (tab) -
> Charts (group) -> PivotChart
Examine the attached workbook. The data represents the amount of money a customer
has spent, in a quarter, to buy a product. Create a PivotTable based on the (entire) table
of data in the Sales worksheet. For Row Labels, choose the Product column. Include
Columns C, D, E and F in the Values-area. What is the total revenue (sales in dollars)
generated in Qtr 4 for the Products 'Aniseed Syrup', 'Boston Crab Meat' and
'Camembert Pierrot'?
Pivot_table_test.xlsx - Answer 5156
Ex3.xlsx Please refer to the attached workbook. The ______ , ________ and
________fields are in the Column, Rows and Values section respectively. - Answer
AcctType, branch, count of amount
How do you remove a filter in the PivotTable Field List? - Answer Move the cursor over
the filter icon next to the field name you want to remove the filter from. Click the arrow
that appears, and then choose the Clear Filter From option.
, To remove a single individual field from a report, _______ the check box beside the field
name in the PivotTable Field List. - Answer clear
When do you use the following sequence of commands: PivotTable Tools -> Analyze ->
PivotTable -> Options -> Generate GetPivot Data? - Answer prevent Excel from using
GETPIVOTDATA function
When you create a PivotTable report, each column of your source data becomes a
_____ that you can use in the report. - Answer field
A calculated field must reside in the ________ area of the pivot table. - Answer Values
What is Not the purpose of using Slicers? - Answer Make table more beautiful
When the value of a cell is changed (after conditional formatting is applied), the cell
formatting ______ based on the conditions set. - Answer is updated
Which of the following is NOT one of the methods for 'Conditional Formatting' in Excel?
- Answer Pie Chart
In the following choices, which one is not among the drop-down list of the conditional
formatting on the ribbon? - Answer Number bars
Assume the "range_lookup" parameter in an HLOOKUP function is FALSE. If an exact
match is not found, what value is returned? - Answer #N/A
dataLOOKUP_Ex2.xlsx Please see the attached workbook. What formula (in cell B3)
would return the tax rate for the income in cell B2? - Answer =HLOOKUP(B2, E1:J3, 3)
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 Examsplug. 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)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now