MS Excel Shortcuts and Concepts
19 Questions
3 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

Which of the following keys is pressed in order to move between the cells in MS-Excel? (Select all that apply)

  • Tab key
  • Arrow key
  • Enter key
  • All of these (correct)
  • What combination/shortcut keys will help you select the entire row of the active cell?

  • Shift + Space bar (correct)
  • Ctrl + F1
  • Ctrl + Space bar
  • Alt + Space bar
  • In MS-Excel, how is the range of cells in column A and rows 2 through 12 represented?

  • A2:A12 (correct)
  • A2:A10
  • A10/A12
  • Which shortcut key will access the entire column of an active cell?

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

    Which key should be pressed to activate the extend indicator (EXT) in the status bar?

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

    The intersection of rows and columns is known as?

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

    An Excel workbook is a collection of?

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

    Select the correct example of a cell address:

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

    Which is an example of a function?

    <p>=sum(B1:B5)</p> Signup and view all the answers

    Formulas in Excel start with:

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

    The Name Box:

    <p>Appears to the left of the formula bar.</p> Signup and view all the answers

    Which area in an Excel window allows entering values and formulas?

    <p>Formula Bar</p> Signup and view all the answers

    Excel displays the current cell address in the:

    <p>Name box</p> Signup and view all the answers

    A _____ is a grid with labelled columns and rows.

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

    Shortcut keys will help you to go to the top of the worksheet?

    <p>CTRL + HOME</p> Signup and view all the answers

    Shortcut keys will help you to go to the end of the worksheet?

    <p>CTRL + END</p> Signup and view all the answers

    Shortcut keys will help you to apply number format in MS Excel?

    <p>CTRL + SHIFT + 1</p> Signup and view all the answers

    Default column width in Excel is:

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

    Default row height in Excel is:

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

    Study Notes

    MS Excel Shortcuts

    • Move Between Cells: Use Tab, Enter, or arrow keys.
    • Select Entire Row: Use Shift + Space bar.
    • Select Entire Column: Use Ctrl + Spacebar.
    • Activate Extend Indicator (EXT): Use F8.
    • Go to Top of Worksheet: Use Ctrl + Home.
    • Go to End of Worksheet: Use Ctrl + End.
    • Apply Number Format: Use Ctrl + Shift + 1.

    MS Excel Concepts

    • Cell: The intersection of a row and a column.
    • Worksheet: A grid with labelled columns and rows, forming part of an Excel workbook.
    • Workbook: A collection of worksheets.
    • Formula Bar: Area where you enter values and formulas.
    • Name Box: Displays the current cell address.
    • Function: A pre-defined calculation, e.g., =SUM(B1:B5).
    • Default Column width: 8.43.
    • Default Row Height: 12.75.

    MS Excel Cell Reference

    • Cell addresses consist of a column letter and row number (e.g., A25).
    • A range of cells is represented by the starting cell, a colon, and the ending cell (e.g., A2:A12).

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    Description

    Test your knowledge of MS Excel shortcuts and key concepts with this quiz. Explore cell references, workbooks, and basic functionalities that make Excel an essential tool for data management. Perfect for beginners and intermediate users.

    More Like This

    Microsoft Excel Shortcuts
    24 questions
    Excel Functions and Shortcuts Quiz
    20 questions

    Excel Functions and Shortcuts Quiz

    SucceedingLapisLazuli2023 avatar
    SucceedingLapisLazuli2023
    Excel Shortcuts and Features
    7 questions

    Excel Shortcuts and Features

    PromisingStonehenge avatar
    PromisingStonehenge
    Excel Shortcuts Quiz for IT Students
    5 questions

    Excel Shortcuts Quiz for IT Students

    TriumphalCharacterization avatar
    TriumphalCharacterization
    Use Quizgecko on...
    Browser
    Browser