©THEBRIGHT 2024
MIS 111 Lab Exam Questions With Correct
Answers
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.
Which of the following is the difference between a Pie and Doughnut chart in Excel? -
answer✔✔a doughnut chart can display more than one series of data
What are the minimum and maximum zoom ranges that can be displayed in an open Excel
worksheet (respectively)? - answer✔✔10%, 400%
, ©THEBRIGHT 2024
A single element in a worksheet that can hold a value, some text, or a formula is referred to as
which of the following? - answer✔✔cell
Which of the following types (chart types) is a VALID option in the Charts ribbon group on the
Insert ribbon tab? - answer✔✔all of the options provided are valid
Charts are dynamic, e.g., they change as the underlying data changes. Is this an accurate
statement? - answer✔✔Yes, by default they are dynamic.
Which of the following best describes what a Sparkline is? - answer✔✔a mini-chart that is
displayed in a single cell
An Excel workbook can contain one or more of which of the following? - answer✔✔worksheets
Examine the attached workbook. To create a duplicate copy of a chart (on same Excel
worksheet, but different location), you can activate the chart and take what action? -
answer✔✔hold the "Ctrl" key while dragging the chart to the new location
Which two wildcard characters are supported by the "Find and Replace" dialog box in an Excel
worksheet? - answer✔✔?, *
A formula in Excel can consist of which of the following? - answer✔✔all of the choices
provided are valid
Which of the following does the Formula Autocomplete feature in Excel take into account? -
answer✔✔all of the options provided for this answer are valid
For a range called Data, what does the function =COUNTIF(Data, TODAY()) return? -
answer✔✔number of cells containing the current date
For a range called Data, what does the function =COUNTIF(Data, "<>0") return? -
answer✔✔number of cells not equal to 0
Consider the function =COUNTIF(A1:A200, ">200"). The information between the parentheses
in a function are known as the ____________ . - answer✔✔arguments
Which of the following error codes indicates that a formula refers to a cell that is invalid? This
type of error can occur if a referenced cell is deleted from the worksheet. - answer✔✔#REF!
To view or edit a comment, you can select the cell where a comment has been attached and press
the following keyboard shortcut: __________. - answer✔✔Shift+F2
Suppose your worksheet has a comment in cell A1 and a comment in cell B5. Your active cell is
B1.
MIS 111 Lab Exam Questions With Correct
Answers
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.
Which of the following is the difference between a Pie and Doughnut chart in Excel? -
answer✔✔a doughnut chart can display more than one series of data
What are the minimum and maximum zoom ranges that can be displayed in an open Excel
worksheet (respectively)? - answer✔✔10%, 400%
, ©THEBRIGHT 2024
A single element in a worksheet that can hold a value, some text, or a formula is referred to as
which of the following? - answer✔✔cell
Which of the following types (chart types) is a VALID option in the Charts ribbon group on the
Insert ribbon tab? - answer✔✔all of the options provided are valid
Charts are dynamic, e.g., they change as the underlying data changes. Is this an accurate
statement? - answer✔✔Yes, by default they are dynamic.
Which of the following best describes what a Sparkline is? - answer✔✔a mini-chart that is
displayed in a single cell
An Excel workbook can contain one or more of which of the following? - answer✔✔worksheets
Examine the attached workbook. To create a duplicate copy of a chart (on same Excel
worksheet, but different location), you can activate the chart and take what action? -
answer✔✔hold the "Ctrl" key while dragging the chart to the new location
Which two wildcard characters are supported by the "Find and Replace" dialog box in an Excel
worksheet? - answer✔✔?, *
A formula in Excel can consist of which of the following? - answer✔✔all of the choices
provided are valid
Which of the following does the Formula Autocomplete feature in Excel take into account? -
answer✔✔all of the options provided for this answer are valid
For a range called Data, what does the function =COUNTIF(Data, TODAY()) return? -
answer✔✔number of cells containing the current date
For a range called Data, what does the function =COUNTIF(Data, "<>0") return? -
answer✔✔number of cells not equal to 0
Consider the function =COUNTIF(A1:A200, ">200"). The information between the parentheses
in a function are known as the ____________ . - answer✔✔arguments
Which of the following error codes indicates that a formula refers to a cell that is invalid? This
type of error can occur if a referenced cell is deleted from the worksheet. - answer✔✔#REF!
To view or edit a comment, you can select the cell where a comment has been attached and press
the following keyboard shortcut: __________. - answer✔✔Shift+F2
Suppose your worksheet has a comment in cell A1 and a comment in cell B5. Your active cell is
B1.
