MIS 112 Midterm Exam Questions
with Correct Answers
What is a VALID way to get into cell edit mode? - Answer-selecting the cell that you
want to edit, and then clicking in the formula bar
Which of the following types of data may NOT be contained in a cell in an Excel
worksheet - Answer-objects
In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______ - Answer-select a
column
Examine the attached file. if you copy the whole cell "B8" (not only its formula) and
paste it into cell "D8" (shaded in green), will it produce the correct total sales value for
quarter 3? #5 - Answer-yes
Examine the attached file. to calculate the percentage of the total widget sales made by
the top 5 employees, which of the following formulae would you enter in cell "C22"
(shaded purple) #6 - Answer-=C20/F8
Examine the attached file. What is the total widget sales for the west region for the year
#7 - Answer-$5,129
Which of the following command sequences will allow you to save a copy of your
workbook with a different name - Answer-file, save as
What procedure will NOT close your Excel workbook - Answer-Ctrl + S
What option scrolls the screen so that the active cell is visible - Answer-Ctrl+Backspace
A single element in a worksheet that can hold a value, some text, or a formula is
referred to as what - Answer-cell
does deleting a cell by pressing the delete key also delete the conditional formatting on
a cell - Answer-no
Abar chart is essentially what chart type rotated 90 degrees clockwise - Answer-column
after you have selected the data to create a chart, what is the correct sequence of
options needed to create a clustered column chart - Answer-insert --> charts --> column
--> clustered column
, must a chart be embedded in the same worksheet as its data source - Answer-no, a
chart can be embedded or placed in a sheet separate from that of its data source
examine the survey results in the attached workbook (in Sheet2). what type of chart
would be most suitable to represent the survey response data #8 - Answer-pie
examine the attached workbook. how can you resize the chart title in chart 1 of sheet 1.
#19 - Answer-change font size
which of the following options is NOT available after right clicking on an Excel
worksheet tab - Answer-changing the font color in the worksheet
which of the following is the keyboard shortcut that creates a new blank workbook in
excel - Answer-Ctrl + N
please refer to the figure. in an excel worksheet, what column name comes directly after
column Z? #1 - Answer-AA
please refer to the figure. which of the following Excel tabs is NOT visible in a worksheet
by default? #2 - Answer-developer
please refer to the figure. what excel element is shown in the red box? #3 - Answer-
quick access toolbar
which of the following shortcuts allows you to enter the same data into multiple selected
cells? Example: In a new Excel worksheet select cells A1:B4 and type "MIS111." The
text is initially entered into cell A1. What could you do to replicate the same text
"MIS111" in all the selected cells? - Answer-Ctrl+Enter
what characters are NOT allowed in sheet names - Answer-[]
after pressing "Alt + H" while in an open Excel worksheet, a number of key tips are
displayed. which ribbon tab do these key tips relate to - Answer-home
while comparing two sheets using the "view side by side" feature, there is an option
which lets you scroll the two sheets in sync. what is that option called? - Answer-
synchronous scrolling
please refer to the figure. within the "number" tab, how many categories are available
for displaying numbers? #4 - Answer-12
True of False: A workbook can have many worksheets - Answer-True
what option moves the active cell right one screen - Answer-Alt+PgDn
with Correct Answers
What is a VALID way to get into cell edit mode? - Answer-selecting the cell that you
want to edit, and then clicking in the formula bar
Which of the following types of data may NOT be contained in a cell in an Excel
worksheet - Answer-objects
In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______ - Answer-select a
column
Examine the attached file. if you copy the whole cell "B8" (not only its formula) and
paste it into cell "D8" (shaded in green), will it produce the correct total sales value for
quarter 3? #5 - Answer-yes
Examine the attached file. to calculate the percentage of the total widget sales made by
the top 5 employees, which of the following formulae would you enter in cell "C22"
(shaded purple) #6 - Answer-=C20/F8
Examine the attached file. What is the total widget sales for the west region for the year
#7 - Answer-$5,129
Which of the following command sequences will allow you to save a copy of your
workbook with a different name - Answer-file, save as
What procedure will NOT close your Excel workbook - Answer-Ctrl + S
What option scrolls the screen so that the active cell is visible - Answer-Ctrl+Backspace
A single element in a worksheet that can hold a value, some text, or a formula is
referred to as what - Answer-cell
does deleting a cell by pressing the delete key also delete the conditional formatting on
a cell - Answer-no
Abar chart is essentially what chart type rotated 90 degrees clockwise - Answer-column
after you have selected the data to create a chart, what is the correct sequence of
options needed to create a clustered column chart - Answer-insert --> charts --> column
--> clustered column
, must a chart be embedded in the same worksheet as its data source - Answer-no, a
chart can be embedded or placed in a sheet separate from that of its data source
examine the survey results in the attached workbook (in Sheet2). what type of chart
would be most suitable to represent the survey response data #8 - Answer-pie
examine the attached workbook. how can you resize the chart title in chart 1 of sheet 1.
#19 - Answer-change font size
which of the following options is NOT available after right clicking on an Excel
worksheet tab - Answer-changing the font color in the worksheet
which of the following is the keyboard shortcut that creates a new blank workbook in
excel - Answer-Ctrl + N
please refer to the figure. in an excel worksheet, what column name comes directly after
column Z? #1 - Answer-AA
please refer to the figure. which of the following Excel tabs is NOT visible in a worksheet
by default? #2 - Answer-developer
please refer to the figure. what excel element is shown in the red box? #3 - Answer-
quick access toolbar
which of the following shortcuts allows you to enter the same data into multiple selected
cells? Example: In a new Excel worksheet select cells A1:B4 and type "MIS111." The
text is initially entered into cell A1. What could you do to replicate the same text
"MIS111" in all the selected cells? - Answer-Ctrl+Enter
what characters are NOT allowed in sheet names - Answer-[]
after pressing "Alt + H" while in an open Excel worksheet, a number of key tips are
displayed. which ribbon tab do these key tips relate to - Answer-home
while comparing two sheets using the "view side by side" feature, there is an option
which lets you scroll the two sheets in sync. what is that option called? - Answer-
synchronous scrolling
please refer to the figure. within the "number" tab, how many categories are available
for displaying numbers? #4 - Answer-12
True of False: A workbook can have many worksheets - Answer-True
what option moves the active cell right one screen - Answer-Alt+PgDn
