Back to lesson
1. Which of the following is a keyboard shortcut for selecting columns?
SHIFT + Spacebar
CTRL + A
CTRL + Spacebar
2. Why is it suggested that the first few columns of a model worksheet should be narrowed?
It forces you to type shorter formulae
It allows you to get more columns on screen
Headings can appear to be indented by positioning them in different columns making spreadsheets both easier to read and navigate
3. The formula for returning the sheet title of a worksheet is based on manipulating the result of the formula =CELL(“filename”,A1). What relevance does the reference to cell A1 have?
None; it can actually be any cell on the sheet in question.
It must specify the cell where the formula is to be located
It must specify the cell that resets the worksheet (the CTRL + HOME cell)
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement