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.