Excel Accounting Crash WALL STREET Retake
Exam FALL SEMESTER GRADED A+
Modify the number format so no decimal places are visible after the decimal point. -
ANSWER: In the Home Ribbon Tab in the Number Ribbon Group, you clicked the
Decrease Decimal button, clicked the Decrease Decimal button.
Apply bold and italic formatting to the selected cell. - ANSWER: In the Home Ribbon
Tab in the Font Ribbon Group, you clicked the Italic button, clicked the Bold button.
Enter the number 6745 in cell C7. - ANSWER: You typed 6745 in cell C7, pressed
Enter.
Cut cell B7 and paste it to cell E12. - ANSWER: You pressed the Ctrl + X keyboard
shortcut, clicked cell E12, and pressed the Ctrl + V keyboard shortcut.
Apply the Accounting Number Format to the selected cells. - ANSWER: In the Home
Ribbon Tab in the Number Ribbon Group, you clicked the Number Format drop-
down arrow. In the Number Format menu, you selected the Accounting option.
Apply the Ion theme to the workbook. - ANSWER: In the Page Layout Ribbon Tab in
the Themes Ribbon Group, you clicked the Themes button. In the Themes menu, you
selected the Ion option.
Use AutoFill to copy the formula and formatting in cell E2 to cells E3:E6. - ANSWER:
You clicked and dragged the cell E2 fill handle, released the mouse button on cell E6.
Select cells A5:D8. - ANSWER: You clicked cell A5, and selected the cell range A5:D8.
Add a Blue, Accent 5 (in the top row of theme colors, the second color from the
right) bottom border to the selected cells. Use the thickest single line style available.
- 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.
Use Format Painter to copy the formatting from cell D1 and apply it to cell E1. -
ANSWER: In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the
Format Painter button. You clicked cell E1.
Change font size for the selected cells to 18. - ANSWER: In the Home Ribbon Tab in
the Font Ribbon Group, you clicked the Font Size drop-down arrow. In the Font Size
menu, you selected the 18pt font size.
Use AutoSum to enter a formula in the selected cell to calculate the total of all the
contiguous cells above. - ANSWER: In the Home Ribbon Tab in the Editing Ribbon
, Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked
the Sum menu item. You pressed Enter.
Wrap the text in the selected cell. - ANSWER: In the Home Ribbon Tab in the
Alignment Ribbon Group, you clicked the Wrap Text button.
Autofit column D to best fit the data. - ANSWER: You double-clicked column D's right
border.
Apply the Top and Bottom Border to the selected cells with a single command. -
ANSWER: In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Borders
button arrow. In the Borders menu, you clicked the Top and Bottom Border menu
item.
Use a single command to clear everything (content and formatting) from the
selected cell. - ANSWER: In the Home Ribbon Tab in the Editing Ribbon Group, you
clicked the Clear button. In the Clear menu, you clicked the Clear All menu item.
Change the font color of the selected cells to the Blue-Gray, Text 2 color (it is the
fourth option in the first row under Theme Colors). - ANSWER: 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-Gray, Text 2 color option.
Select column B. - ANSWER: You clicked on column B.
Cell F4 has been copied. Paste the formula only into the selected cell (cell F5). Do not
include the cell formatting. - ANSWER: 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 the Accent1 cell style to the selected cell. - ANSWER: In the Home Ribbon Tab
in the Styles Ribbon Group, you clicked the Cell Styles button. In the Cell Styles
menu, you selected the Accent 1 option.
Change the font for the selected cell to Cambria. - ANSWER: In the Home Ribbon Tab
in the Font Ribbon Group, you clicked the Font drop-down arrow. In the Font menu,
you clicked the Cambria font.
Change the width of the selected columns to 14. - ANSWER: In the Home Ribbon Tab
in the Cells Ribbon Group, you clicked the Format button. In the Format menu, you
clicked the Column Width menu item. Inside the Column Width dialog, you typed 14
in the Column Width: input, clicked the OK button.
Copy cell F3, and paste to cell F2. - ANSWER: You pressed the Ctrl + C keyboard
shortcut, clicked cell F2, and pressed the Ctrl + V keyboard shortcut.
Exam FALL SEMESTER GRADED A+
Modify the number format so no decimal places are visible after the decimal point. -
ANSWER: In the Home Ribbon Tab in the Number Ribbon Group, you clicked the
Decrease Decimal button, clicked the Decrease Decimal button.
Apply bold and italic formatting to the selected cell. - ANSWER: In the Home Ribbon
Tab in the Font Ribbon Group, you clicked the Italic button, clicked the Bold button.
Enter the number 6745 in cell C7. - ANSWER: You typed 6745 in cell C7, pressed
Enter.
Cut cell B7 and paste it to cell E12. - ANSWER: You pressed the Ctrl + X keyboard
shortcut, clicked cell E12, and pressed the Ctrl + V keyboard shortcut.
Apply the Accounting Number Format to the selected cells. - ANSWER: In the Home
Ribbon Tab in the Number Ribbon Group, you clicked the Number Format drop-
down arrow. In the Number Format menu, you selected the Accounting option.
Apply the Ion theme to the workbook. - ANSWER: In the Page Layout Ribbon Tab in
the Themes Ribbon Group, you clicked the Themes button. In the Themes menu, you
selected the Ion option.
Use AutoFill to copy the formula and formatting in cell E2 to cells E3:E6. - ANSWER:
You clicked and dragged the cell E2 fill handle, released the mouse button on cell E6.
Select cells A5:D8. - ANSWER: You clicked cell A5, and selected the cell range A5:D8.
Add a Blue, Accent 5 (in the top row of theme colors, the second color from the
right) bottom border to the selected cells. Use the thickest single line style available.
- 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.
Use Format Painter to copy the formatting from cell D1 and apply it to cell E1. -
ANSWER: In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the
Format Painter button. You clicked cell E1.
Change font size for the selected cells to 18. - ANSWER: In the Home Ribbon Tab in
the Font Ribbon Group, you clicked the Font Size drop-down arrow. In the Font Size
menu, you selected the 18pt font size.
Use AutoSum to enter a formula in the selected cell to calculate the total of all the
contiguous cells above. - ANSWER: In the Home Ribbon Tab in the Editing Ribbon
, Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked
the Sum menu item. You pressed Enter.
Wrap the text in the selected cell. - ANSWER: In the Home Ribbon Tab in the
Alignment Ribbon Group, you clicked the Wrap Text button.
Autofit column D to best fit the data. - ANSWER: You double-clicked column D's right
border.
Apply the Top and Bottom Border to the selected cells with a single command. -
ANSWER: In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Borders
button arrow. In the Borders menu, you clicked the Top and Bottom Border menu
item.
Use a single command to clear everything (content and formatting) from the
selected cell. - ANSWER: In the Home Ribbon Tab in the Editing Ribbon Group, you
clicked the Clear button. In the Clear menu, you clicked the Clear All menu item.
Change the font color of the selected cells to the Blue-Gray, Text 2 color (it is the
fourth option in the first row under Theme Colors). - ANSWER: 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-Gray, Text 2 color option.
Select column B. - ANSWER: You clicked on column B.
Cell F4 has been copied. Paste the formula only into the selected cell (cell F5). Do not
include the cell formatting. - ANSWER: 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 the Accent1 cell style to the selected cell. - ANSWER: In the Home Ribbon Tab
in the Styles Ribbon Group, you clicked the Cell Styles button. In the Cell Styles
menu, you selected the Accent 1 option.
Change the font for the selected cell to Cambria. - ANSWER: In the Home Ribbon Tab
in the Font Ribbon Group, you clicked the Font drop-down arrow. In the Font menu,
you clicked the Cambria font.
Change the width of the selected columns to 14. - ANSWER: In the Home Ribbon Tab
in the Cells Ribbon Group, you clicked the Format button. In the Format menu, you
clicked the Column Width menu item. Inside the Column Width dialog, you typed 14
in the Column Width: input, clicked the OK button.
Copy cell F3, and paste to cell F2. - ANSWER: You pressed the Ctrl + C keyboard
shortcut, clicked cell F2, and pressed the Ctrl + V keyboard shortcut.
