110 Keyboard Sequence
Option 2: Correct. You can select options from the Protect Workbook drop-down menu in the Info tabbed page to control who has access to the file
Option 3: Correct. To create a new document, you can access the New tabbed page, which lets you create a new page using a template.
Option 4: Incorrect. The Zoom command can't be accessed from the Backstage panel. To zoom in or out on a worksheet you access the Zoom group options from the View tab or use the Zoom slider on the status bar.
Option 5: Incorrect. You can't change your view from Backstage view. If you want to access several worksheets in tile format, you can use options in the Page Setup group on the Page Layout tab on the Ribbon.
Correct answer(s):
1. Upload your worksheet to a web site
2. Protect your file from being altered by others 3. Use a template to create a new worksheet
3. The Quick Access Toolbar
The Quick Access Toolbar provides you with shortcuts to any of the commands in Backstage view or on the Ribbon. The default setting pins only the Save, Undo and Redo command buttons to the Quick Access Toolbar.
The commands that are already pinned to the Quick Access Toolbar are three of the most commonly used commands in Excel.
You can click Save regularly to make sure any changes you make to your file are kept.
You can use the Undo and Redo commands to correct a mistake, instead of having to retype the data. You can access lists of your actions by clicking the drop-down buttons.
Question
What commands are available by default on the Quick Access Toolbar?
Options:
1. Save 2. Undo 3. Redo 4. Print 5. Open
117 Answer
Save, Undo, and Redo are pinned to the Quick Access Toolbar by default. You can customize the Quick Access Toolbar to remove these commands or add others.
Option 1:
Option 2:
Option 3:
Option 4:
Option 5:
Correct answer(s):
1. Save 2. Undo 3. Redo
You can add or remove buttons on the Quick Access Toolbar to suit your own needs. You can access a list of commonly used commands by clicking the Customize Quick Access Toolbar button.
Graphic
Options in the Customize Quick Access Toolbar drop-down list include New, Open, Save, E-mail, Quick Print, Print Preview and Print, Spelling, Undo, Redo, Sort Ascending, Sort Descending, and Open Recent File. It also includes the options More Commands and Show Below the Ribbon.
To add buttons to the Quick Access Toolbar, you can select the commands from the list. For example, you can add Quick Print by clicking it.
Then the list closes automatically and the command you selected appears on the Quick Access Toolbar.
To remove buttons from the Quick Access Toolbar, you can select the command again. The list closes automatically and the command is no longer on the Quick Access Toolbar.
As well as adding or removing some of the most commonly used commands, you can also access more commands to choose from or reposition the Quick Access Toolbar.
Graphic
118
The More Commands and Show Below the Ribbon options are highlighted.
Select the options to find out how to customize the Quick Access Toolbar.
More Commands
You can access the Customize Quick Access Toolbar tabbed page of the Excel Options dialog box by selecting More Commands from the drop-down list. The dialog box contains many more options and commands you can choose from to customize the Toolbar.
Show Below the Ribbon
You can reposition the Quick Access Toolbar by selecting Show Below the Ribbon from the drop-down list.
Try It
Now you try customizing the Quick Access Toolbar.
You want to add the Spelling button, and reposition the Quick Access Toolbar below the Ribbon.
To complete the task
1. Click Customize Quick Access Toolbar and select Spelling
2. Click Customize Quick Access Toolbar and select Show Below the Ribbon
You've added the Spelling button to the Quick Access Toolbar and repositioned it below the Ribbon.
4. The description bars
The Formula Bar displays the data within a cell, such as text, numbers, or formulas. You can use this bar to enter data into the worksheet or to edit existing data. The bar displays whatever data was entered into the worksheet originally and doesn't reflect changes in formatting.
Graphic
In the sample spreadsheet containing data relating to the actual and estimated values for an event budget, when cell B3 is selected, the Formula Bar displays its value, namely 2,300. When the value is updated to 2,500 in the Formula Bar, the value updates in the cell too. When the cell B7 is selected, a formula displays in the Formula Bar, namely =SUM(B3:B6).
The Name Box displays the coordinates of a selected cell. For example, if the cell is in column B, row 5, the coordinates that display in the Name Box are B5. The coordinates help you avoid confusion when creating large and complicated worksheets. You can enter coordinates into the Name Box to navigate to a particular cell.
119 Graphic
The Wireless Tech Conference worksheet is open in Excel. It contains the actual and estimated budget figures for various items required for the conference. Below the Ribbon, the Name box and Formula Bar display.
You can use the status bar to monitor the status of your worksheet. If you're able to work in the worksheet, the status "Ready" displays.
If you double-click a cell, the status "Enter" displays. You can then enter data into the cell.
Graphic
For example, the blank cell B10 is selected.
If you double-click a cell that already has data in it, the status "Edit" displays, which means you can change or add to the data in the selected cell.
Graphic
For example, the cell B5 containing the data Venue hire has been selected.
The status bar also includes several layout options – the Layout selector, the Zoom buttons and slider, and the built-in functions. You can use these to change the way you view your worksheet or to monitor the worksheet.
Graphic
For example, clicking the Zoom In button can increase the zoom to 110% and then clicking Zoom Out reduces it back to 100%.
Select each component of the status bar for more information about it.
Built-in functions
The status bar includes built-in functions. For example, when you select two or more cells, the built-in functions display the Average, Count, and Sum of the numbers in the cells. Average is the average numeric value of all the selected cells, Count provides you with the number of cells selected, and Sum automatically adds the values of the selected cells.
In this case, the Average is $1,500, the Count is 5, and the Sum is $7,500.
Layout selector
Three layout buttons are positioned on the status bar. You can click Normal – the default view – to display the worksheet as a simple grid. You click Page Layout to view the worksheet as it
120
would appear on a printed page and Page Break Preview to view the page breaks on the worksheet.
Zoom level
The Zoom level button displays the percentage of zoom level. The default view is 100%. As well as using the Zoom buttons and slider, you can also click the Zoom level button to launch the Zoom dialog box and select the zoom level.
The available options in the Zoom dialog box are 200%, 100%, 75%, 50%, 25%, Fit selection, and Custom.
Zoom buttons and slider
You can zoom in and out of your worksheet, changing how large the worksheet appears on screen. You can either use the Zoom slider or click the Zoom In and Zoom Out buttons to do so.
You can customize the status bar by right-clicking it and selecting an additional command from the Customize Status Bar list.
Graphic
Items that appear on the status bar are selected and a checkmark is displayed with each item on the Customize Status Bar menu.
You can also unpin options by selecting the option again, which deselects it. For example, you can choose whether or not to include the Count option.
Graphic
The Count option is selected on the Customize Status Bar menu.
Each worksheet in a workbook is tabbed. These tabs appear just above the status bar, and you use them to navigate between worksheets.
Graphic
In this workbook, there are three tabs – Expenses, Income, and Summary.
Question
What tasks can you can perform using the status bar?
Options:
1. Switch to Page Break Preview layout 2. Increase and decrease the zoom
121
3. View page number
4. View the average of a selected number of cells 5. Change font color
6. View associated people
Answer
Option 1: Correct. Page Break Preview is one of three layout buttons on the status bar that you