You can also create constant values to use in a worksheet by referring to it by name. To do this, choose Insert > Name > Define.In the Refers to: area, type a value such as 55 percent for a markup ...

Whether you've landed a job interview for a role that requires fundamental Microsoft Excel skills or you're looking to solve a real-world problem, take the How-To Geek Beginner Excel Test to ...