Enter Title

Function

100

Which function is used to return the current date in excel?

_{=Date() | =now() | =today() | =Time()}

=Today()

200

Which function returns a cell's current row number?

_{=cell() | =rownum() | =row() | =rows()}

=row()

300

A modern day alternative function of vlookup that searches a range or an array, and then returns the item corresponding to the first match it finds

XLookup()

Data

100

How do you quickly insert the sum function in excel to a data set using shortcut keys?

Alt + =

200

What function allows you to group, aggregate, sort, and filter data based on the row and column fields that you specify? _{(alternate to creating a pivot table utilizing formula/function)}

=Pivotby(select return row fields, select return column fields, select values, function- SUM)

300

What function returns/extracts visible data from a PivotTable by generating a formula?

=Getpivotdata()

Filter

100

What does the shortcut key, Ctrl + Shift + L, do?

Creates a filter

200

How do you apply a slicer to a table?

Insert tool bar -> Slicer

300

How do you create a filter for a data set based on a specific selection using a formula/function? 

=filter(select data set, select identifier column = identifier, "")

"" - can be replaced with what you are wanting blank values to return as

Misc

100

What does the shortcut key, Ctrl +  T do?

Turns data set into a table

200

How do you sum cells based on multiple conditions?

_{sumifs() | sumif() | dsum()| if()}

=sumifs()

300

How do you extract the first 3 characters from "text"?

_{left() | right() | mid() | find()}

=Left(text cell#, 3)

Conditional Formatting

100

How do you identify duplicates in a column?

conditional formatting ->New rule ->"Format only unique or duplicate values" -> select duplicate -> assign formatting

200

How do you highlight cells based on criteria?

Conditional Formatting -> New Rule -> Use formulas/format all cells that contain->insert criteria -> set formatting

300

BONUS: _{(not conditional formatting related)}

When presenting data, how do you access cell focus? _{This highlights the current cell you have selected}

On toolbar locate "View" and then select "Focus Cell"