CGS2100 EXCEL EXAM QUESTIONS AND
ANSWERS
Name cell B9 as follows: COLA - Answers -you clicked the Name Box, clicked the
Name Box, typed COLA, and pressed Enter.
Clear only the formatting from the selected cell (leaving the content). - Answers -In the
Home Ribbon Tab in the Editing Ribbon Group, you clicked the Clear button. In the
Clear menu, you clicked the Clear Formats menu item.
Change the font color of the selected cells to the Blue standard color (it is the third
option from the right in the row of standard colors). - Answers -In the Home Ribbon Tab
in the Font Ribbon Group, you clicked the Font Color button arrow. In the Font Color
menu, you selected the Blue color option.
Cell F4 has been copied. Paste the formula only into the selected cell (cell F5). Do not
include the cell formatting. - Answers -In the Home Ribbon Tab in the Clipboard Ribbon
Group, you clicked the Paste button arrow. In the Paste menu, you clicked the Formulas
(F) button.
Apply conditional formatting to the selected cells using the red gradient fill data bar. -
Answers -In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the
Conditional Formatting button. In the Conditional Formatting menu in the Data Bars
menu, you selected the Red Data Bar (Gradient) option.
Select column C. - Answers -You clicked on column C.
.
Apply conditional formatting to the selected cells so cells with a value greater than 400
are formatted using a light red fill. - Answers -In the Home Ribbon Tab in the Styles
Ribbon Group, you clicked the Conditional Formatting button. In the Conditional
Formatting menu in the Highlight Cells Rules menu, you clicked the Greater Than...
menu item. Inside the Greater Than dialog, you typed 400 in the Format cells that are
GREATER THAN: input. Inside the Greater Than dialog in the with drop-down, you
selected Light Red Fill. Inside the Greater Than dialog, you clicked the OK button.
Hide the TimeSheets worksheet. - Answers -In the Home Ribbon Tab in the Cells
Ribbon Group, you clicked the Format button. In the Format menu in the Hide & Unhide
menu, you clicked the Hide Sheet menu item.
Use AutoFill to copy the formula and formatting in cell E2 to cells E3:E6. - Answers -You
clicked and dragged the cell E2 fill handle, released the mouse button on cell E6.
, Insert a PivotChart using the first pie chart type. - Answers -In the Analyze Ribbon Tab
in the Tools Ribbon Group, you clicked the PivotChart button. Inside the Insert Chart
dialog from the Chart Type list, you clicked the Pie item. Inside the Insert Chart dialog,
you clicked the OK button.
Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9)
is greater than or equal to 470000 or 100 if it is not. - Answers -You clicked the formula
bar, typed "=IF" in the formula bar, clicked the =IF(B9>=470000, 35000, 100) view,
clicked the formula bar, typed "=IF(B9 >=470000, 35000, 100)" in the formula bar, and
pressed Enter.
Use the Quick Analysis tool to apply the Data Bars conditional formatting option to the
selected cells. - Answers -You clicked the Quick Analysis Tool button, clicked the Data
Bars button.
Clear only the content from the selected cell (leaving the formatting). - Answers -In the
Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting
button. In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the Clear
button. In the Clear menu, you clicked the Clear Contents menu item.
Clear the print area. - Answers -In the Page Layout Ribbon Tab in the Page Setup
Ribbon Group, you clicked the Print Area button. In the Print Area menu, you clicked the
Clear Print Area menu item.
Insert a column to the left of column E. - Answers -In the Insert Ribbon Tab in the
Sparklines Ribbon Group, you clicked the Column button. Inside the Create Sparklines
dialog, you clicked the dialog Close button. You clicked cell E4, clicked the E4 Cell
Input, and clicked cell E4. In the Home Ribbon Tab in the Cells Ribbon Group, you
clicked the Insert button arrow. In the Insert menu, you clicked the Insert Sheet
Columns menu item.
Modify this worksheet so the numbers at the left of each row and the letters at the top of
each column do not show. - Answers -In the View Ribbon Tab in the Show Ribbon
Group, you unchecked the Headings check box.
Set row 1 to print on every page. - Answers -You clicked on the row 1 header. In the
Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Print Titles
button. You selected the cell range A1:AD1, clicked on the row 1 header. Inside the
Page Setup dialog, you clicked the OK button.
Apply the Double Accounting underline format to the selected cells. - Answers -You
clicked the Quick Analysis Tool button, clicked the Quick Analysis Tool button, selected
the cell range B7:F7, selected the cell range B7:F7, clicked the Quick Analysis Tool
button, clicked the Charts tab header, clicked the Totals tab header, clicked the Tables
tab header, clicked the Sparklines tab header, clicked the Formatting tab header,
clicked the Quick Analysis Tool button, clicked and dragged the cell B7 fill handle, and
ANSWERS
Name cell B9 as follows: COLA - Answers -you clicked the Name Box, clicked the
Name Box, typed COLA, and pressed Enter.
Clear only the formatting from the selected cell (leaving the content). - Answers -In the
Home Ribbon Tab in the Editing Ribbon Group, you clicked the Clear button. In the
Clear menu, you clicked the Clear Formats menu item.
Change the font color of the selected cells to the Blue standard color (it is the third
option from the right in the row of standard colors). - Answers -In the Home Ribbon Tab
in the Font Ribbon Group, you clicked the Font Color button arrow. In the Font Color
menu, you selected the Blue color option.
Cell F4 has been copied. Paste the formula only into the selected cell (cell F5). Do not
include the cell formatting. - Answers -In the Home Ribbon Tab in the Clipboard Ribbon
Group, you clicked the Paste button arrow. In the Paste menu, you clicked the Formulas
(F) button.
Apply conditional formatting to the selected cells using the red gradient fill data bar. -
Answers -In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the
Conditional Formatting button. In the Conditional Formatting menu in the Data Bars
menu, you selected the Red Data Bar (Gradient) option.
Select column C. - Answers -You clicked on column C.
.
Apply conditional formatting to the selected cells so cells with a value greater than 400
are formatted using a light red fill. - Answers -In the Home Ribbon Tab in the Styles
Ribbon Group, you clicked the Conditional Formatting button. In the Conditional
Formatting menu in the Highlight Cells Rules menu, you clicked the Greater Than...
menu item. Inside the Greater Than dialog, you typed 400 in the Format cells that are
GREATER THAN: input. Inside the Greater Than dialog in the with drop-down, you
selected Light Red Fill. Inside the Greater Than dialog, you clicked the OK button.
Hide the TimeSheets worksheet. - Answers -In the Home Ribbon Tab in the Cells
Ribbon Group, you clicked the Format button. In the Format menu in the Hide & Unhide
menu, you clicked the Hide Sheet menu item.
Use AutoFill to copy the formula and formatting in cell E2 to cells E3:E6. - Answers -You
clicked and dragged the cell E2 fill handle, released the mouse button on cell E6.
, Insert a PivotChart using the first pie chart type. - Answers -In the Analyze Ribbon Tab
in the Tools Ribbon Group, you clicked the PivotChart button. Inside the Insert Chart
dialog from the Chart Type list, you clicked the Pie item. Inside the Insert Chart dialog,
you clicked the OK button.
Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9)
is greater than or equal to 470000 or 100 if it is not. - Answers -You clicked the formula
bar, typed "=IF" in the formula bar, clicked the =IF(B9>=470000, 35000, 100) view,
clicked the formula bar, typed "=IF(B9 >=470000, 35000, 100)" in the formula bar, and
pressed Enter.
Use the Quick Analysis tool to apply the Data Bars conditional formatting option to the
selected cells. - Answers -You clicked the Quick Analysis Tool button, clicked the Data
Bars button.
Clear only the content from the selected cell (leaving the formatting). - Answers -In the
Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting
button. In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the Clear
button. In the Clear menu, you clicked the Clear Contents menu item.
Clear the print area. - Answers -In the Page Layout Ribbon Tab in the Page Setup
Ribbon Group, you clicked the Print Area button. In the Print Area menu, you clicked the
Clear Print Area menu item.
Insert a column to the left of column E. - Answers -In the Insert Ribbon Tab in the
Sparklines Ribbon Group, you clicked the Column button. Inside the Create Sparklines
dialog, you clicked the dialog Close button. You clicked cell E4, clicked the E4 Cell
Input, and clicked cell E4. In the Home Ribbon Tab in the Cells Ribbon Group, you
clicked the Insert button arrow. In the Insert menu, you clicked the Insert Sheet
Columns menu item.
Modify this worksheet so the numbers at the left of each row and the letters at the top of
each column do not show. - Answers -In the View Ribbon Tab in the Show Ribbon
Group, you unchecked the Headings check box.
Set row 1 to print on every page. - Answers -You clicked on the row 1 header. In the
Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Print Titles
button. You selected the cell range A1:AD1, clicked on the row 1 header. Inside the
Page Setup dialog, you clicked the OK button.
Apply the Double Accounting underline format to the selected cells. - Answers -You
clicked the Quick Analysis Tool button, clicked the Quick Analysis Tool button, selected
the cell range B7:F7, selected the cell range B7:F7, clicked the Quick Analysis Tool
button, clicked the Charts tab header, clicked the Totals tab header, clicked the Tables
tab header, clicked the Sparklines tab header, clicked the Formatting tab header,
clicked the Quick Analysis Tool button, clicked and dragged the cell B7 fill handle, and
