MIS112 with questions Solved 100% Correct
Which 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
Which 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
