A Question 4 (4 points) Retake question\ When using Autocomplete, Excel will guess at the pattern we want to increment\ across columns/rows if we only select one cell.\ How can we make Excel autocomplete for a pattern/increment different than its\ guessed pattern?\ Select the one cell and autocomplete in the opposite direction\ Select multiple cells with the correct pattern/increment, then autocomplete\ across the row or column\ Select every other cell in the range we want to copy into, then paste the one\ original cell\ Offer it a hefty bribeWhen using Autocomplete, Excel will guess at the pattern we want to increment\ across columns/rows if we only select one cell.\ How can we make Excel autocomplete for a pattern/increment different than its\ guessed pattern?\ Select the one cell and autocomplete in the opposite direction\ Select multiple cells with the correct pattern/increment, then autocomplete\ across the row or column\ Select every other cell in the range we want to copy into, then paste the one\ original cell\ Offer it a hefty bribeTrue or False: Excel's Find and Replace tool allows us to find/replace based on cell\ contents and/or cell format\ True\ False

True or False: Excel's Find and Replace tool allows us to find/replace based on cell contents and/or cell format True False