©THEBRIGHT 2024
MIS 112 Exam Questions With Correct
Answers.
You ask your customers to provide you with inventory usage data to help you plan your
production schedule. which of the following file formats will you ask them to provide in (so that
data can be easily immported into Excel?)
a) Microsoft Word
b) XML
c) microsoft power point
d) PDF - answer✔✔XML
When importing a text file into Excel, the ______ helps specify how the data will be imported.
a) Text Import Wizard
b) External Data Wizard
c) CSV Wizard
d) Text Preview Panel - answer✔✔CSV Wizard
The HYPERLINK function syntax has two arguments. Which argument has the jump text or
numeric value that is displayed in the cell?
a) Friendly_name
b)Link_location
c) Name
D) File - answer✔✔Friendly_name
, ©THEBRIGHT 2024
What formula displays the value of B5 stored in a file named "example.xslx" in a different
directory called "TEST" in the "C:/" drive?
a) =HYPERLINK("C:\TEST\example.xslx"B5)
B) =HYPERLINK("C:\TEST\example",BC)
=HYPERLINK("C:\TEST\example.xslx",B5) -
answer✔✔=HYPERLINK("C:\TEST\example.xslx",B5)
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.
a) Unrefresh
b) Cycle
c) Undo
d) Cancel - answer✔✔Undo
In Step 2 of the Query Wizard, you specify which data rows should be included in your query
output. How is the criteria entered?
a) a criterion for each column
b) you drag and drop the rows you want
c) you use a checkbox to pick criteria
d) criteria are automatically copied from cell $A$! of your current workbook sheet. -
answer✔✔A criterion for each column
To open an HTMML file stored on a Web server using Excel, what needs to be done?
a) Copy the URL and paste it into the Name Field in Open dialog box.
b) Excel cant open an HTML file stored on a Web server.
c) Type the name of the hTML file in the Name Field in the Open dialog box
d) Choose File --- Open -- Get External Data -- from web - answer✔✔Copy the URL and paste it
into the Name Field in Open dialog box.
MIS 112 Exam Questions With Correct
Answers.
You ask your customers to provide you with inventory usage data to help you plan your
production schedule. which of the following file formats will you ask them to provide in (so that
data can be easily immported into Excel?)
a) Microsoft Word
b) XML
c) microsoft power point
d) PDF - answer✔✔XML
When importing a text file into Excel, the ______ helps specify how the data will be imported.
a) Text Import Wizard
b) External Data Wizard
c) CSV Wizard
d) Text Preview Panel - answer✔✔CSV Wizard
The HYPERLINK function syntax has two arguments. Which argument has the jump text or
numeric value that is displayed in the cell?
a) Friendly_name
b)Link_location
c) Name
D) File - answer✔✔Friendly_name
, ©THEBRIGHT 2024
What formula displays the value of B5 stored in a file named "example.xslx" in a different
directory called "TEST" in the "C:/" drive?
a) =HYPERLINK("C:\TEST\example.xslx"B5)
B) =HYPERLINK("C:\TEST\example",BC)
=HYPERLINK("C:\TEST\example.xslx",B5) -
answer✔✔=HYPERLINK("C:\TEST\example.xslx",B5)
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.
a) Unrefresh
b) Cycle
c) Undo
d) Cancel - answer✔✔Undo
In Step 2 of the Query Wizard, you specify which data rows should be included in your query
output. How is the criteria entered?
a) a criterion for each column
b) you drag and drop the rows you want
c) you use a checkbox to pick criteria
d) criteria are automatically copied from cell $A$! of your current workbook sheet. -
answer✔✔A criterion for each column
To open an HTMML file stored on a Web server using Excel, what needs to be done?
a) Copy the URL and paste it into the Name Field in Open dialog box.
b) Excel cant open an HTML file stored on a Web server.
c) Type the name of the hTML file in the Name Field in the Open dialog box
d) Choose File --- Open -- Get External Data -- from web - answer✔✔Copy the URL and paste it
into the Name Field in Open dialog box.
