©THEBRIGHT 2024
Mis 111 Midterm Exam Questions With
Correct Answers
Please refer to the figure. In an Excel worksheet, what column name comes directly after
Column Z?
A) AA
B)AZ
C)ZA
D)ZZ - answer✔✔AA
Which of the following statements is true?
A)A workbook can have at most 3 worksheets.
B)A worksheet can have many workbooks.
C)A workbook can have many worksheets.
D)A worksheet can have at most 3 workbooks. - answer✔✔A workbook can have many
worksheets.
Please refer to the figure. What Excel element is shown in the red box?
A)File button
, ©THEBRIGHT 2024
B)Quick Access toolbar
C)Scrollbar
D)Ribbon - answer✔✔Ribbon
Please refer to the figure. Within the "Number" tab, how many categories are available for
displaying numbers?
a)12
b)8
c)10
d)14 - answer✔✔12
Please refer to the figure. What Excel element is shown in the red box?
File button
Quick Access toolbar
, ©THEBRIGHT 2024
Scrollbar
Ribbon - answer✔✔quick access toolbar
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?
Home
Review
Insert
Formulas - answer✔✔Home
Please examine the attached workbook. Given the data in Sheet1, which of the following steps
should be followed to obtain the data in Sheet2 ?
Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Formulas
Select cells A1 through C4 in Sheet1 -> Copy -> Transpose -> Go to Sheet2 -> Paste
, ©THEBRIGHT 2024
It is only possible if done manually
Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose -
answer✔✔Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose
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?
Ctrl+Enter
Ctrl+Shift
Ctrl+Backspace
Ctrl+Insert - answer✔✔Ctrl+Enter
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel?
Mis 111 Midterm Exam Questions With
Correct Answers
Please refer to the figure. In an Excel worksheet, what column name comes directly after
Column Z?
A) AA
B)AZ
C)ZA
D)ZZ - answer✔✔AA
Which of the following statements is true?
A)A workbook can have at most 3 worksheets.
B)A worksheet can have many workbooks.
C)A workbook can have many worksheets.
D)A worksheet can have at most 3 workbooks. - answer✔✔A workbook can have many
worksheets.
Please refer to the figure. What Excel element is shown in the red box?
A)File button
, ©THEBRIGHT 2024
B)Quick Access toolbar
C)Scrollbar
D)Ribbon - answer✔✔Ribbon
Please refer to the figure. Within the "Number" tab, how many categories are available for
displaying numbers?
a)12
b)8
c)10
d)14 - answer✔✔12
Please refer to the figure. What Excel element is shown in the red box?
File button
Quick Access toolbar
, ©THEBRIGHT 2024
Scrollbar
Ribbon - answer✔✔quick access toolbar
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?
Home
Review
Insert
Formulas - answer✔✔Home
Please examine the attached workbook. Given the data in Sheet1, which of the following steps
should be followed to obtain the data in Sheet2 ?
Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Formulas
Select cells A1 through C4 in Sheet1 -> Copy -> Transpose -> Go to Sheet2 -> Paste
, ©THEBRIGHT 2024
It is only possible if done manually
Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose -
answer✔✔Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose
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?
Ctrl+Enter
Ctrl+Shift
Ctrl+Backspace
Ctrl+Insert - answer✔✔Ctrl+Enter
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel?
