CIS 105 Excel UPDATED Questions and
CORRECT Answers
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.
CORRECT Answers
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.
