Excel Definitions Flashcards
35 Questions
100 Views

Excel Definitions Flashcards

Created by
@WellConnectedComputerArt

Questions and Answers

What is Microsoft Office Excel 2007?

  • A spreadsheet program (correct)
  • A presentation program
  • A powerful database program
  • An email client
  • What is a workbook in Excel?

    An Excel document that contains three worksheets by default but can have more.

    What are worksheets in Excel?

    Excel's name for a computerized spreadsheet, identified by a tab at the bottom of the screen.

    What are charts in Excel?

    <p>Graphic representations that present information in easily interpreted formats.</p> Signup and view all the answers

    What is the purpose of tables in Excel?

    <p>Used to arrange text in columns and rows, helpful in presenting, organizing, and clarifying information.</p> Signup and view all the answers

    What does web support in Excel allow users to do?

    <p>Save Excel worksheets or parts of a worksheet in HTML format for viewing and manipulation in a browser.</p> Signup and view all the answers

    What is a column heading in Excel?

    <p>A column letter above the grid that identifies each column.</p> Signup and view all the answers

    What is a row heading in Excel?

    <p>A number at the far-left side of a row that can be clicked to select the entire row of cells.</p> Signup and view all the answers

    What is a cell in Excel?

    <p>The basic unit of a worksheet into which you enter data.</p> Signup and view all the answers

    What is a cell reference in Excel?

    <p>The column letter and the row number, for example, B12.</p> Signup and view all the answers

    What is an active cell in Excel?

    <p>The cell in a spreadsheet where information will be placed; it is the selected cell.</p> Signup and view all the answers

    What are gridlines in Excel?

    <p>Nonprinting lines that can be displayed around cells in a table.</p> Signup and view all the answers

    What is normal view in a presentation?

    <p>The default view that contains the slide pane, outline pane, task pane, and notes pane.</p> Signup and view all the answers

    What are scroll bars in Excel?

    <p>Appear on the right and bottom borders of a window when all contents are not visible.</p> Signup and view all the answers

    What are scroll arrows in Excel?

    <p>Arrows at the end of the scroll bar that can be clicked to move a document in small increments.</p> Signup and view all the answers

    What are scroll boxes in Excel?

    <p>A box in the center of a scroll bar that can be dragged to move a document.</p> Signup and view all the answers

    What is a status bar in Excel?

    <p>Located at the bottom of the window, it contains information about the document.</p> Signup and view all the answers

    What are mode indicators in Excel?

    <p>On the status bar, they specify the current mode of Excel, like Enter or Ready.</p> Signup and view all the answers

    What does 'Ready' indicate in Excel?

    <p>It indicates that the program is poised for action.</p> Signup and view all the answers

    What does 'Enter' mean in Excel?

    <p>The process of accepting data through the keyboard into the active cell.</p> Signup and view all the answers

    What are keyboard indicators in Excel?

    <p>They show which toggle keys are engaged, appearing to the right of the mode indicator.</p> Signup and view all the answers

    What is the Ribbon in Excel?

    <p>The control center in Excel.</p> Signup and view all the answers

    What does a tab do in Excel?

    <p>Surrounds a collection of groups.</p> Signup and view all the answers

    What is a group in Excel?

    <p>Contains related commands.</p> Signup and view all the answers

    What is the home tab in Excel?

    <p>The primary tab that contains the most frequently used commands.</p> Signup and view all the answers

    What is an active tab in Excel?

    <p>The tab currently displayed.</p> Signup and view all the answers

    What are contextual tabs in Excel?

    <p>Tabs that display when performing certain tasks or working with objects.</p> Signup and view all the answers

    What are Ribbon Commands in Excel?

    <p>Include buttons, boxes, and galleries.</p> Signup and view all the answers

    What is a gallery in Excel?

    <p>A set of choices, often graphical, arranged in a grid or list.</p> Signup and view all the answers

    What does 'in-ribbon' mean in Excel?

    <p>Shows common gallery choices on the Ribbon instead of a dropdown list.</p> Signup and view all the answers

    What is live preview in Excel?

    <p>A feature that allows you to preview a choice applied to the document without actually applying it.</p> Signup and view all the answers

    What is an enhanced screen tip in Excel?

    <p>An on-screen note that provides details about a command.</p> Signup and view all the answers

    What is a screen tip in Excel?

    <p>Shows the name of the command.</p> Signup and view all the answers

    What is a dialog box launcher in Excel?

    <p>A button that launches a dialog box with options for refining a command.</p> Signup and view all the answers

    What is a task pane in Excel?

    <p>A window that remains open while you work in the document.</p> Signup and view all the answers

    Study Notes

    Microsoft Office Excel 2007

    • A powerful spreadsheet program enabling data organization, calculations, decision making, and data visualization.
    • Facilitates the creation of professional reports, web publishing of data, and real-time data access.

    Workbook

    • An Excel document that by default includes three worksheets and can be expanded to contain more.

    Worksheets

    • Identified by tabs at the bottom of the screen, worksheets are Excel's version of computerized spreadsheets.

    Charts

    • Serve as graphic representations to display information in easily understandable formats.

    Tables

    • Organize text into columns and rows, enhancing presentation, organization, and clarity of information.

    Web Support

    • Enables saving of Excel worksheets in HTML format for browser-based viewing and editing.

    Column Heading

    • The letter displayed above each column, serving to identify it.

    Row Heading

    • A number located on the far-left side of a row that allows the entire row to be selected.

    Cell

    • The fundamental unit of a worksheet for data entry.

    Cell Reference

    • Consists of a column letter and row number, e.g., B12, identifying a specific cell.

    Active Cell

    • The currently selected cell where new data will be entered.

    Gridlines

    • Non-printing lines that outline cells in a table, improving readability.

    Normal View

    • The default workspace layout in Excel featuring multiple panes for slides, outlines, tasks, and notes.

    Scroll Bars

    • Appear on the window's edges to navigate through content when it exceeds visible space.

    Scroll Arrows

    • Clickable arrows at scroll bar ends for moving through documents in small increments.

    Scroll Boxes

    • Central draggable boxes on scroll bars enabling more extensive document navigation.

    Status Bar

    • Located at the window's bottom, displays document-specific information like page number and word count.

    Mode Indicators

    • Shown on the status bar, indicating Excel's current operational mode, such as "Ready" or "Enter."

    Ready

    • Indicates that Excel is primed for user actions.

    Enter

    • The process of inputting data into the active cell via keyboard.

    Keyboard Indicators

    • Located near the mode indicator, displaying the status of toggle keys like Scroll Lock.

    Ribbon

    • The main control interface in Excel, housing various command options.

    Tab

    • Encloses related command groups within the Ribbon.

    Group

    • A collection of related commands grouped together for ease of use.

    Home Tab

    • The primary tab in the Ribbon featuring frequently used commands.

    Active Tab

    • The tab currently being displayed and utilized.

    Contextual Tabs

    • Appear as needed when specific tasks or objects, such as images or tables, are selected.

    Ribbon Commands

    • Comprise buttons, boxes, and galleries for executing various functions.
    • A set of graphical or list-based options arranged for user selection.

    In-Ribbon

    • Displays common gallery selections directly on the Ribbon instead of in dropdown lists.

    Live Preview

    • Allows users to hover over options in a gallery to preview changes without committing them.

    Enhanced Screen Tip

    • Provides detailed on-screen information about commands, including names, shortcuts, and help instructions.

    Screen Tip

    • Displays the name of a specific command for user reference.

    Dialog Box Launcher

    • A button that opens a dialog box for detailed command options.

    Task Pane

    • A persistent window that remains visible during document editing for easy access to tools and commands.

    Studying That Suits You

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

    Quiz Team

    Description

    Test your knowledge with these flashcards focused on key definitions related to Microsoft Office Excel 2007. Each card provides important terminology to enhance your understanding of this powerful spreadsheet program. Perfect for beginners and those looking to refresh their Excel skills.

    More Quizzes Like This

    Excel 2007 Chart Formatting Quiz
    3 questions
    Excel 2007 Formatting Features Quiz
    9 questions
    Excel Chapter 3: End-of-Chapter Quiz
    30 questions
    Use Quizgecko on...
    Browser
    Browser