MIS 112 FINAL STUDY GUIDE Exam prep
What Characters are not allowed in sheet names?
A. []
B. ,
C. !
D. All options are correct - correct answersA. []
Which of the following Excel tabs is not visible in a worksheet by default?
A. Developer
B. Review
C. Home
D. Insert - correct answersA. Developer
Would you be able to apply the watch window option in multiple sheets at the same time?
A. Yes
B. No
C. Yes, but only if there are no more than 3 sheets in the workbook
D. This option was available in excel 2013 but not in excel 2016 - correct answersA. Yes
Please examine the attached workbook. Given the data in Sheet1, which of the following steps should
be followed to obtain the data in Sheet2 ?
A. Select cells A1 through D3 in Sheet1 -> Copy -> Transpose -> Go to Sheet2 -> Paste
B. Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Formulas
C. It is only possible if done manually
D. Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose - correct
answersD. Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel?
A. Ctrl + N
B. Ctrl + E
C. Ctrl + W
D. Ctrl + B - correct answersA. Ctrl + N
,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?
A. Home
B. Review
C. Insert
D. Formulas - correct answersA. 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?
A. Toggle
B. None of the (other) options provided is correct
C. Side View
D. Synchronous Scrolling - correct answersD. Synchronous Scrolling
Which of the following procedures will NOT close your Excel workbook?
A. Ctrl + S
B. Ctrl + F4
C. Ctrl + W
D. File -> Close - correct answersA. Ctrl + S
Which of the following is the file format of the Excel 97-2003 workbook?
A. .xls
B. .xlsx
C. .xlsb
D. .xltm - correct answersA. xls
Which of the following options scrolls the screen so that the active cell is visible?
A. Ctrl+Backspace
B. Ctrl+*
,C. Ctrl+[
D. Ctrl+] - correct answersA. Ctrl + Backspace
What is the shortcut to open the Find and Replace dialog box with the "Replace" tab open?
A. Ctrl+F
B. Ctrl+A
C. Ctrl+H
D. Ctrl+FIND - correct answersC. Ctrl + H
Which of the following methods is a VALID way to get into cell edit mode?
A. Clicking the cell one time enables you to edit the cell contents
B. Selecting the cell that you want to edit, and then clicking in the Formula bar
C. Pressing F9, which enables you to edit the cell contents directly in the cell
D. Pressing F4 allows you to the edit the cell contents - correct answersB. Selecting the cell that you
want to edit, and then clicking in the Formula bar
Which of the following keyboard shortcuts will add the current time to a cell in an Excel worksheet?
A. Ctrl + Shift + :
B. Ctrl + ;
C. Ctrl + '
D. Ctrl + T - correct answersA. Ctrl + Shift + :
In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______.
A. select a row
B. select a column
C. select a range
D. select multiple rows or columns - correct answersB. Select a column
Which of the following formulas will display both the current date and time when entered into a cell in
an Excel worksheet?
, A. = NOW()
B. = DATE()
C. = TIME()
D. = TODAY() - correct answersA. = NOW ()
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 - correct answersC. A workbook can have many
worksheets
Please refer to the figure. Which Excel Element is shown in the red box?
A. File button
B. Quick Access toolbar
C. Scrollbar
D. Ribbon - correct answersB. Quick Access Toolbar
What is metadata?
A. Descriptive information about a workbook
B. Corrupted data in a workbook
C. The file extension of the workbook
D. Comments and cell annotations in a workbook - correct answersA. Descriptive information about a
workbook
Which of the following procedures will NOT save (nor give you an option to save) your Excel workbook?
A. Shift + S
B. Ctrl + S
C. (Excel ribbon tab) File -> Save
D. clicking the Close (X) button in the workbook's title bar - correct answersA. Shift + S
You enter "(500)" into an unformatted cell in an Excel worksheet (without quotation marks). Which of
the following will be generated by your entry?
What Characters are not allowed in sheet names?
A. []
B. ,
C. !
D. All options are correct - correct answersA. []
Which of the following Excel tabs is not visible in a worksheet by default?
A. Developer
B. Review
C. Home
D. Insert - correct answersA. Developer
Would you be able to apply the watch window option in multiple sheets at the same time?
A. Yes
B. No
C. Yes, but only if there are no more than 3 sheets in the workbook
D. This option was available in excel 2013 but not in excel 2016 - correct answersA. Yes
Please examine the attached workbook. Given the data in Sheet1, which of the following steps should
be followed to obtain the data in Sheet2 ?
A. Select cells A1 through D3 in Sheet1 -> Copy -> Transpose -> Go to Sheet2 -> Paste
B. Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Formulas
C. It is only possible if done manually
D. Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose - correct
answersD. Select cells A1 through D3 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel?
A. Ctrl + N
B. Ctrl + E
C. Ctrl + W
D. Ctrl + B - correct answersA. Ctrl + N
,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?
A. Home
B. Review
C. Insert
D. Formulas - correct answersA. 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?
A. Toggle
B. None of the (other) options provided is correct
C. Side View
D. Synchronous Scrolling - correct answersD. Synchronous Scrolling
Which of the following procedures will NOT close your Excel workbook?
A. Ctrl + S
B. Ctrl + F4
C. Ctrl + W
D. File -> Close - correct answersA. Ctrl + S
Which of the following is the file format of the Excel 97-2003 workbook?
A. .xls
B. .xlsx
C. .xlsb
D. .xltm - correct answersA. xls
Which of the following options scrolls the screen so that the active cell is visible?
A. Ctrl+Backspace
B. Ctrl+*
,C. Ctrl+[
D. Ctrl+] - correct answersA. Ctrl + Backspace
What is the shortcut to open the Find and Replace dialog box with the "Replace" tab open?
A. Ctrl+F
B. Ctrl+A
C. Ctrl+H
D. Ctrl+FIND - correct answersC. Ctrl + H
Which of the following methods is a VALID way to get into cell edit mode?
A. Clicking the cell one time enables you to edit the cell contents
B. Selecting the cell that you want to edit, and then clicking in the Formula bar
C. Pressing F9, which enables you to edit the cell contents directly in the cell
D. Pressing F4 allows you to the edit the cell contents - correct answersB. Selecting the cell that you
want to edit, and then clicking in the Formula bar
Which of the following keyboard shortcuts will add the current time to a cell in an Excel worksheet?
A. Ctrl + Shift + :
B. Ctrl + ;
C. Ctrl + '
D. Ctrl + T - correct answersA. Ctrl + Shift + :
In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to ______.
A. select a row
B. select a column
C. select a range
D. select multiple rows or columns - correct answersB. Select a column
Which of the following formulas will display both the current date and time when entered into a cell in
an Excel worksheet?
, A. = NOW()
B. = DATE()
C. = TIME()
D. = TODAY() - correct answersA. = NOW ()
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 - correct answersC. A workbook can have many
worksheets
Please refer to the figure. Which Excel Element is shown in the red box?
A. File button
B. Quick Access toolbar
C. Scrollbar
D. Ribbon - correct answersB. Quick Access Toolbar
What is metadata?
A. Descriptive information about a workbook
B. Corrupted data in a workbook
C. The file extension of the workbook
D. Comments and cell annotations in a workbook - correct answersA. Descriptive information about a
workbook
Which of the following procedures will NOT save (nor give you an option to save) your Excel workbook?
A. Shift + S
B. Ctrl + S
C. (Excel ribbon tab) File -> Save
D. clicking the Close (X) button in the workbook's title bar - correct answersA. Shift + S
You enter "(500)" into an unformatted cell in an Excel worksheet (without quotation marks). Which of
the following will be generated by your entry?
