EXCEL 2 TEST QUESTIONS WITH
COMPLETE ANSWERS { GRADED A+}
Apply the Long Date format similar to Monday, July 1, 2016 to the selected cells.
Font Size - ✔✔On the Home tab, in the Number group, click the Number Format
arrow. Click Long Date.
In cell H12, enter a formula to find the lowest percentage of items received in the
order (cells H2:H11).
Font Size - ✔✔On the Formulas tab, in the Function Library group, click the
AutoSum arrow, and click Min. Press Enter.
Copy the Car Loan worksheet to a new workbook.
Font Size - ✔✔Right-click the Car Loan sheet tab, and select Move or Copy...
Expand the To book list and select (new book). Click the Create a copy check box.
Click OK.
Enter a formula in cell B8 to display the text from cell A8 in all upper case letters.
,Font Size - ✔✔On the Formulas tab, in the Function Library group, click the
Text button. Select UPPER from the list. Type A8 in the Text box, and click OK.
Freeze the top row of the worksheet.
Font Size - ✔✔On the View tab, in the Window group, click the Freeze Panes
button. Click Freeze Top Row.
In cell B3, enter a formula using INDEX to look up the expected delivery date for
the purchase order at the row position in cell B2. Use the named range JunePOs as
the Array argument. The price is found in the fifth column of the array.
Font Size - ✔✔On the Formulas tab, in the Function Library group, click the
Lookup & Reference button. Select INDEX. Select the
array,row_num,column_num option. Click OK. In the Function Arguments dialog,
in the Array box enter JunePOs. In the Row_num box, enter B2. In the
Column_num box, enter 5. Click OK.
Enter a formula in cell B8 to display the text from cell A8 in proper case with only
the first letter of each word in upper case.
Font Size - ✔✔On the Formulas tab, in the Function Library group, click the
Text button. Select PROPER from the list. Type A8 in the Text box, and click OK.
, Filter the chart so the Misc data series is hidden.
Font Size - ✔✔Click the Chart Filters button. Click the checkbox in front of Misc
to remove the check mark. Click Apply.
Merge the cells so the text appears centered across the merged cells.
Font Size - ✔✔You answered the question correctly. Click "OK" to continue.
Save this worksheet as a CSV, comma-delimited text file.
Font Size - ✔✔Click the File tab. Click Save As. On the Save As page, click the
Save as type arrow and select CSV (Comma delimited) (*.csv). Click Save. Click
OK.
Enter a formula in the selected cell to calculate the value of cell E9 times 3.
Font Size - ✔✔Type =E9*3. Press Enter.
Add slicers to filter the data in this table by City.
Font Size - ✔✔Click the Table Tools Design tab. In the Tools group, click the
Insert Slicer button. Click the City check box. Click OK.
This workbook includes a named range that results in a #REF! error. Delete that
named range.
COMPLETE ANSWERS { GRADED A+}
Apply the Long Date format similar to Monday, July 1, 2016 to the selected cells.
Font Size - ✔✔On the Home tab, in the Number group, click the Number Format
arrow. Click Long Date.
In cell H12, enter a formula to find the lowest percentage of items received in the
order (cells H2:H11).
Font Size - ✔✔On the Formulas tab, in the Function Library group, click the
AutoSum arrow, and click Min. Press Enter.
Copy the Car Loan worksheet to a new workbook.
Font Size - ✔✔Right-click the Car Loan sheet tab, and select Move or Copy...
Expand the To book list and select (new book). Click the Create a copy check box.
Click OK.
Enter a formula in cell B8 to display the text from cell A8 in all upper case letters.
,Font Size - ✔✔On the Formulas tab, in the Function Library group, click the
Text button. Select UPPER from the list. Type A8 in the Text box, and click OK.
Freeze the top row of the worksheet.
Font Size - ✔✔On the View tab, in the Window group, click the Freeze Panes
button. Click Freeze Top Row.
In cell B3, enter a formula using INDEX to look up the expected delivery date for
the purchase order at the row position in cell B2. Use the named range JunePOs as
the Array argument. The price is found in the fifth column of the array.
Font Size - ✔✔On the Formulas tab, in the Function Library group, click the
Lookup & Reference button. Select INDEX. Select the
array,row_num,column_num option. Click OK. In the Function Arguments dialog,
in the Array box enter JunePOs. In the Row_num box, enter B2. In the
Column_num box, enter 5. Click OK.
Enter a formula in cell B8 to display the text from cell A8 in proper case with only
the first letter of each word in upper case.
Font Size - ✔✔On the Formulas tab, in the Function Library group, click the
Text button. Select PROPER from the list. Type A8 in the Text box, and click OK.
, Filter the chart so the Misc data series is hidden.
Font Size - ✔✔Click the Chart Filters button. Click the checkbox in front of Misc
to remove the check mark. Click Apply.
Merge the cells so the text appears centered across the merged cells.
Font Size - ✔✔You answered the question correctly. Click "OK" to continue.
Save this worksheet as a CSV, comma-delimited text file.
Font Size - ✔✔Click the File tab. Click Save As. On the Save As page, click the
Save as type arrow and select CSV (Comma delimited) (*.csv). Click Save. Click
OK.
Enter a formula in the selected cell to calculate the value of cell E9 times 3.
Font Size - ✔✔Type =E9*3. Press Enter.
Add slicers to filter the data in this table by City.
Font Size - ✔✔Click the Table Tools Design tab. In the Tools group, click the
Insert Slicer button. Click the City check box. Click OK.
This workbook includes a named range that results in a #REF! error. Delete that
named range.
