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 (D)</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 (C)</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 (B)</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 (D)</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 (C)</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 (C)</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 (B)</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 (A)</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 (C)</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 (C)</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 (A)</p> Signup and view all the answers

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

    <p>To save the changes made (C)</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 (D)</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 (A)</p> Signup and view all the answers

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

    <p>Ctrl + Y (B)</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 (D)</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 (C)</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 (C)</p> Signup and view all the answers

    How do you indent data in a cell?

    <p>By clicking the Increase Indent button (C)</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 (D)</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 (A)</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 (C)</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 (D)</p> Signup and view all the answers

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

    <p>It increases (C)</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 (D)</p> Signup and view all the answers

    Where is the Orientation button located?

    <p>In the Alignment group on the Home tab (A)</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 (B)</p> Signup and view all the answers

    More Like This

    Microsoft Excel Fundamentals
    10 questions

    Microsoft Excel Fundamentals

    VeritableTonalism avatar
    VeritableTonalism
    Formulas and Charts in Microsoft Excel
    5 questions

    Formulas and Charts in Microsoft Excel

    TopnotchApostrophe avatar
    TopnotchApostrophe
    Microsoft Excel Spreadsheets Fundamentals
    8 questions

    Microsoft Excel Spreadsheets Fundamentals

    ThumbUpRetinalite5336 avatar
    ThumbUpRetinalite5336
    Microsoft Excel Basics
    28 questions

    Microsoft Excel Basics

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