Module 2

Module 2
What is a quick way to move to the bottom of a worksheet to see how many rows there are?



Select a value in one of the populated columns and press Ctrl or (Cmd) +↓



Highlight the working area in the spreadsheet



Use Find/Replace command



Use the End command ✔️A



How can you format cells by color based on a certain range of values?



Conditional formatting



Pivot tables



Static formatting



Find and Replace ✔️A



To know the place in line of some element in a column or row, which formula would you use?



MATCH



INDEX



OFFSET

, SMALL ✔️A



Which formula takes in a range of values and a row and column number and returns the value in the
range at that location?



INDEX



MATCH



OFFSET



SMALL ✔️A



When autofilter is activated for columns, what is possible?



One can click the drop-down menu that appears to show only certain values



One can sort by ascending or descending order



One can filter by color



All of these ✔️D



In Excel, what is used to "aggregate" or "group by" queries, similar to what you'd run in a traditional SQL
database.



Pivot tables