Excel HR 2019 Module 3 Quiz

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?

• Linkup

• Text link

• Hyperlink

• Web link

Which number format displays the default currency symbol with two decimal places (not aligned)?

• Number

• Accounting

• Percentage

• Currency

To which side of the cell are alphabetic characters or alphabetic characters combined with numbers or symbols aligned by default?

• top

• left

• right

• bottom

What command is used to apply a background color to cells in a worksheet?

• Highlight

• Borders & Shading

• Drawing

• Fill Color

In order to add custom lines around selected cells, which option in the Font group on the Home tab do you select?

• Fill Color

• Borders

• Underline

• Bold

In which group can you find the Paste Special command on the Home tab?

• Alignment

• Clipboard

• Editing

• Number

Which command is used to reduce the margin between the border and the text in an indented cell?

• Column Width

• Alignment

• Orientation

• Decrease Indent

Which command is used to format a cell or selected cells quickly by choosing from a defined list of styles?

• Format as Table

• Form

• Conditional Formatting

• Cell Style

What type of formatting appears only when the value in a cell meets conditions specified by a user?

• Logical

• Conditional

• Criterion

• Restrictive

Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?

• Merge & Center

• Wrap Text

• Cell Styles

• Group Cells