Excel General
To create a table from a range , we need to press on ...........................
CTRL + T
Walk us through the correct syntax of VLOOKUP
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
The intersection of a column and a row in a worksheet is called____
Cell
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?
Calculated field
To Connect slicers with Pivot tabel /Charts we should do?
Right Click on the Slicer >>>> Report Connections
In Excel you can get validation on which tab?
Data
Which function will you use to enter to calculate the number of workdays between two dates that you require.
Networkday
It performs a logical test and returns one value for a TRUE result and another for a FALSE result
What is "IF" function?
What is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications
Microsoft Excel
What match type returns the exact value?
0(zero) or FALSE
If you wanted to do an Excel What-If Analysis of a system with eight different inputs which tool would you use?
Scenario Manager
It searches for a value in the first column of a range and returns a value in the same row from another column
What is the purpose of the VLOOKUP function in Excel?
The ------------------ is a toolbar at the top of the window that organizes commands and tools into tabs, making them easy to find and use
"Ribbon" in Microsoft Office applications
Which functions would you use, if you wished to quickly create smaller lists out of a much larger list on an Excel worksheet?
Filter
If you have a well-structured table, with information arranged vertically, and a column on the left which you can use to match a row, you can probably use this function.
VLOOKUP
What can you use to easily filter pivot tables interactively in a worksheet?
Slicer
Formatting a cell in Currency, you can specify through ?
A) Decimal Places
B) Currency Symbol
What is the difference between Tabular layout and Outline layout in Pivot table?
Tabular layout - Totals are below the Rows breakdown
Outline layout - Totals are above the Rows Break
Working backward from a desired result to compute an unknown value that produces the desired result.
What is Goal Seek?
How can you show the data in a Pivot Table as a percentage of the grand total?
Right-click on the data in the "Values" area, choose "Show Values As", and then select "Percentage of Grand Total"