NEW
Font size
WorksheetsExcel HR 2019 Module 3 Quiz
Total questions: 20
Worksheet time: 10mins
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
On the Home Ribbon, what is used to change the font size of characters in a cell?
Font Style drop-down list
Font Size drop-down list
Font drop-down list
Cell Styles drop-down list
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
Wrap Text
Center
Merge and Center
Orientation
On the Home Ribbon, what can be used to change the text color of characters in a cell?
Cell Styles drop-down list
Fill Color drop-down list
Font Size drop-down list
Font Color drop-down list
Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
Number
Date
Text
Currency
Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
Format as Table
Conditional Formatting
Cell Style
Borders
Which command on the shortcut menu can you use to delete a hyperlink from the selected cell?
Delete Hyperlink
Remove Hyperlink
Erase Hyperlink
Undo Hyperlink
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
Borders
Cell Style
Format as Table
Conditional Formatting
Which toolbar is a formatting tool that displays above the shortcut menu when you right-click a cell?
Gallagher
Fast
New
Mini
Top
Which option on the Conditional Formatting menu provides access to the Conditional Formatting Rules Manager dialog box?
Create Rules
Write Rules
Manage Rules
Rename Rules
Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?
Remove
Delete
Format
Format as Table
