MOS Certification 2022 Lesson 1

View Buttons

These buttons change the on screen views for the worksheet. The views are Normal, Page Layout, and Page Break Preview.

Tell Me

This allows you to enter a description of what you are looking for. Unlike the simpler help feature in older versions of Excel, the Tell Me feature will display a customized menu of the commands that you are looking for.

Auto Fill options

This appears when you use the AutoFill feature to copy data or formulas into adjacent cells. Excel provides you with options for this item. When you point to this button, it appears with a drop-down arrow. Click the arrow to display more options for this item.

Paste Options

This appears when you use the AutoFill feature to copy data or formulas into adjacent cells. Excel provides you with options for this item. When you point to this button, it appears with a drop-down arrow. Click the arrow to display more options for this item.

Insert Function

This tool opens a dialog box to help you choose and insert a built in function.

What should you remember on Excel file extensions?

To view the file type (the extension part of the file name), you need to turn on this option using File Explorer. Click View, and on the Show/hide group, click File name extensions to activate it. Showing the file types can be helpful when determining which file you want to use. For example, two files may have the same name, but the file extensions show that one is in .xlsx format (Excel 2007 and later) while the other is in .xls format (Excel 2003 and earlier).

How do you switch windows in the View Tab?

When you have multiple workbooks open on the screen, you can switch between workbooks quickly and easily using one of the following methods: · on the View tab, in the Window group, click Switch Windows, or

How do you close a workbook?

-Click File and then Close, or -Press CTRL+W or CTRL+F4 , or -Click the Close button.

File Tab

-Click this tab to open the Backstage view from which you can select commands to manage files, such as Info, New, Open, Save, Print, Export or Options. -When the Info screen is displayed in Backstage view, the right side of the page displays options you can choose to control your workbook including protect, inspect, and manage. File properties are also displayed here.

How do you save files?

1) Files can be saved with two different types of save commands: 2) Use Save As to save a new document or to save an existing document with a new name or new location. 3) Use Save to save changes to the active workbook but retain the existing name and keep the file in the existing location.

How do you switch workbooks in the Taskbar?

1) Hover the mouse cursor over the Excel button on the taskbar to display a preview of each open workbook, or Tip: In this example, there is only one Excel icon in the Windows Taskbar even though you have four workbooks currently open. You can reconfigure the Taskbar so that one Excel icon will appear for each open workbook by right-clicking the Taskbar, selecting 2) Taskbar settings and, under the Combine taskbar buttons option, choosing When taskbar is full. 3) Press CTRL+TAB to jump to the next open workbook, or 4) If the workbooks are restored down as windows on the Desktop screen, click the title bar for the appropriate workbook to pull it to the front.

How do you open a workbook?

1) if Excel is starting up, click the desired workbook in the Recently used workbooks) section of the Excel startup screen or click Open Other Workbooks, or 2) Right-click on the Excel Quick Launch icon in the taskbar and select the recently used workbook from the Recent list, or 3) With a workbook currently open, click File, click Open, and then click the file from the list of Recent Workbooks, or As you open workbooks, Excel displays the files in the same order as you opened them, with the most recent at the top of the list. As you reach the maximum number of files that show in this list, the oldest drops from the list. You can click the pin icon at the right of the file name to make this file always available in the list until it is unpinned. By default, you can see a list of up to 50 recent workbooks at a time. This number can be customized. 4) click File, click Open, then click This PC and use this Open screen as a simplified File Explorer to navigate around your PC, then click on the workbook to open, or

Ribbon

A collection of tabs (for example, File, Home, Insert, Page Layout) provides quick access to commands you need to complete a task. Each Ribbon tab relates to a type of activity such as inserting objects in a worksheet, or modifying the format of data in a worksheet. In the example above, the Home tab is currently selected, and all of the icons and options for that Ribbon tab are displayed.

Can Excel 2007 and older open older versions?

All versions of Excel released after 2007 are able to open any files saved in the 97-2003 format. They can also make changes to the older file type's contents and save the workbook in the older format.

Scroll Bars

Click the arrow buttons at either end of the scroll bars to move one row or column at a time. Click on the scroll box (the size will vary depending on the zoom percentage) and drag to display another location in the worksheet.

Ribbon Display Options

Controls whether to hide or display the Ribbon with the tabs or with both tabs and command buttons.

CTRL+G / F5

Display the Go To dialog box so you can move quickly to a cell reference, range name, or bookmark, or use the Special button to find specific types of information (for example, Comments, Blanks).

Status Bar

Displays the current cell mode, auto calculations, the View buttons, and the Zoom slider. You can customize the Status bar to display keyboard locks and other features.

Ribbon Group

Each Ribbon tab contains groups of related commands to edit, format, or enhance items in your documents. Some groups include a dialog box launcher button at the bottom right, which opens a dialog box or window with more commands and options.

What extension does Excel 2007 and later use?

Excel 2007 and later versions all use the same file format for saved workbooks Excel 2007 and later versions all use the same file format for saved workbooks, which have the extension .xlsx at the end of the file name.

What is Compatibility Mode?

Excel will inform you that the workbook is using an older format by displaying the words "Compatibility Mode" next to the workbook name in the title bar. However, all versions of Excel released after 2007 have many features and capabilities that did not exist (or worked differently) in these earlier versions. Excel provides a few tools to help you check the workbook and ensure that it is compatible with earlier Excel versions. These tools are available in Backstage via the File tab and the Info category. To check if there may be problems with converting your workbook to a different file format than .xlsx, click File, click Info, click Check for Issues, and then click Check Compatibility.

ScreenTips

Help identify buttons or elements on the tabs of the Ribbon and the screen. To view a ScreenTip, position the mouse cursor on the item. A tip then displays the name of the button along with a description of the purpose of this item. For some items, a keyboard shortcut may also display as an alternative for activating this feature.

List (4) ways minimize the Ribbon in Excel?

If you want to show more lines on the screen or you do not want to display the Ribbon, you can minimize it. To minimize the Ribbon, use one of the following methods: 1) Point at the Ribbon Display Options () button at the upper right of the screen, then click Show Tabs, or 2) Right-click anywhere on the Ribbon and then click Collapse the Ribbon, or 3) Double-click on any Ribbon tab, or 4) press CTRL+F1.

What are circular references

Indicator appears in the status bar if Excel finds this problem in the current worksheet. A circular reference occurs when a formula in one cell references another cell that references back to the first cell, either directly or indirectly through other cells. Excel will display the double-headed blue arrow between these offending cells. You will learn more about cell references later in this courseware.

Quick Access Toolbar

Located above the Ribbon, this provides quick access to frequently used commands. You can customize the toolbar to contain commands you use regularly.

Title Bar

Located at the top of the screen, the title bar indicates the contents of the window (for example, Book1, Department Budget). It may also show the text [Compatibility Mode] if the workbook you are using has been saved to be compatible with a previous version of Excel. If more than one window is open on the screen, the one with a title bar that has a darker color or intensity is the active window.

Minimize, Maximize, Restore Down, Close area

Located in the upper right hand corner of the window, these buttons enable you to minimize ( ) the application window to a button on the taskbar, maximize ( ) the program to full screen, restore ( ) the window to its original size, or close ( ) the application window.

Name Box

Located on the left below the Ribbon, this displays the cell address of the active cell. For example, if the Name Box displays A21, this indicates that A21 (the cell at the intersection of column A and row 21) is the active cell. In the example on the previous page, three cells are selected. Cell B6 is the upper leftmost cell of that cell range and therefore its cell address is displayed in the Name Box to designate it as the active cell.

Formula Bar

Located to the right of the Name Box, the Formula Bar displays the contents of the active cell. Under certain circumstances, the Formula Bar can be used to make entries into the worksheet.

Dialog launcher box

Many Ribbon Groups include a dialog box launcher button. By hovering the mouse cursor over it, the Screen Tip will display a summary of its purpose, as demonstrated in this example:

How do you access the Ribbon using the keyboard

Press ALT or F10 to display the keyboard buttons for the commands in the Ribbon.

LEFT, RIGHT, UP, DOWN ARROW

Press one of these directional keys to move one cell at a time.

CTRL+HOME

Press this key combination to move to cell A1, regardless of where you are in the worksheet.

CTRL+END

Press this key combination to move to the last cell in the data table.

HOME

Press this key to move to column A in the current row.

Column Headings

Sequential letters at the top of each column enable you to track columns.

Row Headings

Sequential numbers on the left side of each row enable you to track rows.

Quick Access Toolbar

The Quick Access Toolbar (also known as QAT) is located at the left of the title bar above the Ribbon and contains buttons for frequently used commands. By default, this toolbar contains the Save, Undo, Redo, and Customize Quick Access Toolbar buttons.

Zoom Slider

The buttons at either side of the slider allow you to increase or decrease the zoom by 10%, or you can drag the slider button to choose a particular zoom percentage. Excel displays the current zoom percentage in the Zoom level button, at the right of the View buttons. You can also click this button to set a custom or specific zoom percentage.

Active Cell

The cell on which the cell pointer is positioned. You enter text or other values into the active cell in the worksheet. Only one cell can be the active cell at any given time.

Sheet Tab

The rectangular box at the bottom of a worksheet by which the worksheet is accessed and identified. Each workbook contains one or more worksheets, and each worksheet has a unique name that appears on the worksheet tab.

What rules do workbook names have to follow?

Workbook names must follow the same basic rules as naming files in Windows: 1) A maximum of 255 characters (including the drive and folder path), and none of these characters: / \ : * ? " < >| 2) File names should be descriptive so that you can identify the contents quickly. 3) Excel automatically assigns a .xlsx extension or file type at the end of the file name, so you need not do this. You only have to type in the name for the workbook.

What happens if you are using using Excel 97, 2000, 2002, or 2003?

You must save your workbook as a new and different file using the older format to enable them to open it. These workbooks use the file extension of .xls. To save a workbook in this format, click File, click Save As, and then click the arrow for Save as type and select Excel 97-2003 Workbook.