Excel 2019 Modules 1-3

Which formatting feature for alignment will put the contents of a cell on multiple lines within the same cell?

• Long date

• indent

• increase font size

• wrap text

To position text equally between the top and bottom of a cell, which alignment setting would you use?

• Merge cells

• orientation

• vertical alignment

• shrink to fit

When you have a column name that is much longer than the data in the column’s values, what options make it possible to display the entire name without making the column wider?

• Apply Wrap Text to the column name.

• Indent the column name

• Change the worksheet margins.

• Rotate the column name text.

Where on the ribbon will you find cell styles?

• Home tab, Font group

• Page layout tab, Themes group

• Home tab, Styles group

• Insert tab, illustrations group

Which command do you use to change the color of a cell background?

• Background color

• fill color

• border color

• font color