MIS 112 - SAR ExamPrep
Please refer to the figure. Which of the following Excel tabs is NOT visible in a worksheet by default? -
correct answersDeveloper
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? - correct answersSynchronous Scrolling
Please refer to the figure. What Excel element is shown in the red box? - correct answersQuick Access
Toolbar
Please refer to the figure. Within the "Number" tab, how many categories are available for displaying
numbers? - correct answers12
Please refer to the figure. How many worksheets are contained in the workbook shown? - correct
answers5
Please refer to the figure. What Excel element is shown in the red box? - correct answersRibbon
Please refer to the figure. In an Excel worksheet, what column name comes directly after Column Z? -
correct answersAA
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? - correct answersHome
Which of the following statements is true?
- A workbook can have at most 3 worksheets
- A worksheet can have many workbooks
- A workbook can have many worksheets
- A worksheet can have at most 3 workbooks - correct answersA workbook can have many worksheets
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel? - correct
answersCtrl + N
Please see the attached workbook. Which of the following steps allow you to add a comment to a
specific cell? - correct answersReview -> Comments -> New Comment
How can you edit the contents cell (by entering cell-edit mode)? Choose the best answer.
- Double-click the cell
- Select a cell and press F2
- Select a cell and then click inside Formula bar
- All of the options provided are correct - correct answersAll of the options provided are correct
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? - correct answersYes
, 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)? - correct
answers=C20/F8
Examine the attached file. Calculate the total yearly sales for the West Region and the South Region in
cells "F5" and "F7" (shaded in orange). What is the total widget sales for all regions for the year? -
correct answers$24,914
Which of the following procedures will NOT close your Excel workbook? - correct answersCtrl + S
Which of the following options scrolls the screen so that the active cell is visible? - correct answersCtrl +
Backspace
Which of the following procedures will NOT save (nor give you an option to save) your Excel workbook? -
correct answersShift + S
Which of the following methods is a VALID way to get into cell edit mode? - correct answersSelecting the
cell that you want to edit, and then clicking in the Formula bar.
In Excel, Shift + Spacebar (keyboard shortcut) is used to _____. - correct answersselect a row
Examine the attached Excel file. In row 4, we have two different ways of displaying the August 25 date.
Which of the following is TRUE about these dates? - correct answersThe data stored in the two cells A4
and B4 are identical.
Is it possible to get the data back after deleting it using keyboard? - correct answersYes
In the attached Excel workbook, which of the following formulas can be used to calculate Sophie's total
score in both the exams? - correct answers=B4+C4
You select a cell with data "120" in an Excel worksheet and press the "Delete" key on your keyboard.
Which of the following holds TRUE? - correct answersonly the contents of the cell are removed
Does deleting a cell by pressing the Delete key also delete the conditional formatting on the cell? -
correct answersNo
Please examine the attached image. A part of the workbook is boxed in red.
The boxed area is called ____. What is displayed in this boxed area when a range of cells is selected?
______ - correct answersName box. The number of rows and columns in the selection is displayed here.
Which of the following chart-related items identifies general trends in your data? - correct
answerstrendline
Which of the following types (chart types) is a VALID option in the Charts ribbon group on the Insert
ribbon tab? - correct answersall of the options provided are valid
Please refer to the figure. Which of the following Excel tabs is NOT visible in a worksheet by default? -
correct answersDeveloper
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? - correct answersSynchronous Scrolling
Please refer to the figure. What Excel element is shown in the red box? - correct answersQuick Access
Toolbar
Please refer to the figure. Within the "Number" tab, how many categories are available for displaying
numbers? - correct answers12
Please refer to the figure. How many worksheets are contained in the workbook shown? - correct
answers5
Please refer to the figure. What Excel element is shown in the red box? - correct answersRibbon
Please refer to the figure. In an Excel worksheet, what column name comes directly after Column Z? -
correct answersAA
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? - correct answersHome
Which of the following statements is true?
- A workbook can have at most 3 worksheets
- A worksheet can have many workbooks
- A workbook can have many worksheets
- A worksheet can have at most 3 workbooks - correct answersA workbook can have many worksheets
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel? - correct
answersCtrl + N
Please see the attached workbook. Which of the following steps allow you to add a comment to a
specific cell? - correct answersReview -> Comments -> New Comment
How can you edit the contents cell (by entering cell-edit mode)? Choose the best answer.
- Double-click the cell
- Select a cell and press F2
- Select a cell and then click inside Formula bar
- All of the options provided are correct - correct answersAll of the options provided are correct
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? - correct answersYes
, 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)? - correct
answers=C20/F8
Examine the attached file. Calculate the total yearly sales for the West Region and the South Region in
cells "F5" and "F7" (shaded in orange). What is the total widget sales for all regions for the year? -
correct answers$24,914
Which of the following procedures will NOT close your Excel workbook? - correct answersCtrl + S
Which of the following options scrolls the screen so that the active cell is visible? - correct answersCtrl +
Backspace
Which of the following procedures will NOT save (nor give you an option to save) your Excel workbook? -
correct answersShift + S
Which of the following methods is a VALID way to get into cell edit mode? - correct answersSelecting the
cell that you want to edit, and then clicking in the Formula bar.
In Excel, Shift + Spacebar (keyboard shortcut) is used to _____. - correct answersselect a row
Examine the attached Excel file. In row 4, we have two different ways of displaying the August 25 date.
Which of the following is TRUE about these dates? - correct answersThe data stored in the two cells A4
and B4 are identical.
Is it possible to get the data back after deleting it using keyboard? - correct answersYes
In the attached Excel workbook, which of the following formulas can be used to calculate Sophie's total
score in both the exams? - correct answers=B4+C4
You select a cell with data "120" in an Excel worksheet and press the "Delete" key on your keyboard.
Which of the following holds TRUE? - correct answersonly the contents of the cell are removed
Does deleting a cell by pressing the Delete key also delete the conditional formatting on the cell? -
correct answersNo
Please examine the attached image. A part of the workbook is boxed in red.
The boxed area is called ____. What is displayed in this boxed area when a range of cells is selected?
______ - correct answersName box. The number of rows and columns in the selection is displayed here.
Which of the following chart-related items identifies general trends in your data? - correct
answerstrendline
Which of the following types (chart types) is a VALID option in the Charts ribbon group on the Insert
ribbon tab? - correct answersall of the options provided are valid
