Excel Lesson 5
What is an example of a skinny row height?
4 Correct, because a row height of 4 creates a row much shorter than the standard row height of 15.
What is the correct keyboard sequence for changing the row height of a standard row to a skinny row with a row height of 4?
Alt+O, R, E, 4, Enter Correct, because Alt+O references the old Format menu commands with R for "Row" and E for "Height." 4 enters the desired row height.
All of the following steps will hide a worksheet, except: Select one: a. Home > Format > Hide & Unhide > Hide Sheet b. Right click the sheet's tab and select Hide c. Alt O, H, H d. F1
F1 Correct, because this keyboard shortcut opens Excels built-in help system.
Which of the following is not information that should be placed on a hidden worksheet? Select one: a. Payroll data b. Admin notes c. Reference tables d. Admin settings
Payroll data Correct, because, depending on the security settings, sheets can be unhidden by a user.
As presented, what can we make skinny?
Rows and Columns Correct, because this technique is applicable to both rows and columns and helps to ensure that new rows or columns are included in related formulas.
As presented, what is the key to using the skinny row technique?
The formula needs to include the skinny row Correct, because if the formula excludes the skinny row then the range reference won't automatically expand.
