Exam (elaborations)
MIS112 with questions Solved 100% Correct
- Course
- Institution
MIS112 with questions Solved 100% Correct
[Show more]
Seller
Follow
Content preview
MIS112 with questions Solved 100% CorrectWhich of the following options provides correct syntax for the LOOKUP function? -
Answer LOOKUP(lookup_value,lookup_vector,[result_vector])
dataLOOKUP_Ex1.xlsx Please see the attached workbook. Which LOOKUP function
would be used in order to get the Tax Rate (in cell B3) for the entered income (in B2)? -
Answer VLOOKUP
dataLookup_eg1.xlsx Please see the attached workbook. The worksheet contains a table
of student data (starting in row 13) named as "Students". If you were to use a lookup
formula to get the exact value for salary field in row 2, which of the following formulas
would you use? - Answer =VLOOKUP(C2,Students,4,FALSE)
Which of the followings steps are to be followed in order to display the Go to
Special dialog box which is an Excel Auditing Tool?
Home -> Editing -> AutoSum
Home -> Cells -> Format
Home -> Styles -> Conditional Formatting
,Home -> Editing -> Find & Select -> Go to Special - Answer Home -> Editing -> Find
& Select -> Go to Special
Example_6.xlsx Please see the attached workbook. Row 5 is hidden and contains a word
in cell A5. What is the result of using the spell checker when the word is hidden? -
Answer Spell checker will be able to check the spelling of the word because the contents
of hidden rows and columns are checked.
The ________ function is one solution to account for for floating point number errors. It
also serves to round off values to the desired number of decimal places. -
Answer ROUND()
What does it mean when Excel displays the following error? #DIV/0! - Answer A number
is divided by zero!
Example_3.xlsx Please see the attached workbook. The formula in cell C4 is "=B4 + (B4
* $C$1)". Formulas in range C4:C7 use a / an _________ reference to cell C1. - Answer
absolute
When do you get a "#NAME?" error value? - Answer Text in a formula is not enclosed in
quotation marks
datavalidation.xlsx Please see the attached workbook. In the Student Rank table, notice
that H15 and H19 have the same value. Since two students cannot have the same
student ID, what formula would you use in the Data validation settings in this case to
make sure duplicate entries are not allowed? - Answer =COUNTIF($H$13:$H$19,H19)=1
Which of the following options, when used as a formula in the Custom Data
Validation criteria for cell A1, will ensure that the entry in cell A1 is an odd number? -
Answer =ISODD(A1)
, What is the purpose of the Text to Columns command? - Answer It parses strings
into their component parts.
What function removes leading and trailing spaces from a cell? - Answer TRIM
external_ex1.xlsx Please use the attached workbook as an external data source. The
workbook has a table called 'Employee'. When you import data, after selecting all the
columns from the table using the query wizard (Data(tab) -> Get External Data (group) -
> From Other Sources -> From Microsoft Query), how will you filter the records to
retrieve those that have a value greater than 21 for 'Age' column. - Answer From the
Column to Filter list, select Age. In the right panel, select 'is greater than' from the
first drop-down list and then select '21.0' from the second drop-down list
The HYPERLINK function syntax has two arguments. Which argument has the path
and file name to the document to be opened? - Answer Link_location
If you place the link target in cell C1 on the same worksheet, how will you use an
absolute reference to that cell as the link_location in the HYPERLINK formulas? -
Answer =HYPERLINK($C$1)
In Step 2 of the Query Wizard, you specify which data rows should be included in your
query output. How is the criteria entered? - Answer a criterion for each column
When working with data returned from a Query Wizard, refreshing a query occasionally
produces undesired results. If this occurs, you can use the _____ button to reverse the
change. In other words to "un-refresh" the data. - Answer Undo
To create a single file web page, what file format does a user have to select from the
Save as Type drop-down list? - Answer Single File Web Page
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 $13.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
84146 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now