Excel Exam Flashcards
24 Questions
100 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

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?

<p>Click the Accounting Number Format button on the Home tab.</p> Signup and view all the answers

What action modifies number format so no decimal places are visible?

<p>Click the Decrease Decimal button twice.</p> Signup and view all the answers

How do you change the number format in a selected cell to Currency?

<p>Click the Number Format arrow and select Currency.</p> Signup and view all the answers

Describe how to use AutoFill from cell B7 through cell E7.

<p>Click the Fill Handle tool and drag across to cell E7.</p> Signup and view all the answers

What formula is entered to calculate profit projection for 2020?

<p>=F4-F5</p> Signup and view all the answers

What formula is entered to display the owner's draw percentage in cell B6?

<p>=B6</p> Signup and view all the answers

How do you edit the formula in cell D2?

<p>Change the formula to =C2+(C2*$B$9)</p> Signup and view all the answers

How do you merge and center text across multiple cells?

<p>Click the Merge &amp; Center button on the Home tab.</p> Signup and view all the answers

How can you unmerge the merged and centered cells?

<p>Click the Merge &amp; Center button.</p> Signup and view all the answers

What formatting is applied to a selected cell to make it bold and italic?

<p>Press bold and italic.</p> Signup and view all the answers

How do you remove just the italic formatting from a selected cell?

<p>Take off italic.</p> Signup and view all the answers

How do you apply Double Accounting underline format?

<p>Click the Font dialog launcher to open the Format Cells dialog.</p> Signup and view all the answers

How do you change the font for the selected cell to Cambria?

<p>Click the Font arrow and select Cambria.</p> Signup and view all the answers

What size do you change the font to for selected cells?

<p>18</p> Signup and view all the answers

How do you change the font color of selected cells to blue?

<p>Click the Font Color arrow and select Blue.</p> Signup and view all the answers

How do you remove borders from selected cells?

<p>Click the Borders button arrow and select No Border.</p> Signup and view all the answers

What action applies Top and Bottom Border to selected cells?

<p>Click the Borders button arrow and select Top and Bottom Border.</p> Signup and view all the answers

How do you add a blue bottom border to selected cells using the thickest line style?

<p>Select More Borders, choose the thickest line and select Blue.</p> Signup and view all the answers

How do you apply the Accent1 cell style to a selected cell?

<p>Click the Cell Styles button and select Accent1.</p> Signup and view all the answers

How do you apply the Total cell style to selected cells?

<p>Click the Cell Styles button and select Total.</p> Signup and view all the answers

What formula is entered in cell B7 to calculate the average of cells B2:B6?

<p>Use the AutoSum button and select Average.</p> 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.

Quiz Team

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!

More Like This

Excel Expertise Exam
4 questions

Excel Expertise Exam

IrreplaceablePeace avatar
IrreplaceablePeace
MGSC Exam 1 Flashcards
26 questions
Excel Chapter 3 Exam Study Guide
31 questions
MGST 217 Final Exam Study Notes
24 questions

MGST 217 Final Exam Study Notes

GenialMorningGlory4157 avatar
GenialMorningGlory4157
Use Quizgecko on...
Browser
Browser