lesson two
autofit
______ determines the best width for a column or the best height for a row, based on its contents.
theme
a _____ is a preset collection of design elements, including fonts, colors, and other effects.
live preview
as you format cells, _____ show the results of the different formatting options you can choose.
page layout
you can select a different theme for your workbook. click the _____ tab on the ribbon. in the themes group, click the themes button to display a gallery of themes.
office
by default, the _____ theme is applied to each workbook.
shifted to the right
data can be indented (or _____) within cells to help distinguish categories or set data apart.
right-aligns
excel _____ all numbers.
bottom
horizontal alignments do not include _____.
dialog box
if you want to specify a precise column width, use the column width _____
ctrl+U
press the _____ keys to apply understanding
font
to change fonts and sizes, you must first select the cells you want to change. then, on the home tab of the ribbon, in the _____ group, click the arrow next to the font box to display a gallery of available fonts.
orientation
to change text orientation, select the cells whose contents you want to rotate. click the _____ button in the alignment group on the home tab of the ribbon.
ctrl+1
to open the format cells dialog box, you can click the dialog box launcher in the font, alignment, or number group on the home tab of the ribbon, or you can press the _____ keys.
bottom right
unless you specify otherwise, numbers you enter in a cell are lined up along the _____ side of the cell.
upper-left
when you select the merge & center button, only the contents from the cell in the _____ corner of the range are kept. all other content is deleted from the worksheet.
merge & center
you can also center cell contents across several columns. select the cells, and then click the _____ button in the alignment group on the home tab of the ribbon.
right
you can change the width of several columns at one time. select the columns you want to resize. then, use the pointer to click and drag the _____ edge of one of the selected column headings.
no border
you can remove the borders from a selected cell by clicking _____ in the border style menu.