Excel MCAS Syllabus

I will try to fill in the belows with video/step by step screenshot

0.Office->1.New Worksheet Tab ->right click->Insert
0.Office->2.Open
0.Office->3.Save
0.Office->4.Save as
0.Office->5.Print
0.Office->6.Prepare->1.Properties
0.Office->6.Prepare->2.Inspect/Encrypt/Signature/Final/Compatibility
0.Office->7.Send
Q.Quick Access Toolbar->2-3 Undo Redo
Q.Quick Access Toolbar->Compare and merge workbooks
1.Home->1.Clipboard
1.Home->2.Font
1.Home->3.Alignment
1.Home->4.Numbers
1.Home->5.Styles->1.Conditional Format
1.Home->5.Styles->2.Format as Table
1.Home->5.Styles->3.Cells style
1.Home->6.Cells->1.Insert/2.Delete
1.Home->6.Cells->3.Format->1.Cell Sizes
1.Home->6.Cells->3.Format->2.Visibility
1.Home->6.Cells->1.Insert/2.Delete
1.Home->6.Cells->3.Format->2.Visibility
1.Home->6.Cells->3.Format->3.Organize Sheet
1.Home->6.Cells->3.Format->4.Protect
1.Home->6.Cells->3.Format->4.Format Cell
1.Home->7.Editing->1.Autosum
1.Home->7.Editing->2.Fill
1.Home->7.Editing->3.Clear
1.Home->7.Editing->3.Sort & Filter->1.Sort
1.Home->7.Editing->3.Sort & Filter->2.Filter
1.Home->7.Editing->4.Find
1.Home->7.Editing->4.Find
2.Insert->1.tables->1.Pivot Tables
2.Insert->1.tables->2.Table
2.Insert->2.Illustration>1.Picture/2.Clipart/3.Shape
2.Insert->2.Illustration>4.Smart Arts
2.Insert->3.Chart
C.Chart
2.Insert->4.Hyperlink
2.Insert->5.Text->1,3,4,5
2.Insert->5.Text->6-object
2.Insert->5.Text->2.header&footer H.header&footer
3.Page Layout->1.Themes
3.Page Layout->2.Page Setup->1.Margin
3.Page Layout->2.Page Setup->2.Orientation/3.Size 3.Page Layout->3.Scale to Fit
3.Page Layout->2.Page Setup->4 Print Area
3.Page Layout->2.Page Setup->5 Page break
3.Page Layout->2.Page Setup->6 Background
3.Page Layout->2.Page Setup->7 Print titles
3.Page Layout->4.Sheet Options
3.Page Layout->5.Arrange
4.Formula->1.Function Library Formula Bar
4.Formula->1.Function Library->Autosum/math
4.Formula->1.Function Library->math
4.Formula->1.Function Library->Lookup&Ref
4.Formula->1.Function Library->logical
4.Formula->1.Function Library->Text
4.Formula->1.Function Library->Financial
4.Formula->1.Function Library->Date&Time
4.Formula->1.Function Library->Insert function
4.Formula->2.Defined Name->1.Name Manager/2.Define Name/4.Create from selection
4.Formula->2.Defined Name->3. Use in formula
4.Formula->3.Formula Auditing->1.Trace Precedent/2.Dependents/3.Remove Arrows
4.Formula->3.Formula Auditing->4.Show Formula
4.Formula->3.Formula Auditing->5.Error Checking
4.Formula->3.Formula Auditing->6.Evaluate formula/7.watch
5.Data->1.Get External Data->1.From Access 4.From other Sources
5.Data->2.Conenction->3.Properties
5.Data->1.Get External Data->4.From other Sources 5.Data->2.Conenction->3.Properties
5.Data->1.Get External Data->2.From Web
5.Data->2.Conenction->3.Properties
5.Data->1.Get External Data->2.From Text
5.Data->4.Data tools->Text to Columns
5.Data->2.Conenction->4.Edit Links
5.Data->3.Sort&Filter->1.Sort
5.Data->3.Sort&Filter->2.Filter->1.Filter,Clear/Reapply
5.Data->4.Data tools->2.Remove Duplicates
5.Data->3.Sort&Filter->2.Filter->4.Advanced Filter
5.Data->4.Data tools->3.Validation
5.Data->4.Data tools->4.Consolidate
5.Data->4.Data tools->5.What-if->1.Scenario
5.Data->4.Data tools->5.What-if->2.Goal Seek
5.Data->4.Data tools->5.What-if->3.Table
5.Data->5.Analysis->Solver
5.Data->6.Outline->1.Group
5.Data->6.Outline->2.unGroup"
5.Data->6.Outline->3.Subtotal
6.Review->1.Spelling
6.Review->2.Research/3.Treasure/4.Translate"
6.Review->2.Comment
6.Review->3.Changes->1.Protect worksheet/2.Protect workbook/5.Allow user to edit ranges
6.Review->3.Changes->3.Share workbook 4.Protect and share workbook
6.Review->3.Changes->6.Track Changes
7.View->1.Workbook Views
7.View->2.Show/Hide
7.View->3.Zoom
7.View->4.Window
7.View->4.Window->3.Freeze/4.Split
7.View->4.Window->9.workspace