{"iconType":"icon","icon":"plus","color":"#ffa039","hotspots":[{"position":{"x":3.0112923462986196,"y":16.604580573951434},"alwaysFullscreen":false,"content":[{"params":{"text":"

Displays the name of the current cell in the worksheet<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"f2330622-69d4-4e91-8730-90ab86b629da"},{"params":{"contentName":"Image","file":{"path":"images\/file-5f666e6611d4e.png","mime":"image\/png","copyright":{"license":"U"},"width":190,"height":99},"alt":"a screenshot of the name box"},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"0cecf513-2cf1-4890-af47-33924c77acaf"}],"header":"Name Box"},{"position":{"x":48.0552070263488,"y":16.514900662251655},"alwaysFullscreen":false,"content":[{"params":{"text":"

Displays the formula that underlies the current cell. The figure displayed in the cell is the result of this formula.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"cea68366-216d-43f0-b49f-158d79ead247"}],"header":"Formula Bar"},{"position":{"x":6.398996235884567,"y":13.776214128035319},"alwaysFullscreen":false,"content":[{"params":{"text":"

These commands are similar to their counterparts in Word. The same keyboard shortcuts also apply. Cut (CTRL + X), Copy (CTRL + C) and Paste (CTRL + V)<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"dc9f73dc-5466-489b-b626-b0b88c7277a3"}],"header":"Clipboard Group"},{"position":{"x":16.06022584692597,"y":13.90728476821192},"alwaysFullscreen":false,"content":[{"params":{"text":"

These commands are similar to their counterparts in Word.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"e29b4348-8532-47b6-b59f-b9eb6470a373"}],"header":"Font Group"},{"position":{"x":29.109159347553327,"y":13.59685430463576},"alwaysFullscreen":false,"content":[{"params":{"text":"

Unlike in Word, commands for vertical alignment appear in addition to those for horizontal alignment.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"8559f2f8-935f-4b19-a7ca-b993287b640f"},{"params":{"contentName":"Image","file":{"path":"images\/file-5f6671246dbf4.png","mime":"image\/png","copyright":{"license":"U"},"width":270,"height":94},"alt":"a screenshot of the alignment group"},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"0e7e1076-2d14-4b4f-98ed-60ee8dcce2e7"}],"header":"Alignment Group"},{"position":{"x":24.341279799247175,"y":10.76158940397351},"alwaysFullscreen":false,"content":[{"params":{"text":"

Unlike in Word, you cannot use the TAB key to indent text. Increase indent will move content away from the left border and decrease indent will move content closer to the left border. (The TAB key will move the selector to the next cell.)<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"9cd2935c-0b36-4020-ab7c-882583e999d3"},{"params":{"contentName":"Image","alt":"A screenshot of the decrease indent and increase indent commands","file":{"path":"images\/file-5f666d82c95f5.png","mime":"image\/png","copyright":{"license":"U"},"width":264,"height":91}},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"cc6c81d1-fbfd-4178-999a-8b76e9053a0b"}],"header":"Decrease Indent + Increase Indent"},{"position":{"x":28.356336260978672,"y":7.871136865342164},"alwaysFullscreen":false,"content":[{"params":{"text":"

This command will make all of the text in a cell visible by forcing it to appear on more than one line.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"852f64c2-016f-4bec-a83a-3541df27a888"},{"params":{"contentName":"Image","alt":"a screenshot of the wrap text command","file":{"path":"images\/file-5f666e7b607a3.png","mime":"image\/png","copyright":{"license":"U"},"width":264,"height":93}},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"2e5e2227-e59d-4357-b97d-9eabe4a3c5cf"}],"header":"Wrap Text"},{"position":{"x":36.01003764115433,"y":13.589955849889623},"alwaysFullscreen":false,"content":[{"params":{"text":"

By default numbers are formatted as \"General\" in Excel. Click on the dropdown menu to identify a specific type of format for this content.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"223b0844-82e0-4b4c-adf4-1c96b99c5bf7"},{"params":{"contentName":"Image","file":{"path":"images\/file-5f666f6d412e6.png","mime":"image\/png","copyright":{"license":"U"},"width":199,"height":548},"alt":"a screenshot of the number formats"},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"044a4666-3e8a-4277-b4d8-1f220eb94947"}],"header":"Number Group"},{"position":{"x":57.84190715181933,"y":13.790011037527595},"alwaysFullscreen":false,"content":[{"params":{"text":"

You can quickly change the appearance of certain cells by using these preconfigured styles.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"5c5e4fe2-4b10-4339-b72c-34a54f9ee6ed"}],"header":"Styles Group"},{"position":{"x":42.28356336260979,"y":8.02980132450331},"alwaysFullscreen":false,"content":[{"params":{"text":"

By using the conditional formatting command you can cause the appearance of cells to change according to contextual factors such as their value or the date.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"a473b8dd-0bd6-4c75-ad32-57f11c2541f7"},{"params":{"contentName":"Image","file":{"path":"images\/file-5f666d5152ced.png","mime":"image\/png","copyright":{"license":"U"},"width":134,"height":86},"alt":"A screenshot of the conditional formatting command"},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"f8da3efd-1acd-4299-b00a-952e686e668c"}],"header":"Conditional Formatting"},{"position":{"x":79.79924717691343,"y":13.748620309050771},"alwaysFullscreen":false,"content":[{"params":{"text":"

Although the labels that organize the rows and columns always appear in the same order, once data has been entered in a worksheet you can create new rows and columns that will effectively split the existing data.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"37658565-bb06-4072-9ce5-2d2d531b8873"}],"header":"Cells Group"},{"position":{"x":87.8293601003764,"y":13.727924944812361},"alwaysFullscreen":false,"content":[{"params":{"text":"

The editing group contains commands that allow you to manipulate worksheet data in useful ways.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"f90e8c49-5c03-488b-a802-d3be52d7ad33"},{"params":{"contentName":"Image","file":{"path":"images\/file-5f666a42f3991.png","mime":"image\/png","copyright":{"license":"U"},"width":190,"height":100},"alt":"A screenshot of the editing group commands"},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"0548a879-6f26-4de5-8d1c-4662b044b7bf"}],"header":"Editing Group"},{"position":{"x":85.69636135508155,"y":7.08471302428256},"alwaysFullscreen":false,"content":[{"params":{"text":"

This is a shortcut for one of the most commonly used functions in Excel. When you select a cell that's adjacent to a continuous series of numbers and select AutoSum, Excel will \"guess\" which numbers you wish to add together. You will be able to see a visual representation of the proposed formula before confirming the selection. Clicking on the arrow will reveal a dropdown menu for other functions (Average, Count Numbers, Max, Min).<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"da34eafc-1f34-4acc-890d-491a8de26ae7"},{"params":{"contentName":"Image","file":{"path":"images\/file-5f666b6934696.png","mime":"image\/png","copyright":{"license":"U"},"width":153,"height":155},"alt":"a screenshot of the common formula commands"},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"3c51d625-cbb6-49f4-a419-254f6d857cb1"}],"header":"AutoSum"},{"position":{"x":84.9435382685069,"y":11.699779249448124},"alwaysFullscreen":false,"content":[{"params":{"text":"

Use this command to clear \"All\" (everything) from a cell, or click on the arrow to reveal other options (Clear Formats, Clear Contents, Clear Comments, Clear Hyperlinks)<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"c435d6a0-4691-4eeb-bdc3-4c7ada5d9d12"},{"params":{"contentName":"Image","alt":"A screenshot of the clear commands","file":{"path":"images\/file-5f666bf03fd6e.png","mime":"image\/png","copyright":{"license":"U"},"width":168,"height":181}},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"1959440d-cda4-4fc7-996d-1c87a616c7ac"}],"header":"Clear"},{"position":{"x":89.0840652446675,"y":8.809326710816777},"alwaysFullscreen":false,"content":[{"params":{"text":"

Use sort to reorganize data in alphabetical or numerical order and use filter to implement an interface that allows you to narrow down which data appears.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"0c998b79-53bd-4921-a1d7-a22f29d02eba"},{"params":{"contentName":"Image","file":{"path":"images\/file-5f66697de8919.png","mime":"image\/png","copyright":{"license":"U"},"width":183,"height":93},"alt":"a screenshot highlighting the Sort & Filter command"},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"8b2138b2-7197-4eee-bebf-e975cddf36a1"}],"header":"Sort & Filter"},{"position":{"x":16.18569636135508,"y":34.61644591611479},"alwaysFullscreen":false,"content":[{"params":{"text":"

The worksheet is divided into numerous cells, each of which can be identified by letter and number coordinates.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"2b5caf12-6cf8-4af4-80da-ad650407b43b"}],"header":"Worksheet"},{"position":{"x":33.12421580928482,"y":19.363962472406183},"alwaysFullscreen":false,"content":[{"params":{"text":"

Letters across the top of the worksheet label each column. Click on a letter to select the entire column.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"460f49fb-b2ca-41e5-9123-d0f8d5e94f18"}],"header":"Columns"},{"position":{"x":0.7528230865746549,"y":34.35430463576159},"alwaysFullscreen":false,"content":[{"params":{"text":"

Numbers down the left side of the worksheet label each row. Click on a number to select the entire row.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"6bc7052d-96fe-4732-ac4d-29e5e7d72c46"}],"header":"Rows"},{"position":{"x":6.775407779171895,"y":90.26628035320088},"alwaysFullscreen":false,"content":[{"params":{"text":"

The contents of the current worksheet belong to this tab. Rigth-click on this to rename the tab.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"3961dc30-55a0-4d23-802b-7fd256b7ea33"}],"header":"Worksheet Tab"},{"position":{"x":10.790464240903388,"y":90.17660044150111},"alwaysFullscreen":false,"content":[{"params":{"text":"

Click on the plus sign to add an addtional worksheet to the workbook.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"7bc57a27-2af2-4a36-9bd7-0ab5e901460b"}],"header":"New Tab"},{"position":{"x":54.8306148055207,"y":2.2282008830022075},"alwaysFullscreen":false,"content":[{"params":{"text":"

The workbook can contain one or more worksheets. The Excel file's name appears here.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"12d1a1c0-ce06-4047-967f-b92051e05664"}],"header":"Workbook Name"},{"position":{"x":94.6047678795483,"y":95.73675496688742},"alwaysFullscreen":false,"content":[{"params":{"text":"

Slide to the left (or click on the minus sign) to make the content appear smaller; slide to the right (or click on the plus sign) to make the content appear larger.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"fe527cf8-6f8f-46d5-9291-bb1fd0f6699a"}],"header":"Zoom"},{"position":{"x":87.8293601003764,"y":92.99806843267108},"alwaysFullscreen":false,"content":[{"params":{"text":"

Change the interface to see how the content of the worksheet will fit on a printed page.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"82434c5f-6f7a-475b-9a7f-5e2fad2898ad"}],"header":"Page Layout"},{"position":{"x":89.96235884567126,"y":92.90838852097131},"alwaysFullscreen":false,"content":[{"params":{"text":"

Change the interface to see where the page breaks would occur if you were to print this worksheet.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"6c9cbf57-7671-4bf3-ab1e-c2063768d43f"}],"header":"Page Break Preview"}],"hotspotNumberLabel":"Hotspot #num","closeButtonLabel":"Close","image":{"path":"images\/image-5f665908c9825.png","mime":"image\/png","copyright":{"license":"U"},"width":1920,"height":1080},"backgroundImageAltText":"A screenshot of the home tab interface for Excel 2019"}

Excel 2019: Identification of the elements of the main interface

Scott Tanaka