{"iconType":"icon","icon":"plus","color":"#981d99","hotspots":[{"position":{"x":23.200000000000003,"y":26.352896341463417},"alwaysFullscreen":false,"content":[{"params":{"text":"

The Formula bar allows user to view what is in the cell, adjust a formula or type text in a cell if needed.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"7394ea76-299d-4e4a-b5f0-3c3c68a88799"}],"header":"What can a user do in this area?"},{"position":{"x":8.237986270022883,"y":54.28714412811389},"alwaysFullscreen":false,"content":[{"params":{"text":"

A cell gets it's address\/location from the column and row, for example A(column)1(row).<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"0852d745-d4d9-43a2-a84e-9a508dc667d6"}],"header":"How does this item get a cell address?"},{"position":{"x":6.636155606407322,"y":95.23187277580071},"alwaysFullscreen":false,"content":[{"params":{"text":"

A worksheet tab can be created by clicking on the + sign.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"63789daa-76ff-4801-8bea-b69ecbc90861"}],"header":"How would you create a new one of these?"},{"position":{"x":2.402745995423341,"y":24.70529359430605},"alwaysFullscreen":false,"content":[{"params":{"text":"

A name box allows users to type a cell address to navigate anywhere in the sheet or define a cell name.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"fd9890f0-0d64-4f6d-8d6a-06f590b1d59a"}],"header":"What is this item and how can it help navigate in the sheet?"},{"position":{"x":40.503432494279174,"y":9.202624555160142},"alwaysFullscreen":false,"content":[{"params":{"text":"

The wrap text can help make long text visible in a cell by wrapping it into multiple cells.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"980407cb-7b5d-4011-9eb0-7f0d91ace56e"}],"header":"How can this feature help a user?"},{"position":{"x":57.09382151029748,"y":18.788923487544483},"alwaysFullscreen":false,"content":[{"params":{"text":"

Conditional formatting can help easily spot trends and patterns in your data using colored bars, highlighting, and icons based on rules.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"707faef3-25db-4913-98ef-2bebc9a53649"}],"header":"What does this feature do?"},{"position":{"x":10.068649885583524,"y":18.76668149466192},"alwaysFullscreen":false,"content":[{"params":{"text":"

The Font group has many useful features for formatting, such as Bold, Italics, Font style and size.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"eca01112-67e8-452d-b87d-b242a491e1b0"}],"header":"What features can you find in this group on the Home tab?"},{"position":{"x":76.77345537757438,"y":18.032695729537366},"alwaysFullscreen":false,"content":[{"params":{"text":"

The Editing group has features such as Sort and Filter of data sets, Find and replace data, and the Auto Sum where users can quickly choose a simple function to perform calculations.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"af83d4a8-4a18-45bf-9455-f49ea5b6c999"}],"header":"This group on the Home tab can allow the user do what?"},{"position":{"x":88.21510297482837,"y":29.042482206405694},"alwaysFullscreen":false,"content":[{"params":{"contentName":"Image","file":{"path":"images\/file-619313032381f.png","mime":"image\/png","copyright":{"license":"U"},"width":334,"height":766},"alt":"Right click menu in Excel when user right clicks on a column header.","title":"Users can cut, copy, paste, insert or delete columns, format cells and column widths."},"library":"H5P.Image 1.1","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"adb53723-1bae-475d-8c72-0bf3fc9da592"}],"header":"Right clicking on a column header letter will give what options (hover over image to reveal)?"},{"position":{"x":87.98627002288329,"y":95.54048042704626},"alwaysFullscreen":false,"content":[{"params":{"text":"

Users can change their display settings and zoom in or out to view data better.<\/p>\n"},"library":"H5P.Text 1.1","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"bd1cd1cf-d865-4f52-b20e-646e72d78aa1"}],"header":"The bottom right of the Excel screen has what options?"},{"position":{"x":49.65675057208238,"y":63.66770462633452},"alwaysFullscreen":false,"content":[{"params":{"visuals":{"fit":true,"controls":true,"poster":{"path":"images\/poster-6193169232821.png","mime":"image\/png","copyright":{"license":"U"},"width":762,"height":426}},"playback":{"autoplay":false,"loop":false},"l10n":{"name":"Video","loading":"Video player loading...","noPlayers":"Found no video players that supports the given video format.","noSources":"Video is missing sources.","aborted":"Media playback has been aborted.","networkFailure":"Network failure.","cannotDecode":"Unable to decode media.","formatNotSupported":"Video format not supported.","mediaEncrypted":"Media encrypted.","unknownError":"Unknown error.","invalidYtId":"Invalid YouTube ID.","unknownYtId":"Unable to find video with the given YouTube ID.","restrictedYt":"The owner of this video does not allow it to be embedded."},"sources":[{"path":"videos\/sources-61931a8b2a052.mp4","mime":"video\/mp4","copyright":{"license":"U"}}]},"library":"H5P.Video 1.6","metadata":{"contentType":"Video","license":"U","title":"How would you create a new workbook?"},"subContentId":"f21f86be-8f00-4514-b78f-dc5c16c53c67"}],"header":"Creating a new workbook"}],"hotspotNumberLabel":"Hotspot #num","closeButtonLabel":"Close","image":{"path":"images\/image-619307cda0f87.png","mime":"image\/png","copyright":{"license":"U"},"width":2736,"height":1744},"backgroundImageAltText":"Blank Excel Workbook"}

Excel- Intro to Workbook Features

Pamela LeBrun