LinkedIn Microsoft Excel Certification

When editing a cell, what do you press to cycle between relative, mixed, and absolute cell references?

October 27, 2022 Editorial Staff

Alt+F4 (Windows) or Option+F4 (Mac)
Alt+Shift+4 (Windows) or Option+Shift+4 (Mac)
Ctrl+Shift+4 (Windows) or Command+Shift+4 (Mac)
the F4 (Windows) or Command+T (Mac)

The correct answer is:

the F4 (Windows) or Command+T (Mac)

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

← If the worksheet below, you want to use Data > Subtotal to show a subtotal value per sport. What must you do BEFORE applying the Subtotal function?
You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell? →