| A | B |
|---|
| Which tab provides access to the Close command in Backstage? | File |
| Which are valid options within the Print tab in Backstage? | Margins, Orientation, Paper size, no scaling, and page range |
| Which ribbon tab contains the Clear Print Area option? | Page Layout |
| __________ is used to remove restrictions set on printing cell ranges. | Clear Print Area |
| In order to create a new workbook using keyboard shortcuts, which keys do you press? | Ctrl + N |
| The __________ options ensure that all columns, rows, or the entire worksheet fit on one page. | scaling |
| Which of the following options are available on the scaling drop-down list? | Fit all columns on one page, fit all rows on one page, no scaling, &fit sheet on one page |
| In order to find the Page Setup, Scale to Fit, and Sheet options, which tab can you click on instead of File? | Page Layout |
| In order to change the printer to which the workbook should be set, which tab should you go to? | File |
| In order to display the Print tab in the Backstage view, which keyboard shortcut should you use? | Ctrl + P |
| Use __________ to open the folder where the current file is saved. | Open File Location |
| Click the __________ icon on the Quick Access Toolbar to send the worksheet directly to the printer. | Quick Print |
| In order to add commands to the toolbar near the ribbons in Excel, what should you select from the Backstage navigation pane? | Options |
| Which procedure quickly adds any button on the ribbon to the Quick Access Toolbar? | right-click |
| Which of the following options are available when customizing the ribbon? | Add a tab, add a group to existing tabs, add a froup to new tabs, & delete commands from existing tabs |
| Which of the following options are found within the Customize Ribbon dialog box? | Rename button, new tab button, command list, remove button, reset button |
| Which best describes the idea of organizing commands logically on a custom tab? | Group |
| Which button in the Excel options is used to logically organize commands within a ribbon tab? | New Group |
| Customize the ___________ for fast access to your favorite commands. | Quick Access Toolbar |
| Excel __________ are files that include preset formatting and formulas. | templates |
| What is the recommended procedure following the changes to the Excel default options in Backstage? | Restart |
| In order to access the available templates from Excel, what should you click on the File tab? | New |
| In order to add a symbol and name a new tab, which button on the Customize Ribbon options dialog box should you use? | Rename |
| Which command in the Backstage view navigation pane enables you to view and open recent workbooks or workbooks stored on your computer? | Open |
| The Excel __________ tab on Backstage is used to modify Excel’s workbook default settings in Backstage view. | Options |
| What is the default font size in a workbook? | 11 pt |
| Which option in the Backstage navigation pane do you select to change the default of new workbooks to three blank spreadsheets? | Options |
| Which option in the Backstage navigation pane do you choose to reset Excel to its defaults? | Options |
| Which of the following changes to default settings does not require you to open a new, blank workbook to view the changes? | ribbon and Quick Access Toolbar |
| Which button in new options on the Backstage view shows you over 20 business templates? | Featured |
| Which option in the New window shows additional templates not on the original screen? | Suggested searches |
| Which template is used to display a workbook without formatting or formulas? | Blank workbook |
| In order to download a template, which button do you click? | Create |
| How many additional templates are available online? | thousands |
| When searching for templates, which button in the new window returns you to the original new window view? | Home |
| You can create a completely new Ribbon tab as well as groups on that ribbon. | True |
| In Excel, you can add your most commonly used commands to the Quick Access Toolbar | True |
| By default, Excel starts a new workbook with four worksheets. | False |
| You can access Backstage view by pressing Ctrl + B. | False |
| If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width | False |
| You cannot have more than one worksheet in an Excel workbook | False |
| To access an Excel template, you can click the FILE tab and click New. | True |
| Use Ctrl + N to create a new workbook | True |
| The Open dialog box enables you to access the Microsoft website for custom templates | False |
| You do not have the ability to modify the number of default worksheets in a workbook. | False |
| What is a predesigned file that already has a significant amount of formatting, text, and other features? | Template |
| Which of the following do you click in the navigation pane to change Excel’s default settings by accessing Backstage view? | Options |
| Which of the following do you use to open Backstage view? | FILE tab |
| When you modify the ribbon, which of the following do you create? | Tab |
| Which dialog box in Backstage view should you access to view and alter your workbook’s properties?. | Options |
| Which command in the Backstage view navigation pane enables you to view and open your most recently used workbooks or workbooks stored on SkyDrive or your computer? | Open |
| Which feature enables you to create custom tabs and groups? | Ribbon |
| Which of the following can you customize for quicker access to the most commonly used commands? | Quick Access Toolbar |
| To change printer, layout, or margin settings, you click the FILE tab and use which of the following options? | Print |
| Which of the following is where you can save, select a template, change document properties, and close or exit Excel? | Backstage |
