MIS 111 Lab Exam Questions with
All Correct Answers
There are two options if you want to save an Excel workbook, so that it can be viewed
on the World Wide Web. What are the two options? - Answer-An HTML file and a
single-file web page
The last step in the Query Wizard, "Finish", lets you do which of the following? -
Answer-Save a query so that you can reuse it
Which of the following can be retrieved from a web page using web queries? - Answer-
data in a table
Which one of the following is NOT a formatting option in the Web Query Options dialog
box? - Answer-XML formatting
The HYPERLINK function syntax has two arguments. Which argument has the jump
text or numeric value that is displayed in the cell? - Answer-Friendly_name
Which function is used to create a shortcut that opens a document stored on a network
server, an intranet, or the Internet? - Answer-HYPERLINK()
A pivote table calculated field consists of a calculation that involves other _______. -
Answer-fields
Which of the following statements is FALSE? - Answer-A pivot chart is always based on
a pivot table, i.e., changes to the pivot chart must be made by changing the underlying
table
Which of the following is one of the ways to create a Pivot Chart? - Answer-Insert (tab) -
> Charts (group) -> PivotChart
Please refer to the attached workbook. The ______ , ________ and ________fields are
in the Column, Rows and Values sections respectively. - Answer-branch, date and
amount
Which of the following is FALSE about Pivot Table Slicers? - Answer-None of the
answers provided is false
The function of value filter in a pivot table is to ___________. - Answer-read the data
and select those rows with cells that match your criteria
, What is one of the DRAWBACKS of using a pivot table? - Answer-A Pivot Table does
not update automatically when information changes in source data
When do you use the following sequence of commands: PivotTable Tools -> Analyze ->
PivotTable -> Options -> Generate GetPivot Data? - Answer-prevent Excel from using
GETPIVOTDATA function
What function helps ensure that the formula will continue to reference the intended cells
if the pivot table layout is changed? - Answer-GETPIVOTDATA
Please refer to the attached workbook. What happens if the following value filter is
added to the existing report? Value filter: Sum of Sales does not equal 5000. - Answer-
Nothing happens. Both the records remain.
What is the primary purpose of "Protected View?" - Answer-Protect you from malware
Which of the following is the keyboard shortcut that creates a new blank workbook in
Excel? - Answer-Ctrl + N
Which keyboard shortcuts can be used to move the active cell one colunn to the left? -
Answer-Left arrow or Shift + Tab
You enter "(500)" into an unformatted cell in an Excel worksheet (without quotation
marks). Which of the following will be generated by your entry? - Answer-a negative
number
Which of the following formulas will display both the current date and time when entered
into a cell in an Excel worksheet? - Answer-= NOW()
Which of the following procedures will NOT close your Excel workbook? - Answer-Ctrl +
S
Which of the following is the file format of the Excel 97-2003 workbook? - Answer-.xls
Which of the following keyboard shortcuts will add the current time to a cell in an Excel
worksheet? - Answer-Ctrl + Shift + :
Which of the following is NOT a state an Excel workbook can be in? - Answer-expanded
A chart in an Excel worksheet provides a visual representation of which of the
following? - Answer-numeric values
Must a chart be embedded in the same worksheet as its data source? - Answer-No, a
chart an be embedded or placed in a sheet separate from that of its data source.
All Correct Answers
There are two options if you want to save an Excel workbook, so that it can be viewed
on the World Wide Web. What are the two options? - Answer-An HTML file and a
single-file web page
The last step in the Query Wizard, "Finish", lets you do which of the following? -
Answer-Save a query so that you can reuse it
Which of the following can be retrieved from a web page using web queries? - Answer-
data in a table
Which one of the following is NOT a formatting option in the Web Query Options dialog
box? - Answer-XML formatting
The HYPERLINK function syntax has two arguments. Which argument has the jump
text or numeric value that is displayed in the cell? - Answer-Friendly_name
Which function is used to create a shortcut that opens a document stored on a network
server, an intranet, or the Internet? - Answer-HYPERLINK()
A pivote table calculated field consists of a calculation that involves other _______. -
Answer-fields
Which of the following statements is FALSE? - Answer-A pivot chart is always based on
a pivot table, i.e., changes to the pivot chart must be made by changing the underlying
table
Which of the following is one of the ways to create a Pivot Chart? - Answer-Insert (tab) -
> Charts (group) -> PivotChart
Please refer to the attached workbook. The ______ , ________ and ________fields are
in the Column, Rows and Values sections respectively. - Answer-branch, date and
amount
Which of the following is FALSE about Pivot Table Slicers? - Answer-None of the
answers provided is false
The function of value filter in a pivot table is to ___________. - Answer-read the data
and select those rows with cells that match your criteria
, What is one of the DRAWBACKS of using a pivot table? - Answer-A Pivot Table does
not update automatically when information changes in source data
When do you use the following sequence of commands: PivotTable Tools -> Analyze ->
PivotTable -> Options -> Generate GetPivot Data? - Answer-prevent Excel from using
GETPIVOTDATA function
What function helps ensure that the formula will continue to reference the intended cells
if the pivot table layout is changed? - Answer-GETPIVOTDATA
Please refer to the attached workbook. What happens if the following value filter is
added to the existing report? Value filter: Sum of Sales does not equal 5000. - Answer-
Nothing happens. Both the records remain.
What is the primary purpose of "Protected View?" - Answer-Protect you from malware
Which of the following is the keyboard shortcut that creates a new blank workbook in
Excel? - Answer-Ctrl + N
Which keyboard shortcuts can be used to move the active cell one colunn to the left? -
Answer-Left arrow or Shift + Tab
You enter "(500)" into an unformatted cell in an Excel worksheet (without quotation
marks). Which of the following will be generated by your entry? - Answer-a negative
number
Which of the following formulas will display both the current date and time when entered
into a cell in an Excel worksheet? - Answer-= NOW()
Which of the following procedures will NOT close your Excel workbook? - Answer-Ctrl +
S
Which of the following is the file format of the Excel 97-2003 workbook? - Answer-.xls
Which of the following keyboard shortcuts will add the current time to a cell in an Excel
worksheet? - Answer-Ctrl + Shift + :
Which of the following is NOT a state an Excel workbook can be in? - Answer-expanded
A chart in an Excel worksheet provides a visual representation of which of the
following? - Answer-numeric values
Must a chart be embedded in the same worksheet as its data source? - Answer-No, a
chart an be embedded or placed in a sheet separate from that of its data source.
