Excel Expert 2 KA

Which number format is used to display the month as a single text character (such as N for November)?

• mm

• m

• mmmmm

You want to display the two numbers 1,540,257.14 and 2,250,444.18 as 1.54 M and 2.25 M, respectively. Which number format must be applied to the first two numbers?

• 0,000.00 “M”

• #,##0.00,, “M”

• #,##0.* “M”

Which number format is used to format a list of credit card numbers so they appear as typically displayed on a credit card?

• ####.####.####.####

• 0000E+4

• 0000 0000 0000 0000

Which of the following methods is used to display the Series dialog box that is used to fill data in a range?

• On the Data tab, in the Forecast group, select What-If Analysis and then click Series.

• On the Home tab, in the Editing group, select Fill and then click Series.

• On the Insert tab, in the Text group, click Series.

Which tab in the Data Validation dialog box is used to specify the validation criteria?

• Settings

• Number

• Input Message

Which option on the Conditional Formatting menu is used to display colored bars that represent the values in cells, with the highest values displaying the longest bars?

• Highlight Cells Rules

• Color Scales

• Data Bars

What is the name of the default document theme in Excel 2016?

• General

• Office

• Standard

Which ribbon tab in Excel 2016 provides access to macro settings and form controls?

• Data

• Developer

• Formulas

You want to create a worksheet where the user can see seven choices in a list all at once. When the user makes a selection on the list, another cell on the worksheet will show the number (position) of the item they selected (not the text itself from the item selection). Which control must be inserted in the worksheet?

• An ActiveX List Box control

• A Form Combo Box control

• A Form List Box control

Which method is used to change “Sao Paulo” to “São Paulo”?

• Use the Symbol button on the Insert tab while in edit mode.

• Use the Translate button on the Review tab while in edit mode.

• Use the Format Cells dialog box to change the cell’s number format to Portuguese