.
Consolidate…
Text to Columns…
Scenario Manager...
Data Validation…
Data Table...
Repetitive calculations
Iterative calculations
Circular references
Iterative references
Responsive calculations
True
False
Procedures
Class objects
Modules
Standard Objects
Methods
True
False
True
False
Home tab
Options
Right-click the ribbon
REGEDIT
Status Bar
Shared Workbook
Tracked Workbook
Collaborated Workbook
Merged Workbook
3-D Workbook
=SUM(Sales Data.xlsx!Quarter1)
=SUM(Sales Data.xlsx!Sheet1!C7:C13)
=SUM(SalesData.xlsx!Quarter1)
=SUM('Sales Data.xlsx'!Quarter1)
=SUM(Quarter1!'Sales Data.xlsx')
Repair Links…
Edit Links…
Links Checker…
Save As…
Relink…
#DIV/0!
#NULL! #VALUE?
#N/A! #NUM!
#VAR! #CONSTANT!
#VALUE! #REF!
Calculating using the CUBE functions.
Referencing the same cells across a range of worksheets.
Inserting 3-D images in worksheet.
Referencing the same cells across a range of workbooks.
Referencing different cells across a range of worksheets.
Macros workbook
Hidden Workbook
VBA Workbook
DIY Workbook
Personal Workbook
Error Checking
Trace Precedents
Trace Dependents
Show Formulas
Evaluate Formula
Data Analysis Expression DAX
Point of Power POP
Power Differential Features PDF
PowerPivot Evaluation Mathematical Differential Action Server PEMDAS
FILTERXML
Alternative text for objects and images.
Blank cells in datasets to separate columns.
Meaningful hyperlink text.
Unique tab name and no blank worksheets.
Closed captioning.
.txt
.xls
.xps
.jpg
Combo Box
Label
Group Box
Multiple Choice Box
Spin Button
Array
Sparkline
Raster
Vector
Form
Save As dialog box
Encrypt with password on the Protect Workbook button in the Info category on the File menu.
Advanced category on the Options menu on the File menu
Protect Workbook in the Changes group on the Review tab.
Protect and Share Workbook in the Changes group on the Review tab .
Summarize Dialog Box
Subtotals Dialog Box
Data Validation Dialog Box
Expansion Packs Dialog Box
Consolidate Dialog Box
Range_lookup
Row_index_number
Column_index_number
Table_array
Lookup_value
Show All Comments command in the Comments group on the Review tab.
Print Comments command in the Page Setup group on the Page Layout tab.
Advanced category form the Option menu on the File tab.
Comments on the Sheet tab in the Page Setup dialog box.
Comments can not be printed.
Quiz Review Timeline (Updated): +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.