Computer Final Flashcards
50 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

Which of the following function keys makes it easier to insert a range name in a formula?

  • F4
  • F5
  • F2
  • F3 (correct)

    • By default, what file extension is given to Excel 2016 workbook files?

    .xlsx

    How many items can the Office Clipboard hold?

    24

    Before using the Merge and Center command, what cell should contain the data?

    <p>upper-left cell</p> Signup and view all the answers

    To select adjacent worksheets, which key must you press?

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

    Which of the following describes the section of worksheets that prints?

    <p>print area</p> Signup and view all the answers

    Which of the following characters precedes Excel functions?

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

    Which of the following is included in calculations?

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

    What is selected when you point to and click a column heading?

    <p>the entire column</p> Signup and view all the answers

    By default, how does Excel align numeric entries in a cell?

    <p>bottom right corner of a cell</p> Signup and view all the answers

    Hiding a row deletes the data from the row.

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

    Which of the following formulas correctly adds the values in cells E4 and E5?

    <p>=E4+E5</p> Signup and view all the answers

    Which of the following formulas includes only relative references?

    <p>=D21+E21</p> Signup and view all the answers

    Which of the following has an answer of 4?

    <p>10-(3*2)</p> Signup and view all the answers

    Which of the following cell addresses will change when it is copied?

    <p>$F2</p> Signup and view all the answers

    Which of the following features displays numerical results such as SUM, AVERAGE, and COUNT on the status bar for selected cells?

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

    Which of the following characters must always start a function?

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

    Which of the following cell addresses doesn't change when copied?

    <p>$F$2</p> Signup and view all the answers

    In a chart, which of the following can you fill with pictures?

    <p>all of the above</p> Signup and view all the answers

    In a pie chart, what is a data series represented by?

    <p>the whole pie</p> Signup and view all the answers

    Which of the following explains the symbols, textures, or colors used to differentiate data series?

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

    By default, Excel adds a data table to the right of all charts.

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

    Which of the following terms refers to a group of data points or values?

    <p>data series</p> Signup and view all the answers

    Which of the following keys creates an automatic column chart sheer for selected data?

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

    Which of the following enables you to begin editing a chart title?

    <p>triple-clicking the Chart title placeholder</p> Signup and view all the answers

    When you sort a cell range using A to Z or Z to A, what is rearranged?

    <p>complete rows of data</p> Signup and view all the answers

    What type of file can most software applications read?

    <p>text files</p> Signup and view all the answers

    Which kinds of source data can you import into Excel?

    <p>all of the above</p> Signup and view all the answers

    How does Excel treat dates?

    <p>as values</p> Signup and view all the answers

    In an Excel table, which of the following represents a row of data?

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

    Which of the following can you sort Excel data by?

    <p>all of the above</p> Signup and view all the answers

    In an Excel table, which of the following contains descriptive titles or labels?

    <p>header row</p> Signup and view all the answers

    In an Excel table, which of the following represents a column of data?

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

    Where is the Take a Screenshot command located?

    <p>Insert Tab, Illustrations group</p> Signup and view all the answers

    Which of the following is not an example of SmartArt objects?

    <p>text effects</p> Signup and view all the answers

    Which command links workbooks?

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

    Which of the following includes or refers to data from another workbook?

    <p>dependent workbook</p> Signup and view all the answers

    How many arguments do all database functions have?

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

    Which of the following text functions combines text strings?

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

    Which of the following refers to a range of cells that includes a header row and rows of data?

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

    Excel uses a 12-hour day in time calculations.

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

    Which of the following is one way that Excel helps you follow proper syntax?

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

    Templates cannot include formulas.

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

    Which of the following tabs is used to edit or delete a comment?

    <p>Review tab</p> Signup and view all the answers

    Which of the following tasks can you perform using a data input form?

    <p>all of the above</p> Signup and view all the answers

    Which name is assigned to the person who shares a workbook?

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

    Which of the following commands is not available in a shared workbook?

    <p>all of the above</p> Signup and view all the answers

    Which of the following extensions does Excel assign to templates?

    <p>.xltx</p> Signup and view all the answers

    Which of the following are the rules applied to data as it is entered?

    <p>validation settings</p> Signup and view all the answers

    Using the Text Import Wizard to set the type of delimiter used in a text file, which of the following delimiters is commonly used?

    <p>all of the above</p> Signup and view all the answers

    Study Notes

    Excel Functionality and Features

    • F3 makes it easier to insert a range name in a formula.
    • By default, Excel 2016 workbook files use the .xlsx file extension.
    • The Office Clipboard can hold up to 24 items.
    • Merge and Center command requires the upper-left cell to contain data.
    • To select adjacent worksheets, press Shift.
    • The section of worksheets that prints is known as the print area.
    • Excel functions must begin with the = character.
    • Calculations only include values, which are specific numerical entries.

    Cell Selection and Alignment

    • Clicking on a column heading selects the entire column.
    • Numeric entries are aligned by default to the bottom right corner of a cell.
    • Hiding a row does not delete the data; instead, it conceals it.

    Formulas and References

    • Correctly adding E4 and E5 is done with the formula =E4+E5.
    • The formula =D21+E21 includes only relative references.
    • The expression 10-(3*2) evaluates to 4.
    • The cell address $F2 changes when copied, while $F$2 remains unchanged.

    Charting and Data Representation

    • AutoCalculate feature shows numerical results like SUM and AVERAGE on the status bar.
    • All chart elements can be filled with pictures.
    • In a pie chart, the data series is represented by the whole pie.
    • A legend explains the symbols, textures, or colors used for data series differentiation.

    Data Tables and Sorting

    • Excel auto adds a data table to the right of all charts.
    • Data series refers to a group of data points or values.
    • Creating an automatic column chart is done with the F11 key.
    • Sorting a cell range rearranges complete rows of data.

    File Types and Data Import

    • Most software applications can read text files.
    • Excel can import all kinds of source data.
    • Excel treats dates as values for calculations.
    • A record represents a row of data in an Excel table.

    Excel Organization and Commands

    • Excel data can be sorted by various criteria.
    • A header row in an Excel table contains descriptive titles or labels.
    • A field represents column data in an Excel table.
    • The Take a Screenshot command is located in the Insert Tab within the Illustrations group.

    SmartArt and Team Collaboration

    • Text effects are not considered SmartArt objects.
    • Use the Consolidate command to link workbooks.
    • A dependent workbook refers to data from another workbook.
    • All database functions require 3 arguments.

    Text Functions and Calculations

    • The CONCAT function combines text strings.
    • A database encompasses a range of cells with a header row and data rows.
    • Excel follows a 24-hour day for time calculations, contrary to the notion of a 12-hour day.
    • Formula AutoComplete aids in proper syntax during formula entry.

    Templates and Comments

    • Excel templates are capable of including formulas.
    • The Review tab is used to edit or delete comments in a workbook.
    • Data input forms allow users to perform various data-related tasks.

    Workbook Sharing and Settings

    • The person sharing a workbook is termed the owner.
    • Certain commands may not be available in a shared workbook environment.
    • Excel assigns the extension .xltx to templates.
    • Validation settings apply rules to data as it is entered.

    Text Import and Delimiters

    • The Text Import Wizard uses delimiters to distinguish cells in a text file, with various common delimiters applicable.

    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 for the Computer Final exam. Covering key concepts such as Excel functions, clipboard capacity, and file extensions, this quiz will help reinforce your understanding of essential computer skills. Ideal for students preparing for their final assessments.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser