EXCEL EXAM TEST QUESTIONS WITH VERIFIED ANSWERS
1. Modify the number
format so no decimal
places are visible af-
ter the decimal point.
2. Apply bold and italic
formatting to the se-
lected cell.
3. Enter the number
6745 in cell C7.
4. Cut cell B7 and paste
it to cell E12.
5. Apply the ...
1. Modify the number In the Home Ribbon Tab in the Number Ribbon Group,
format so no decimal you clicked the Decrease Decimal button, clicked the
places are visible af- Decrease Decimal button.
ter the decimal point.
2. Apply bold and italic In the Home Ribbon Tab in the Font Ribbon Group, you
formatting to the se- clicked the Italic button, clicked the Bold button.
lected cell.
3. Enter the number You typed 6745 in cell C7, pressed Enter.
6745 in cell C7.
4. Cut cell B7 and paste You pressed the Ctrl + X keyboard shortcut, clicked
it to cell E12. cell E12, and pressed the Ctrl + V keyboard shortcut.
5. Apply the Account- In the Home Ribbon Tab in the Number Ribbon Group,
ing Number Format you clicked the Number Format drop-down arrow. In
to the selected cells. the Number Format menu, you selected the Account-
ing option.
6. Apply the Ion theme In the Page Layout Ribbon Tab in the Themes Ribbon
to the workbook. Group, you clicked the Themes button. In the Themes
menu, you selected the Ion option.
7. Use AutoFill to copy You clicked and dragged the cell E2 fill handle, re-
the formula and for- leased the mouse button on cell E6.
matting in cell E2 to
cells E3:E6.
8. Select cells A5:D8. You clicked cell A5, and selected the cell range A5:D8.
9. Add a Blue, Ac- On the Home tab, in the Font group, click the Fill Color
cent 5 (in the top button arrow to display the color palette. Click the Blue,
row of theme col- Accent 5 color, the second color from the right in the
ors, the second col- first row of theme colors.
or from the right) bot-
tom border to the se-
lected cells. Use the
thickest single line
style available.
, EXCEL EXAM TEST QUESTIONS WITH VERIFIED ANSWERS
10. Use Format Painter In the Home Ribbon Tab in the Clipboard Ribbon
to copy the format- Group, you clicked the Format Painter button. You
ting from cell D1 and clicked cell E1.
apply it to cell E1.
11. Change font size for In the Home Ribbon Tab in the Font Ribbon Group,
the selected cells to you clicked the Font Size drop-down arrow. In the Font
18. Size menu, you selected the 18pt font size.
12. Use AutoSum to en- In the Home Ribbon Tab in the Editing Ribbon Group,
ter a formula in the you clicked the AutoSum button arrow. In the AutoSum
selected cell to cal- menu, you clicked the Sum menu item. You pressed
culate the total of all Enter.
the contiguous cells
above.
13. Wrap the text in the In the Home Ribbon Tab in the Alignment Ribbon
selected cell. Group, you clicked the Wrap Text button.
14. Autofit column D to You double-clicked column D's right border.
best fit the data.
15. Apply the Top and In the Home Ribbon Tab in the Font Ribbon Group, you
Bottom Border to the clicked the Borders button arrow. In the Borders menu,
selected cells with a you clicked the Top and Bottom Border menu item.
single command.
16. Use a single com- In the Home Ribbon Tab in the Editing Ribbon Group,
mand to clear every- you clicked the Clear button. In the Clear menu, you
thing (content and clicked the Clear All menu item.
formatting) from the
selected cell.
17. Change the font col- In the Home Ribbon Tab in the Font Ribbon Group, you
or of the select- clicked the Font Color button arrow. In the Font Color
ed cells to the menu, you selected the Blue-Gray, Text 2 color option.
Blue-Gray, Text 2 col-
or (it is the fourth op-
tion in the first row
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MERCYTRISHIA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
