Back to lesson
1. Which of the following is a keyboard shortcut for selecting columns?
CTRL + Spacebar
SHIFT + Spacebar
CTRL + A
2. Why is it suggested that the first few columns of a model worksheet should be narrowed?
It allows you to get more columns on screen
It forces you to type shorter formulae
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?
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)
None; it can actually be any cell on the sheet in question.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement