Microsoft Excel Basics
30 Questions
0 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 is the procedure to select a range of cells in a worksheet?

  • Drag from the first cell to the last cell, and then press the Shift key
  • Click the first cell, hold down the Ctrl key, and then click the last cell
  • Click the first cell, hold down the Shift key, and then click the last cell (correct)
  • Click the first cell, hold down the Alt key, and then click the last cell

    • How do you deselect a range of cells?

  • Press any arrow key or click any cell in the worksheet (correct)
  • Press the F1 key
  • Hold down the Shift key and click the first cell
  • Hold down the Ctrl key and click the last cell

    • What is the shortcut to select nonadjacent cells or ranges?

  • Hold down the Shift key
  • Hold down the Alt key
  • Press the F2 key
  • Hold down the Ctrl key (correct)

    • How do you select a single row or column?

    <p>Click the header of the row or column</p> Signup and view all the answers

    What is the purpose of pressing the Esc key during editing?

    <p>To return the cell to its previous state</p> Signup and view all the answers

    What is the procedure to select multiple adjacent rows or columns?

    <p>Click the header of the first row or column, hold down the Shift key, and then click the header of the last row or column</p> Signup and view all the answers

    How can you undo an action in Excel?

    <p>By clicking the Undo button on the Quick Access toolbar or by pressing Ctrl + Z</p> Signup and view all the answers

    How do you select multiple nonadjacent rows or columns?

    <p>Hold down the Ctrl key and click the headers of the rows or columns</p> Signup and view all the answers

    What is the function of the Clipboard group on the Home tab?

    <p>To access temporary storage area</p> Signup and view all the answers

    How do you move a cell to a new location?

    <p>Select the cell, click the Cut button, and then click the Paste button</p> Signup and view all the answers

    What is the purpose of the Font group on the Home tab?

    <p>To contain the most commonly used formatting commands</p> Signup and view all the answers

    What is the result of pressing the Backspace key while editing?

    <p>Deletes the character to the left of the cursor</p> Signup and view all the answers

    How can you change the font size of a cell?

    <p>By clicking the Font button on the Home tab and selecting a font size</p> Signup and view all the answers

    What is the purpose of the Number group on the Home tab?

    <p>To contain the most commonly used commands for formatting numbers</p> Signup and view all the answers

    What is the purpose of pressing the Enter key after editing?

    <p>To save the changes made</p> Signup and view all the answers

    How do you copy a cell?

    <p>Select the cell, click the Copy button, and then click the Paste button</p> Signup and view all the answers

    How can you remove all borders from a selected cell?

    <p>By clicking the Borders arrow and selecting No Border on the menu</p> Signup and view all the answers

    What is the shortcut key to redo an action in Excel?

    <p>Ctrl + Y</p> Signup and view all the answers

    What is the primary function of the Alignment group in the Home tab of the Ribbon?

    <p>To change the horizontal and vertical alignment of cell contents</p> Signup and view all the answers

    What is the effect of clicking the Centre button in the Alignment group?

    <p>The cell contents are centred horizontally within the cell</p> Signup and view all the answers

    What is the purpose of indenting data in a cell?

    <p>To indicate a level of less importance</p> Signup and view all the answers

    How do you indent data in a cell?

    <p>By clicking the Increase Indent button</p> Signup and view all the answers

    What is the effect of clicking the Align Right button in the Alignment group?

    <p>The cell contents are aligned with the right edge of the cell</p> Signup and view all the answers

    What is the function of the Top Align button in the Alignment group?

    <p>To align the cell contents with the top edge of the cell</p> Signup and view all the answers

    What is the purpose of rotating data in a cell?

    <p>To label narrow columns or add visual impact</p> Signup and view all the answers

    How do you restore the data to its default orientation after rotating it?

    <p>By clicking the Orientation button and selecting the currently selected orientation</p> Signup and view all the answers

    What happens to the row height when you wrap data within a cell?

    <p>It increases</p> Signup and view all the answers

    What is the result of merging cells with data in more than one cell?

    <p>The data in the upper-left cell remains</p> Signup and view all the answers

    Where is the Orientation button located?

    <p>In the Alignment group on the Home tab</p> Signup and view all the answers

    What is the purpose of wrapping data within a cell?

    <p>To display data on multiple lines within a cell</p> Signup and view all the answers

    More Like This

    Microsoft Excel Fundamentals
    10 questions

    Microsoft Excel Fundamentals

    VeritableTonalism avatar
    VeritableTonalism
    Microsoft Excel Spreadsheets Fundamentals
    8 questions

    Microsoft Excel Spreadsheets Fundamentals

    ThumbUpRetinalite5336 avatar
    ThumbUpRetinalite5336
    Microsoft Excel Basics
    12 questions

    Microsoft Excel Basics

    IdolizedPansy avatar
    IdolizedPansy
    Microsoft Excel Basics
    28 questions

    Microsoft Excel Basics

    SparklingUkiyoE6607 avatar
    SparklingUkiyoE6607
    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser