Welcome to this book, designed to help you study for and pass the MO‐200 Microsoft Excel (Excel and Excel 2019) exam and become a certified Microsoft Office Specialist: Excel Associate. If you're all settled in, it's time to get this show on the road.
In this chapter, I'll start by showing you how to import data in other formats into Excel spreadsheets, which Excel calls worksheets, as well as collections of spreadsheets that Excel calls a workbook. Next, I'll show you how to navigate within a workbook and get comfortable with the Excel interface.
When you feel good about creating an Excel spreadsheet, I'll show you how to format that spreadsheet so that it looks the way you want. You'll also learn how to change the way information is presented to make Excel work better for you.
Finally, I'll show you how to get your spreadsheets ready to share in print and online. You'll also learn how to inspect your workbooks so that you can find and remove hidden properties as well as fix any issues with accessibility and compatibility.
I'll have an exercise at the end of every section in this chapter so that you can practice doing different tasks. Then, at the end of this chapter, you'll find a set of Review Questions that mimic the test questions you'll see on the MO‐200 exam.
If you need to import existing data into a workbook, you should first check to see if the file is in a format that Excel likes. The most common formats are the native Excel, text, and comma‐delimited value (CSV) formats.
The native Excel format has the
.xls
filename extension that dates all the way back to MS‐DOS days, so you can obviously open those files. However, if you open an older XLS file, you may experience some issues with formatting.
It is more likely that you will receive files in text format with the
.txt
file extension and in comma‐separated values (CSV) format with the
.csv
file extension. These two formats are what Microsoft focuses on in the MO‐200 exam.
Text and CSV formats use a delimiter, which is a character that separates blocks of text, like between numbers. A text file will use a tab character to separate those blocks. A CSV file uses commas to separate each block of text.
After you open a text file, Excel does not change the format of the file. The file remains with the
.txt
or
.csv
extension as you save updates to it.
When you receive a text file from someone else, check the file to ensure that it has a delimiter character. (If you don't see any, then you must decide whether to add the delimiter character or just return the text file to the sender and tell that person to fix the file.)
Once you are satisfied that the text file is ready for Excel, open the text file as follows:
The Text Import Wizard dialog box opens (see Figure 7.1) and shows you what the text file looks like in step 1 of the wizard. Click the Next button to see what the text will look like in an Excel worksheet, and then click Next again to see the data format Excel assigns to each column.
Though you can make changes in each of these steps, you don't need to know how to do that for the MO‐200 exam. So, click the Finish button to view the imported spreadsheet.
If you have text in another file that you want to place into a new worksheet within a workbook, here's how to do it:
The preview dialog box opens and shows you how the text will appear in the file. Click Load to import the data into a new worksheet with the name Sheet1, as you can see in the list of spreadsheet tabs at the bottom of the Excel window.
A CSV file is formatted specifically to be imported into spreadsheet software, and Excel knows CSV formatting cold. Each cell in a row is on one line of text separated by a comma with no spaces before or after the comma. For example:
Title, Column 1, Column 2
Excel considers each line in a CSV file to be one row, so you may have a CSV file that looks like this:
Date, Payee, Amount, Notes
10/1, InsuranceCo, $400.00, Quarterly insurance payment
A comma does not appear at the end of a line.
Add a CSV format file by following these steps:
The Text Import Wizard dialog box opens (see Figure 7.3) and shows you what the text file looks like in step 1 of the wizard. Click the Next button to see what the text will look like in an Excel worksheet, and then click Next again to see the data format that Excel assigns to each column.
You can also add a CSV file into a new worksheet within a workbook, much as you did with a text file, as follows:
The preview dialog box appears, as shown in Figure 7.4, and it shows you how the text will appear in the file. Click Load to import the data into a new worksheet with the name Sheet1, as you can see in the list of spreadsheet tabs at the bottom of the Excel window.
After you populate a workbook, it can seem daunting to try to find the data within it. Excel has tools that make it easy.
Click the Search box in the Excel title bar, and then type the text that you want to find.
You can search for data on any worksheet in a workbook by following these steps:
The Find And Replace dialog box appears so that you can search for information or replace one or more search terms, including specific formatting, with new text and/or formatting. If you want to replace text, select the Replace tab.
Now you can replace text by typing the text you want to replace in the Find What text box, and then typing the replacement text in the Replace With text box.
Before you find and/or replace text, you may need to specify more information about what you want to find and/or replace. For example, you may want to change not only text in a cell, but also change the font and alignment of that text.
Open all find and replace options by clicking Options in the dialog box. The Find And Replace dialog box expands (see Figure 7.5) so that you can click one of the buttons or boxes to change information, as follows:
When you're ready to search for the text that you typed in the Find What text box, click the Find Next button to go to the next instance of the text in the open worksheet. If you search in the entire workbook, Excel searches for the text in the open worksheet first, and then it proceeds to search for all other instances of the text in subsequent worksheets.
If you click Find All, a dialog box appears that lists every instance of the text that Excel found in the worksheet or in the entire workbook. Click the instance in the list to open the cell in the corresponding worksheet.
Click Replace to replace only the next instance of the text with your replacement. If you want to replace any other text that meets your criteria, click the Replace button again to go to the next instance and replace that.
Replace all instances of the text and/or formatting in the Find text box by clicking the Replace All button. When Excel completes its search, a dialog box appears in the middle of the screen and tells you how many changes it made. Close the dialog box by clicking OK.
Excel allows you to define names for a specific cell or for a range of cells, such as a block of income for a specific month. Here's how:
Now that you named a cell, go to another location in your worksheet or another worksheet in the workbook. You can find that named range by following these steps:
Excel highlights the named range within its worksheet.
You can install as many hyperlinks as you want within the text of your workbook. After you insert a hyperlink, Excel gives you control over copying or moving a hyperlink, changing a hyperlink, and removing a hyperlink.
Start by clicking in the cell where you want to add the hyperlink, and then click the Insert menu option. In the Insert ribbon, click the Link icon, as seen in Figure 7.8. (If the Excel window width is small, click the Links icon in the ribbon and then click the Link icon.)
The Insert Hyperlink dialog box appears (see Figure 7.9) so that you can add your hyperlink.
You can add a hyperlink within the same worksheet, to another worksheet in your workbook, to another file or web page, or to an email address.
Adding a hyperlink to another location in a worksheet or workbook is useful when you need to move between cells quickly, and especially if you have long worksheets, many worksheets in a workbook, or both.
Start by clicking the cell and then opening the Insert Hyperlink dialog box. In the Link To box on the left side of the dialog box, click Place In This Document, as shown in Figure 7.10.
In the Type The Cell Reference text box, you can type the cell that you want to link to by typing the column letter and then the row number. For example, typing C24 will link to the cell in column C, row 24.
If you want to link to a specific worksheet in your workbook, click the worksheet name under the Cell Reference header in the Or Select A Place In This Document list box.
You can select a named range by scrolling down in the list (if necessary) and then clicking the range name under the Defined Names header.
When you're done, click OK and the hyperlink appears within the text in the cell.
You can add a hyperlink to another file, such as a Word file, that is important to your readers. When you link to another file, the appropriate program, such as Word, opens to view the linked file. Here's how to link to an existing file:
You can add a hyperlink to a web page either on the web or on your network. That web page can be the home page, in which case you only need to type the URL of the site. If you need to link to a specific web page, you must type the full URL, including the web page name. You can also view recently browsed pages and select the page from the list.
When you link to a website, the default web browser opens and displays the page (or an error if the link is incorrect). Here's how to link to a web page:
http://
or https://
before the website and any specific web pages.The link appears in the cell, and you can click the link to see if it opens the web page.
Excel allows you to open a new email message so that you can send a message to that email address. You can also add a subject to the message. When you click the link, the default email program opens a new message window so that you can begin typing your message to the recipient.
Link to an email address by following these steps:
Once you create a hyperlink, you can copy it or move it to another cell. Here's how to do this:
Excel allows you to change a hyperlink in a cell in one of three ways:
Start by clicking on a location in the cell that is outside the text with the link. If you can't, then click an adjacent cell and then use the arrow keys on your keyboard to highlight the cell with the hyperlink. (You will learn to change column widths and row height later in this chapter.)
Now you can open the Edit Hyperlink dialog box the same way you did when you inserted a hyperlink. The Edit Hyperlink dialog box appears (see Figure 7.14) and shows you the details of your hyperlink.
For example, if you link to an email address, then the E‐mail Address option is selected in the Link To box, and you can see the email address and subject (if there is one) so that you can update that information quickly.
If you need to change the linked text that appears in the hyperlink, you can do so in the Text To Display box at the top of the dialog box.
When you finish making your changes, click OK. If you changed the link destination or email address, you may want to click the link to make sure that it works the way you expect.
You can change an existing hyperlink in your workbook by changing its destination, its appearance, or the text or graphic that is used to represent it.
If you need to delete hyperlinked text in a cell, all you have to do is right‐click the cell that has the link. In the context menu, as seen in Figure 7.15, click Remove Hyperlink. The link disappears from the text.
You can also delete the text in the cell as well as the link by right‐clicking on the cell and then clicking Clear Contents in the context menu.
As you work with Excel, you may want to format how worksheets in a workbook appear, perhaps because you want it to look that way, people with whom you share the workbook expect it to look a certain way, or both. Excel allows you to modify the page settings, adjust the height of rows and the width of columns, and add headers and footers to pages, much as you would in a Word document.
When you need to modify page settings, begin by clicking the Page Layout menu option. The Page Setup section in the Page Layout ribbon (see Figure 7.16) shows you all the tools that you can use to change the page settings.
All of these icons appear in the ribbon no matter whether your window width is 800 pixels, as seen in Figure 7.16, or larger. Click one of the following options to make changes:
Excel has default row heights and column widths, but you may have to change those for readability. For example, you may need to extend the column width so that you can see all of the text in a cell within that column. The minimum, default, and maximum heights for rows and columns are as follows:
Here's how to change the column width:
Excel has a built‐in AutoFit feature that allows you to fit the width of the contents automatically. AutoFit a column by following these steps:
The column width changes to accommodate the text in the cell with the longest width.
If you want more than one column to have the same width, here's how to do that:
When you move the mouse pointer over the icon, the column width changes automatically so that you can preview the width of the column before you click the icon. If you move the mouse pointer away from the icon, the column reverts to its previous width.
If all you need is one width for all columns within a worksheet, change the default width by following these steps:
Excel resizes all columns in the worksheet to the width you specified.
When you want to change the width of a column by using the mouse, move the mouse pointer to the right border of the column heading above the worksheet. The cursor changes to a double‐headed arrow, as shown in Figure 7.21.
Now you can click, hold, and drag the boundary of the column heading to the left or right. As you drag, the width of the column to the left of the pointer changes, and a pop‐up box above the pointer shows you the exact width of the column. When the column is the size that you want, release the mouse button.
When you want to set a row to a specific height, the process for doing so is much the same as setting a column to a specific width, as follows:
Excel resizes the row and vertically aligns the text at the bottom of the cells in the row.
As with columns, the built‐in AutoFit feature allows you to fit the height of rows automatically to match the largest height in a row. Here's how to do this:
The row height changes to accommodate the text in the cell with the largest height.
You can change the height of a row more quickly by using the mouse. Start by moving the mouse pointer to the bottom border of the row heading to the left of the worksheet. The cursor changes to a double‐headed arrow, as shown in Figure 7.24.
Now you can click, hold, and drag the boundary of the row heading up and down. As you drag, the height of the row above the pointer changes, and a pop‐up box above the pointer shows you the exact height of the row. When the row is the size that you want, release the mouse button.
As with a Word document, you can add headers and footers into an Excel spreadsheet that will make it easier for users who view your documents in paper or PDF format to read it. For example, a header can include the title of the document and the footer can include a page number. Excel also makes it easy to customize headers and footers.
Add a header and footer into a worksheet by clicking the Insert menu option. In the Text section in the Insert menu ribbon, click the Header & Footer icon in the Text section (see Figure 7.25).
The worksheet appears in Page Layout view with the cursor blinking within the middle section of the header. The cursor is in the center position so that the text will be centered on the page.
Click the left section of the header to place the cursor so that it is left‐aligned in that section. Click the right section of the header to place the cursor right‐aligned in that header. The text in all three sections in the header are vertically aligned at the top.
The Header & Footer ribbon appears automatically so that you can add a footer by clicking the Go To Footer icon in the Navigation section. The footer section appears at the bottom of the spreadsheet page with the cursor blinking in the center section of the footer.
Like the Header section, the footer is divided into three sections, but the text in all three sections is vertically aligned at the bottom. You can return to the header by clicking the Go To Header icon in the ribbon.
Excel contains a number (ahem) of features for adding header and footer elements so that you don't have to update them automatically, such as with a page number.
After you add a header or footer and you have clicked within a section, the Header & Footer ribbon appears. You can add built‐in elements from the Header & Footer and the Header & Footer Elements sections.
In the Header & Footer section in the ribbon, click the Header icon to view a list of built‐in header elements that you can add (see Figure 7.26).
Some entries in the list have two or three options. An entry with two elements will place them in the header sections specified within the built‐in entry. For example, the page number appears in the center section and the worksheet name appears in the right section.
After you select a header element from the drop‐down list, Excel adds the header automatically and places the cursor back in the worksheet so that you can resume your work.
If you click within a footer, you can add a built‐in footer element by clicking the Footer icon and then selecting a built‐in footer element from the drop‐down list. Once you do, Excel adds the footer and places the cursor in the worksheet.
The Header & Footer Elements section contains nine elements, as shown in Figure 7.27.
When you click one of the buttons (except for Format Picture, which is only active after you add a picture), its field name appears within brackets and preceded by an ampersand (
&
), such as
&[Date]
. Some fields are preceded by text, such as
Page &[Page]
.
After you add the element and click outside the header or footer, the element appears properly. Click one of the icons in the ribbon to add the element.
If you need to delete the element, double‐click the element name to select it, and then press Delete on the keyboard. The header and footer remain in the document, and the page separator dashes appear in the worksheet.
You can delete the header and footer from the entire workbook by following these steps:
Excel offers you plenty of ways to change the options that you can access as you work in a workbook, as well as what you see in ribbons and toolbars so that you can get your work done more quickly.
You can customize the Quick Access Toolbar, create and modify custom views, and freeze rows and columns in a worksheet so that they don't move as you navigate within a worksheet.
Excel includes a toolbar for accessing tools and commands quickly without having to click the menu option and then find the option in the ribbon. Microsoft naturally calls this the Quick Access Toolbar, and you can add features from a ribbon to the toolbar.
The toolbar itself appears at the left side of the Excel window title bar, but you can move the toolbar below the ribbon instead. By default, there are only four commands that you can access in the toolbar:
You can add a command to the toolbar in one of two ways. The first is to add the command from a ribbon. The other is to add a command from the Customize Quick Access Toolbar menu.
Whenever you're in a ribbon and you see an option that you want to add to the Quick Access Toolbar, here's what to do:
You see the new icon at the right side of the toolbar, as you can also see in Figure 7.29.
You can also add a command from the Customize Quick Access Toolbar drop‐down menu. Start by clicking the down arrow at the right side of the Quick Access Toolbar in the Excel window title bar. If you haven't added any icons to the toolbar, you will see the icon to the right of the Redo icon.
Next, click one of the options without a check mark to the left of the command name in the drop‐down menu, as you can see in Figure 7.30. (You will learn how to remove options from the toolbar later in this chapter.)
There are two ways that you can remove a command from the Quick Access Toolbar:
In both cases, the icon disappears from the toolbar and you can go back to work.
By default, the Quick Access Toolbar appears within the Excel window title bar. You can move the toolbar below the ribbon, where it will stay even if you close Excel and reopen it.
All you need to do to move the Quick Access Toolbar is click the down arrow at the right side of the toolbar and then click Show Below The Ribbon. The toolbar appears under the ribbon (see Figure 7.31).
If you want to move the toolbar back, click the down arrow at the right side of the toolbar and then select Show Above The Ribbon from the drop‐down menu.
Follow these steps if you need to reset the Quick Access Toolbar to its default settings:
All of the commands that you added in the toolbar disappear, and you see only the four default options.
Excel allows you to change the view on the document so that you can zoom in and zoom out within a worksheet, but Excel only has five built‐in magnification levels, from 25 percent to 200 percent, as well as the ability to fit the worksheet to the window.
What's more, you can set your own custom view type. Here's how:
When you view your document, Excel allows you to create a custom view to make workbook content appear the way you prefer. You can save three different types of views:
You can also create multiple views, each with a different name.
Here's how to create a custom view in a worksheet:
When you want to show a view, open the Custom Views dialog box again. You see the view highlighted in the list, as seen in Figure 7.36. (If you have more views than the window can hold, scroll up and down in the list to find it.) Click the view name in the list, if necessary, and then click Show.
You see the changes in your view. For example, if your custom view is 150 percent, the view of your worksheet changes to 150 percent of the default magnification.
When you want to delete a custom view, follow these steps:
The view disappears from the list. Close the dialog box by clicking Close.
You can freeze a row or column in a worksheet so that a row and/or column remains visible on the worksheet even as you scroll through it. This feature is especially useful if you have header rows or columns to which you will need to refer as you scroll through a worksheet that doesn't fit in the Excel window.
If you only want to freeze the first column in the worksheet (that is, column A), follow these steps:
A darker line appears at the right edge of column A, which shows you that the column is frozen.
If you want to freeze only the first row in the worksheet (that is, row 1), follow these steps:
A darker line appears at the right edge of row 1, which shows you that the row is frozen.
You can select one or more columns or rows to freeze. However, you need to select the cell below the row(s) and to the right of the column(s) that you want to freeze. After you do that, follow these steps:
The line above the selected cell and the line to the left of the selected cell are darker. This means that all rows above the darker line and all columns to the left of the darker line are frozen.
If you decide that you no longer want a row and/or column frozen, here is how to unfreeze all rows and columns:
You only see the Unfreeze Panes option if you have one or more frozen rows and/or columns.
By default, Excel shows the worksheet in what it calls Normal view, which shows the worksheet. When you need to view the worksheet before you print it to your printer or to a PDF file, you can view where the page breaks are on each page in the Page Break Preview view, as well as how the worksheet will appear on each page in the Page Layout view.
View all the page breaks in your worksheet by first clicking the View menu option. Then, in the View ribbon, click the Page Break Preview icon in the Workbook Views section. The worksheet appears with page breaks, as shown in Figure 7.38.
Pages are bordered by a solid blue line. Page breaks are denoted by a dashed blue line. As you scroll up and down the pages, you see gray page numbers in the background, but Excel does not print these page numbers.
If you need to see how a worksheet appears on printed pages, as well as add a header and/or footer, you need to view your worksheet in Page Layout view.
Start by clicking the View menu option. In the View ribbon, click the Page Layout View icon. You see the worksheet contained within graphic representations of pages along with a ruler above and to the left of each page (see Figure 7.39).
Click Add Header at the top of the page and click Add Footer at the bottom of the page to add a header and footer, respectively.
If you're viewing the worksheet in Page Break Preview view or Page Layout view, you can return to Normal view by first clicking the View menu option. Then, in the View ribbon, click the Normal icon in the Workbook Views section.
Excel constantly keeps track of basic properties about your workbook, including the size of the workbook file, who last edited it, and when the workbook was last saved.
If you need to see these properties and add some of your own, click the File menu option. In the menu on the left side of the File screen, click Info. Now you see the Info screen, which is shown in Figure 7.40.
The Properties section appears at the right side of the screen. Scroll up and down in the Info screen to view more properties. Excel doesn't show all properties by default, but you can reveal the hidden properties by clicking the Show All Properties link at the bottom of the Properties section.
You can also add properties, including a workbook title, a tag (which is Microsoft's term for a keyword), and a category. For example, click Add A Title in the Properties section to type the workbook title in the box.
Excel gives you ways to display and hide formulas, as well as their results, from within a workbook. You can also protect the worksheet to keep your views from being changed by anyone with whom you share your workbook.
By default, Excel shows the results of a formula within the worksheet but only shows the formula in the Formula Bar above the worksheet.
You can display the formula by pressing Ctrl+`. The grave (
`
) accent is on the key with the tilde (
~
) on most keyboards. You can hide the formula again by pressing Ctrl+`.
When you show the formula in the worksheet, the width of the column changes to accommodate as much of the formula as possible. When you show the result again, Excel returns the column width to where it was before you displayed the formula.
You can hide a formula in the Formula Bar, but only if the worksheet is protected. After you click the cell or select a range of cells with formulas you want to hide, follow these steps:
The formula no longer appears in the Formula Bar.
Excel makes it easy to share workbooks with other people, such as people in the finance, sales, and marketing departments who need to see financial forecasts for the next quarter. Before you do that, you must determine what information you want to share.
You can set a print area within a worksheet, save your workbook in a different format, configure your print settings before you print a document to share on paper or electronically, and inspect your workbook so that you can hide information that you want to keep hidden.
If you print a specific area of rows and columns often, such as a summary of the company's profit and loss for the current quarter, Excel allows you to define a print area within a worksheet.
After you select the cells that you want in the print area within the worksheet, set the print area as follows:
Excel saves the print area after you save the workbook.
Microsoft realizes that you may need to save Excel workbooks in different formats to share them with other people who may have older versions of Excel, other spreadsheet apps (like Google Sheets), or no spreadsheet program at all. Rest easy—Excel has you covered.
Here's how to save a workbook in a different file format:
*.xlsx
) box.Excel saves a copy of the worksheet in the directory where you have the Excel worksheet. Your Excel worksheet remains active so that you can continue to work on it if you want.
Before you print to either a printed page or to PDF format, you can view the print preview settings and make changes in Excel.
Excel easily detects the default printer that you're using in Windows and lets you change the printer settings so that your document appears on paper the way you want.
Start by clicking the File menu option, and then click Print in the menu on the left side of the File screen. Now you see the Print screen, and the print preview area appears on the right side so that you have a good idea of what the worksheet will look like on the printed page.
Between the menu area on the left and the print preview area, the Settings menu you see depends on the printer you have.
In my case, I can change the printer to another one that I have installed in Windows, as shown in Figure 7.45. I can also change different settings for the selected printer, including how many pages to print, the page orientation, and whether I should print on one or both sides of the paper.
Before you share a workbook with other people, such as in an email attachment, you should take advantage of the Document Inspector in Excel to find information that you may not realize is saved with your workbook. For example, Excel saves author information, and you may not want to share that information when you share the workbook with someone outside your company.
Start by clicking the File menu option. Click Info in the menu bar on the left side of the File screen. Now that you're in the Info screen, click the Check For Issues button. From the drop‐down list, select Inspect Document.
Now you see the Document Inspector dialog box, as shown in Figure 7.46. Scroll up and down the list of content that Windows will inspect.
By default, the following check boxes next to the content category names are selected:
These check boxes mean that the Document Inspector will check content in all those areas. Select Ink, the only clear check box, if you want to check whether someone has written in the workbook with a stylus, such as the Microsoft Surface Pen.
When you decide what you want Excel to check out, click Inspect. When Excel finishes its inspection, you can review all the results in the dialog box.
The results show all content categories that look good by displaying a green check mark to the left of the category name. If Excel finds something that you should check out, you see a red exclamation point to the left of the category. Under the category name, Excel lists everything it found. Remove the offenders from your workbook by clicking the Remove All button to the right of the category name.
You can reinspect the workbook by clicking Reinspect as often as you want, until you see that all of the categories are okay. When you're done, click the Close button to return to the Info screen.
This chapter started by showing you how to import data stored in TXT and CSV files into Excel. Aside from Excel‐formatted files, you will most likely receive other files from text and CSV‐formatted files because those formats are ubiquitous.
Next, I discussed how to navigate within a workbook. You can search for data; navigate to named cells, ranges, and other workbook elements; and insert and remove hyperlinked text within a cell.
Then, you learned how to format worksheets and workbooks to look the way that you want. You learned how to modify the page setup, adjust row width and column height, and customize headers and footers.
You then went further by learning how to customize Excel and its options so that features in the Excel window look the way you want. Those customization features include customizing the Quick Access Toolbar, displaying and modifying the look of workbook content, freezing worksheet rows and columns, changing window views, modifying basic workbook properties, and displaying formulas.
Finally, you learned how to configure your content for collaboration. You learned how to set a print area in a worksheet and workbook, save a workbook in a different file format, configure your print settings, and inspect workbooks for issues, including hidden content that you don't want to share.
AutoFit | hyperlinks |
comma‐delimited value | range |
delimiter | wildcard |
footer | workbook |
formulas | worksheet |
header |
Understand how to import TXT and CSV files into a worksheet. Know how to import files in both TXT and CSV formats into a worksheet using the built‐in file import tools.
Know how to search for data in a workbook. Understand how to search for data by using the Find And Replace feature in Excel to find search terms in a worksheet or all the sheets in a workbook, and then replace your search term(s) with other terms and/or formatting.
Understand how to navigate to different elements in a workbook. Know how to go to different elements using the Go To feature to go to a specific cell, range of cells, or another worksheet in your workbook.
Know how to insert and remove hyperlinks. Understand how to insert a hyperlink within a cell and remove a hyperlink if you want.
Understand how to format worksheets and workbooks. Know how to use Excel formatting tools to format worksheets and workbooks, including how to modify the page setup, adjust row height and column width in a worksheet, and customize headers and footers.
Be able to set and change Excel options and spreadsheet views. Know how to change options and views, including how to customize the Quick Access Toolbar, display content in different views, modify workbook content in different views, change window views, freeze worksheet rows and columns, modify basic workbook properties, as well as display and hide formulas.
Know how to set a print area and configure print settings. Understand how to set a print area within a worksheet and configure your print settings, including changing the printer, the worksheet(s) to print, and the page orientation.
Understand how to save workbooks in other file formats. Know the file formats to which Excel can save a workbook, how to select the format you want, and how to save the workbook in your preferred format.
Be able to inspect workbooks for issues. Know how to inspect a workbook before you share it, including how to look for hidden information contained in the Excel file that you may not want to share, how to check for accessibility issues, and how to check for compatibility issues.
18.188.152.162