In order to let Excel automatically adjust the width to fit the contents, what can you use on the boundary line between rows or columns? Double-click Select the column, __________ the selection, and select Column Width from the shortcut menu to access the column width dialog box. Right-click What is the default row height? 15 What is the default column width? 8.43 What can be used to copy the width of one column to other columns? Format Painter What should you click to apply formatting to the entire row? Row heading When you wish to reduce the visibility of unwanted rows or columns in a spreadsheet, what option from the shortcut menu can you use? Hide What line color indicates hidden content on a spreadsheet? Green In order to unhide columns or rows, select the hidden row or column header on the __________ tab, click the Format button arrow, point to Hide & Unhide, and select the Unhide option. Home In order to unhide information, which line(s) in the row or column heading do you double-click? Double lines The Transpose command is found in the Paste Special dialog box in the Clipboard group on which tab? Home In order to quickly format your worksheet, select any cell within the active worksheet and choose a desired theme on which tab? Page Layout Document themes are used to apply sets of styles to a/an entire document In order to return all theme color elements to their original colors, which button in the Create New Theme Colors dialog box do you click? Reset List 3 items that can be used to create your own customized theme. Font, colors, and effects T or F: Customized themes are available only once. False Tor F: Customized themes are available in all Office 2013 documents. True Tor F: Customized themes are available only in the application in which they were created. False Tor F: Customized themes are available only in Excel spreadsheets. False Use __________ in the Themes group to enhance charts, shapes, SmartArt, or similar graphics. Effects are displayed by default but do not print automatically. True T or F: Row headings T or F: Column headings are displayed by default but do not print automatically. True
In order to let Excel automatically adjust the width to fit the contents, what can you use on the boundary line between rows or columns? Double-click Select the column, __________ the selection, and select Column Width from the shortcut menu to access the column width dialog box. Right-click What is the default row height? 15 What is the default column width? 8.43 What can be used to copy the width of one column to other columns? Format Painter What should you click to apply formatting to the entire row? Row heading When you wish to reduce the visibility of unwanted rows or columns in a spreadsheet, what option from the shortcut menu can you use? Hide What line color indicates hidden content on a spreadsheet? Green In order to unhide columns or rows, select the hidden row or column header on the __________ tab, click the Format button arrow, point to Hide & Unhide, and select the Unhide option. Home In order to unhide information, which line(s) in the row or column heading do you double-click? Double lines The Transpose command is found in the Paste Special dialog box in the Clipboard group on which tab? Home In order to quickly format your worksheet, select any cell within the active worksheet and choose a desired theme on which tab? Page Layout Document themes are used to apply sets of styles to a/an entire document In order to return all theme color elements to their original colors, which button in the Create New Theme Colors dialog box do you click? Reset List 3 items that can be used to create your own customized theme. Font, colors, and effects T or F: Customized themes are available only once. False Tor F: Customized themes are available in all Office 2013 documents. True Tor F: Customized themes are available only in the application in which they were created. False Tor F: Customized themes are available only in Excel spreadsheets. False Use __________ in the Themes group to enhance charts, shapes, SmartArt, or similar graphics. Effects T or F: Row headings are displayed by default but do not print automatically. True T or F: Column headings are displayed by default but do not print automatically. True
excel_2013_lesson_7_study_guide_answers.docx