0Writing a cell reference in Excel as B$5 means:ABoth the column and the row are lockedBOnly the column is lockedCOnly the row is lockedDNeither is locked Correct answer: C Join the discussion Report an error Share