NEW
Font size
WorksheetsExcel Expert 2 KA
Total questions: 10
Worksheet time: 4mins
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
