Questions and Answers
What do you enter in cell C7?
530
What word do you add to cell A9?
TOTAL
What value should be changed in cell B6?
725
How do you apply the Accounting Number Format to selected cells?
Signup and view all the answers
What action modifies number format so no decimal places are visible?
Signup and view all the answers
How do you change the number format in a selected cell to Currency?
Signup and view all the answers
Describe how to use AutoFill from cell B7 through cell E7.
Signup and view all the answers
What formula is entered to calculate profit projection for 2020?
Signup and view all the answers
What formula is entered to display the owner's draw percentage in cell B6?
Signup and view all the answers
How do you edit the formula in cell D2?
Signup and view all the answers
How do you merge and center text across multiple cells?
Signup and view all the answers
How can you unmerge the merged and centered cells?
Signup and view all the answers
What formatting is applied to a selected cell to make it bold and italic?
Signup and view all the answers
How do you remove just the italic formatting from a selected cell?
Signup and view all the answers
How do you apply Double Accounting underline format?
Signup and view all the answers
How do you change the font for the selected cell to Cambria?
Signup and view all the answers
What size do you change the font to for selected cells?
Signup and view all the answers
How do you change the font color of selected cells to blue?
Signup and view all the answers
How do you remove borders from selected cells?
Signup and view all the answers
What action applies Top and Bottom Border to selected cells?
Signup and view all the answers
How do you add a blue bottom border to selected cells using the thickest line style?
Signup and view all the answers
How do you apply the Accent1 cell style to a selected cell?
Signup and view all the answers
How do you apply the Total cell style to selected cells?
Signup and view all the answers
What formula is entered in cell B7 to calculate the average of cells B2:B6?
Signup and view all the answers
Study Notes
Excel Basic Commands
- Enter the number 530 in cell C7 by typing and pressing Enter.
- Add the word TOTAL to cell A9 and press Enter to confirm.
Cell Value Modifications
- Change the value in cell B6 to 725, ensuring to press Enter afterward.
Number Formatting
- Apply Accounting Number Format from the Home tab in the Number group by clicking the appropriate button.
- Remove decimal places by clicking the Decrease Decimal button twice in the Number group.
Currency Formatting
- Change a selected cell’s number format to Currency using the Number Format arrow on the Home tab.
Series Completion
- Complete a series from cell B7 to E7 by using the Fill Handle tool to drag across.
Formulas
- Calculate profit projection for 2020 by entering
=F4-F5
in the selected cell, followed by pressing Enter. - Enter a formula to display owner's draw percentage in cell B6 using
=B6
.
Formula Editing and Autofill
- Edit cell D2 to ensure C2 updates when copied while maintaining a constant reference to cell B9 with
=C2+(C2*$B$9)
, then use Autofill down to D6.
Cell Merging and Centering
- Merge cells and center text by clicking the Merge & Center button in the Alignment group.
Unmerging Cells
- Unmerge previously merged and centered cells using the same Merge & Center button.
Text Formatting
- Apply both bold and italic formatting by pressing the respective buttons.
- Remove italic formatting by unselecting the Italic option.
Special Formatting
- Apply Double Accounting underline via the Font dialog launcher and selecting it under the Underline section.
- Change font to Cambria using the Font arrow in the Font group.
Font Adjustments
- Set the font size for selected cells to 18 via the Font Size arrow.
- Change font color to standard Blue by selecting it from the Font Color arrow.
Borders Management
- Remove all borders from selected cells quickly using the No Border option.
- Apply Top and Bottom Border by selecting it from the Borders button arrow.
Customized Borders
- Add a thick Blue bottom border using More Borders... option, choosing the thickest line style available.
Cell Styles Applications
- Apply Accent1 cell style through the Cell Styles button.
- Apply Total cell style to selected cells in the Styles group.
Average Calculation
- Calculate average value for cells B2 to B6 in cell B7 by selecting Average from the AutoSum button arrow.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your skills with these Excel exam flashcards. Each flashcard provides specific instructions on how to perform tasks in Excel, perfect for beginners and advanced users alike. Brush up on your knowledge and get ready for your exam!