Question

Anandi has been working with Excel to record data from an extensive physics experiment at her university. She

hundreds of columns representing different trials, and many rows showing different pieces of data from each trial
handful of cells have data that stand out, so she needs to show them to her professor, even though these cells ar
hundreds of columns apart.
If Anandi has written down the names of those cells, what is the fastest way to get to these cells while in Excel?
O dragging the scroll box and trying to find the needed cells
O pressing the arrow keys until each appropriate cell is active
O holding the shift key while typing in the addresses of all cells
pressing Control + G and typing in the address of each needed cell

Answer 1

Answer: pressing Control + G and typing in the address of each needed cell

Step-by-step explanation:

Assuming Anandi has written down the names of the cells, the fastest way to get to these cells while in Excel will be for him to press Control + G and type in the address of each needed cell.

It should be noted that Control + G refers to a keyboard shortcut that is used when one wants to move to a particular line in a spreadsheet or document or advance through the Find results.

By pressing Control + G and typing in the address of each needed cell, thus will take Anandi to the required cell faster.