facebook twitter pinterest google plus Youtube


Using the Ribbon Test

Free Online Microsoft Excel Test
Excel Training 2010 - Getting Started

* How is the Ribbon organized?
* How are Tabs organized?
* What are Contextual Tabs?
* Identifying Groups on the Ribbon
* Show/ Hide the Ribbon

10 Question Multiple Choice Quiz with Answers

Moving Around the Worksheet Test

1) Which of the following lists demonstrate the tabs you will typically find by default on the Excel Ribbon?
a) Home, Insert, Page Layout, Tables, Review, View.
b) File, Home, Insert, Page Layout, Formulas, Data, Review, View.
c) File, Home, Insert, Functions, Page Layout, Data, Review, View.
d) None of the options listed above are correct.

Question 2 - Using the Ribbon - Excel Test

2) Study the screenshot above.  Rakesh is looking for the usual buttons and groups on the Ribbon, but they all seem to have disappeared.  What should Rakesh do?
a) The Window is minimized.  Rakesh must resize the window by pressing the square maximize button to restore the window.
b) The View type selected is hiding the Ribbon.  Rakesh must click on the View tab and select Normal View.
c) The Ribbon is minimized.  Rakesh must press Ctrl+F1 to restore it.
d) There are no buttons to display for the current worksheet.  Rakesh must create a new worksheet to restore the Ribbon.

3) Which of the following is NOT a group on the default Excel Ribbon under the Home tab?
a) The Formulas group.
b) The Clipboard group.
c) The Alignment group.
d) The Editing group.

Question 4 - Using the Ribbon - Excel Test
4) Study the screenshot above.  Raoul was busy working on a chart in Excel using design, layout and format options that he found on the Ribbon under separate similarly-named tabs.  However, these tabs have now disappeared and he cannot find the options again.  What can Raoul do?
a) He needs to click on the chart for the tabs to reappear.
b) He needs to exit the worksheet and go back in again.
c) He needs to click on the Insert tab to access these options.
d) He needs to click on the Home tab to access these options.
Question 5 - Using the Ribbon - Excel Test
5) Study the screenshot above of the Alignment group on the Ribbon.  What happens if the icon circled in yellow is clicked?
a) The group will be minimized.
b) The Format Cells dialog box will be launched.
c) More alignment options will be displayed in the group.
d) The group will be maximized.

6) Under which tab on the Ribbon will you find the Function Library from where you can insert formulas and functions into your worksheet?
a) Under the Insert tab on the Ribbon.
b) Under the Data tab on the Ribbon.
c) Under the Formulas tab on the Ribbon.
d) Under the Functions tab on the Ribbon.

7) What happens when you press the File tab on the Ribbon?
a) This launches a menu with a list of options to choose from.
b) This launches the Backstage view.
c) This launches a menu with the File Save and Save As functions only.
d) This saves the worksheet.

8) Under which tab on the Ribbon will you by default find options to edit headers and footers in a worksheet?
a) Under the Page Layout tab.
b) Under the Review tab. 
c) Under the Home tab.
d) Under the Insert tab.

Question 9 - Using the Ribbon - Excel Test
9) Study the screenshot above.  Many buttons on the Ribbon have tiny arrows to the right or below them.  What do these arrows mean?
a) It means the button has more options, a gallery or menu list to choose from.
b) It means if you click the button the option will immediately be applied.
c) It is a dialog box launcher that opens a box with more options relating to the selected button.
d) None of the options listed above are correct.

10) How can you minimize the Ribbon?
a) Press the shortcut key combination: Ctrl+F1 to minimize the Ribbon.
b) Right click the Ribbon and select Minimize the Ribbon.
c) Click on the Minimize the Ribbon button which is in the shape of an upwards pointing arrow in the top right-hand corner of the screen.
d) All of the options listed above are correct.