CIS105 Excel: Questions With In-Depth Solutions

CIS105 Excel: Questions With In-Depth Solutions

Use the Quick Analysis tool to calculate totals for the selected cells. Insert the
totals in the empty row below the cell range. Correct Answer - Click the
Quick Analysis tool button and then click the Totals tab. Click the first Sum
button. Click OK.

Change the angle of rotation for the selected cells to 45 degrees
(counterclockwise).
Font Size Correct Answer - On the Home tab, in the Alignment group, click
the Orientation button, and select Angle Counterclockwise.

Apply the Colorful- Accent Colors color set to the diagram.
Font Size Correct Answer - Click the Change Colors button. Select Colorful-
Accent Colors. It is the first option in the Colorful section of the gallery.

Apply data validation rules to the selected cells to allow only decimal numbers
less than 5.00. Allow blank cells.
Font Size Correct Answer - On the Data tab, in the Data Tools group, click
the Data Validation button. Expand the Allow list and select Decimal. Expand
the Data list and select less than. Type 5.00 in the Maximum box. Click OK.

Split the selected text into columns using the comma character as the
delimiter.
Font Size Correct Answer - On the Data tab, in the Data Tools group, click
the Text to Columns button. Click Next. Click the Comma check box. Click Next.
Click Finish.

Apply conditional formatting so cells with a value greater than the average are
formatted using a yellow fill with dark yellow text.
Font Size Correct Answer - On the Home tab, in the Styles group, click the
Conditional Formatting button. Point to Top/Bottom Rules, and click Above
Average. Click the drop-down arrow and select Yellow Fill with Dark Yellow
Text. Click OK.

Apply conditional formatting to the selected cells using the Three Symbols
(Circled) icon set (the first icon set in the Indicators section).

, Font Size Correct Answer - On the Home tab, in the Styles group, click the
Conditional Formatting button. From the menu, point to Icon Sets and click
the first option under Indicators.

This worksheet has validation rules applied. Find and circle cells that violate
those rules.
Font Size Correct Answer - On the Data tab, in the Data Tools group, click
the Data Validation button arrow and select Circle Invalid Data.

Remove the borders from the selected cells with a single command.
Font Size Correct Answer - On the Home tab, in the Font group, click the
Borders button arrow, and select No Border.

Change font size for the selected cells to 16.
Font Size Correct Answer - On the Home tab, in the Font group, click the
Font Size arrow, and select 16.

Modify the number format so no decimal places are visible after the decimal
point.
Font Size Correct Answer - On the Home tab, in the Number group, click
the Decrease Decimal button twice.

Change the zoom level for the worksheet to be 110%.
Font Size Correct Answer - Click the Zoom In button on the zoom slider.

Clear only the formatting from the selected cells (leaving the content).
Font Size Correct Answer - On the Home tab, in the Editing group, click the
Clear button. Select Clear Formats.

Reset the Ribbon back to its original state.
Font Size Correct Answer - Click the File tab. Click Options to open the
Excel Options dialog. Click Customize Ribbon. Click the Reset button and select
Reset all Customizations. Click Yes.

Add a Blue, Accent 5 fill color to the selected cells.
Font Size Correct Answer - On the Home tab, in the Font group, click the
Fill Color button arrow to display the color palette. Click the Blue, Accent 5
color, the second color from the right in the first row of theme colors.