Timeline
When was Excel I.0 released?
1985
Paste selection Shortcut
Ctrl+V
Adds together numbers in a range
=SUM
Using a function as one of the arguments in a formula that uses a function
Nesting
When was the first Windows-friendly version of Excel released?
1987
Move to the beginning of a worksheet shortcut
Ctrl+Home
Function to test whether a situation is true or false.
Logical Function
A business intelligence tool offered by Microsoft
Power Query
What excel version was sold as SaaS (Software as a Services)
Excel 365
Go to the Formula tab shortcut.
Alt+M
Function that allow users to retrieve information about the location or contents of cells in a worksheet
Reference Functions
An operation that creates a new query that contains all rows from a first query followed by all rows from a second query.
Append
What excel version where PivotTables was introduced?
Excel 2010
Insert a note shortcut
or
Open and edit a cell note shortcut
Shift+F2
Function that is used to search for specific data in a specified range of cells and return a corresponding value based on certain criteria.
Lookup Functions
An operation where one query result contains all columns from a primary table, with one column serving as a single column containing a relationship to a secondary table
Merge