Answered step by step
Verified Expert Solution
Question
1 Approved Answer
16. A circular reference occurs when a formula refers: to its own cell. to another formula that refers to the cell in which the original
16. A circular reference occurs when a formula refers: to its own cell. to another formula that refers to the cell in which the original formula is written. to both its own cell and to another formula that refers to the cell in which the original formula is written. None of these options 17. Which of these is NOT an option associated with the AutoFill button? Paste Cells Copy Cells Fill Formatting Only Fill Without Formatting 18. Which statement best describes the impact on relative cell references in a formula being copied and pasted? The cell references appear identical to those within the copied formula. Only the column portion of the cell references (letter) may change in the copied formula. The cell references will update based on the distance between the location of the original formula and the new formula Only the row portion of the cell references (number) may change in the copied formula. 19. When would you NOT use the Options button on the Replace tab in the Find and Replace window? When locating cell contents within a specific area of a worksheet When replacing specific cell formats When locating cell contents with a specific case When replacing specific cell contents 20. When using Find and Replace to locate a cell format, which of these CANNOT be used to populate the format within the Find row? Copying an existing cell format within the worksheet Manually selecting the number type from a variety of options Manually selecting the font size and type from a variety of options Copying a previously changed cell format that was originally part of the worksheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started