| A | B |
|---|
| Excel provides the tools to create which type of documents? | workbooks |
| What is the procedure to launch Excel from the Windows desktop? | Click the start button and then choose Microsoft Excel, Right click on the desk top and new , Microsoft Excel, and then double click it & Click the icon on the Windows task bar |
| Use the __________ option for quick access to the Excel application from the Windows desktop. | pin |
| Which toolbar is located in the upper left corner of the Excel window? | Quick Access |
| The tools to edit the workbook are located on the __________. | ribbon |
| When you add ribbon commands to the Quick Access Toolbar, right-click the command and choose __________. | Add to Quick Access Toolbar |
| The Quick Access Toolbar can be moved __________. | above the ribbon and below the ribbon |
| Which key is used to display keyboard shortcuts (Keytips) on the ribbon? | Alt |
| The commands on each ribbon tab are organized into logical command __________. | Groups |
| If you cannot find the command you need while working in the ribbon, where can you click to find more options? | the Options arrow in the bottom right corner of the group |
| Which view shows the options to open, save, print, and manage your Excel file? | Backstage |
| How many worksheets are included in a new blank workbook? | 1 |
| A/An __________ is the name of a box in a worksheet at the intersection of a row and column in which information is typed. | cell |
| A/An __________, where you can type information, is outlined by a bold rectangle in your worksheet. | Active Cell |
| A __________ displays descriptive text when you rest the pointer on a command or control in Excel. | ScreenTip |
| In the Workbook Views group, click __________ to display the active worksheet without rulers, headers, footers, or page breaks. | Normal |
| A __________ is an Excel file made up of one or more worksheets. | Workbook |
| Use the __________ on the bottom right side of the Quick Access Toolbar to add additional commands. | drop-down arrow |
| To increase workspace you can __________ so that only the tabs display at the top of the screen. | collapse the ribbon |
| In order to see additional customization options, select __________ from the Quick Access Toolbar drop-down list to display the Excel Options dialog box. | More Commands |
| The __________ command enables you to view large worksheets in two panes or four quadrants. | Split |
| The __________ command on the View tab in the Workbook Views group opens windows side by side to compare sections of a large worksheet. | Arrange All |
| The Close command on the File tab closes __________. | the entire workbook |
| The __________ tab contains the Backstage Open command. | File |
| What starts at the top of each worksheet, goes to the bottom, and is identified by a letter? | Column |
| What starts at the left edge of each worksheet, extends to the right, and is identified by a number? | row |
| Which tab on the ribbon do you select to view Backstage options? | File |
| Which command in Backstage displays details about the current file? | Info |
| Which tab holds commands for controlling the appearance of the active document? | View |
| What option on the View tab displays worksheet margins and page breaks and gives you an opportunity to add a header or footer? | Page Layout |
| Where are the icons available to change views outside the ribbon? | status bar |
| What tab on the ribbon has the Split command, useful for viewing large worksheets? | View |
| Which of the following commands is similar to Split? | New Window |
| Which of the following displays in the title bar when a new window is opened from the View tab? | Book1:2 |
| The ribbon is organized into task-oriented __________. | Command Tabs |
| What is the maximum number of characters allowed in a file name? | 255 |
| To display the Open dialog box, which of the following should you press? | Ctrl + F12 |
| By default, which of the following file types is displayed in the Excel Open dialog box? | Excel |
| Which of the following should you press to close both an open file and Excel at the same time? | Alt+F4 |
| What is the purpose of the Name Box? | to indicate the current active cell(s) |
| On which tab will you find the Go To command? | Home |
| Which of the following is the Keyboard Shortcut, used to access help? | F1 |
| Some Keyboards come equipped with a/an __________ key, which disables arrow key movement when activated. | Scroll Lock |
| In order to display additional search options, which button in the Go To dialog box should you use? | Special |
| An arrow in the bottom-right corner of a group on the ribbon tells you that which of the following is available? | Dialog box |
| Which of the following is a selected cell? | Active Cell |
| Which feature enables you yo preview headers and footers, page breaks, and other features that will print | Print Layout |
| After a file has been opened, the file name appears in which of the following? | Title bar |
| when you split a window, the window is divided into how many panes | two or four |
| When you click the Help button what opens? | Help Window |
| Which is the intersection of a row and column | cell |
| Which of the following starts off with Open, Undo, Redo and can be customized to contain the commands you use most frequently? | The Quick Access toolbar |
| To get to the last cell on a worksheet, which of the following should you press | Ctrl+End |
| Pressing the F1 key displays backstage? | False |
| Pressing Alt key activates Keytips that allow you to use the keyboard to choose tabs instead of the click of a mouse | True |
| Ctrl+O Opens a new blank workbook | False |
| The Quick Access Toolbar appears on the right side of the title bar, above the ribbon | False |
| Ctrl+F displays the backstage view | False |
| Click the FILE tab to get to the backstage view | True |
| Press Ctrl+Home to go to cell A1 | True |
| The columns in a worksheet are identified by numbers | False |
| The active cell in a worksheet us outlined by a bold rectangle | True |
| Page Layout view is useful when preparing your data for printing | True |
