End-Of-Chapter Quiz

Decent Essays
Excel Chapter 10: End-of-Chapter Quiz

1) Match each term with the correct definition (15 points)
A group of commands that enable you to bring data from an Access database, from the web, from a text file, or from an XML file into Excel without repeatedly copying the data.
Correct answer Get External Data

Link to external data that automatically updates an Excel workbook from the original data whenever the original data source gets new information.
Correct answer Data connection

All the categories of data pertaining to one database item such as a person, place, thing, event, or idea, stored in a horizontal row in a database.
Correct answer Record

Information that describes a record and is stored in columns.
Correct
…show more content…
Correct answer CONCATENATE

A function that returns the specified number of characters from the end of a string of characters. Correct answer RIGHT

A process of restricting records through the use of criteria conditions that displays records that answer a question about the data.
Correct answer Query

An organized collection of data related to a particular topic or purpose.
Correct answer Database

Facts about people, events, things, or ideas.
Correct answer Data

A predefined formula that performs calculations by using specific values, called arguments.
Correct answer Functions

The arrangement of arguments in a function.
Correct answer Syntax

A group of three, four, or five small graphic images that make your data visually easier to interpret. Correct answer Icon sets

An image of an active window on your computer that you can insert into a worksheet.
Correct answer Screenshot

2) Bringing data in from an external data source is known as: (1 point)
Correct answer Importing

3) This is stored in columns and contains a specific type of data such as name, employee number, or social security number. (1
…show more content…
(1 point)
Correct answer Delimited

9) A function that removes extra blank spaces from a string of characters. (1 point)
Correct answer TRIM

10) An Excel feature that predicts how to alter data based upon the pattern you enter into the cell at the beginning of the column. (1 point)
Correct answer Flash Fill

11) The values that an Excel function uses to perform calculations or operations. (1 point)
Correct answer Arguments

12) A database function that adds a column of values in a database that is limited by criteria set for one or more cells. (1 point)
Correct answer DSUM

13) The use of two or more conditions on the same row—all of which must be met for the records to be included in the results. (1 point) Correct answer Compound criteria
14) A database function that determines the number of occurrences of a specified condition in a database. (1 point)
Correct answer DCOUNT

15) Formatting characteristics that are applied to cells when the value in the cell meets a specified condition are called: (1 point)
Correct answer Conditional formats

16) In Excel, you can insert an image of an open window called a: (1

Related Documents

  • Improved Essays

    Nt1310 Unit 5 Exercise 1

    • 681 Words
    • 3 Pages

    1. Measures – p.117 – techniques or instruments used for measurement, referring to quantitative devices Researches can use different instruments to determine the level of concussion a player may have sustained 2. Nominal Scale – p.119 – a type of measurement that classifies a category based on numbers Concussions are measured using a nominal scale of 1-5, one being least severe and five being the most severe. 3. Frequency Distribution – p.121 - a type of measurement that helps organize data by grouping the data based on the number of times the same score was achieved…

    • 681 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    March Madness Conclusion

    • 488 Words
    • 2 Pages

    The fourth concept is time series data. Time series data is data collected over a period of time. Time series data was shown in this article using the column graph to show data from previous March Madness tournaments. The article used previous data on teams that won the first round and compared it to how many people pick that team to actually win in the first round.…

    • 488 Words
    • 2 Pages
    Decent Essays
  • Improved Essays

    Nt1320 Unit 2

    • 866 Words
    • 4 Pages

    These commands are used for updating, inserting, modifying, and querying the data within the database 10. By using SQL queries with any RDBMS, it is possible to create virtual tables, or dynamic views, whose contents materialize once documented. These views may typically be manipulated in the same way as a base table will be manipulated, through SQL SELECT queries. Materialized views, which area unit stored physically on a disk and refreshed at acceptable intervals or events, may also be used. 12.…

    • 866 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Part 1 Different data types and their uses - The different data types that is available for creating or developing a program on software. An example of programming software would be Microsoft Visual Studio. With this software, many data types are used which can drive an event. -…

    • 841 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Nt1310 Unit 9 Essay

    • 631 Words
    • 3 Pages

    Task 9 COMPARE the usefulness of MySQL and QBE Query by example is a language used for relational databases like SQL. Its development was parallel to that of SQL’s as a database language. It was originally only able to retrieve data from a database, it was then later updated to do other operations like insert, update and delete data from a relational database. It is easier and more productive than SQL as you do not need to remember the finer details of the language as you can easily select tables and columns without remembering the names.…

    • 631 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    Nt1310 Unit 5 Study Guide

    • 190 Words
    • 1 Pages

    Answer the following questions "True" or "False" only (Choose Five only) 1. Snipping tool used to captures different parts of the screen. 2. The user can add toolbars to the taskbar by right click on taskbar and select Toolbars. 3.…

    • 190 Words
    • 1 Pages
    Decent Essays
  • Improved Essays

    Basic Worksheet Questions: These questions/tasks are to be completed prior to class for each scheduled reading marked with an asterisk (*). When quoting or paraphrasing directly from the article, be sure to include the paragraph citation for easy reference during class discussion. 1.Quote a sentence (or two) from the article that best indicates the author’s main argument. In Adrian Mack’s and Miranda Nelson’s article, “Vancouver Hockey Riot Is a Symptom of a Larger Problem” the authors explain that the one of the main factors instigating the Vancouver hockey riot was that the fan’s loyalty to the sport “…exceeds far beyond a natural and healthy spirit of competitiveness or an appreciation of the beauty of the game itself.…

    • 712 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    Qlt1 Task 4

    • 394 Words
    • 2 Pages

    3.8) Data Analysis After collect the data from the respondents through questionnaire, the data will analyzed by using Statistical Software (SPSS) to ensure the relevant issues was examined in a comprehensive manner. Statistical tools and methods used where appropriate for analyzing the relationship among the variables and the model. 3.8.1) Descriptive statistics analysis The data that had collected will analyze based on the descriptive statistics analysis.…

    • 394 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    D1 Unit 3 Assignment

    • 637 Words
    • 3 Pages

    On November 1, 2016, you were assigned a project to make minor revisions to Standard Procedure 001:48:1, Disposition of Authority Property. Following the assignment of the project, you were instructed by me to: • Correct language errors, if any, in the published document On November 18, 2016, you submitted a draft procedure to me with the language error corrections you were recommending. The approximately 15 one-word recommendations you made included the following errors: • “Maintains an inventory of stored furnitures for use in Central Office (CO) locations.” • Coordinates the transfer and disposal of office furnitures at CO locations only. (In both cases above, you added an “s” to furniture even though the word furniture is an uncountable noun.)…

    • 637 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    College to Career: A recent survey commissioned by Bentley University in 2014 found that “compared with business decision-makers and corporate recruiters, high school and college students were far less likely to define preparedness in terms of personal traits or work ethic” (Chase, 2015). This means skills and experience rank high for college students when they evaluate preparedness. Unfortunately, the same survey found “thirty-seven percent of recent college graduates give themselves a grade of “C” or lower on their individual level of preparedness” (Chase, 2015).…

    • 899 Words
    • 4 Pages
    Improved Essays
  • Decent Essays

    Fig 1.2 Classes of interrupts Program Generated by some condition that occurs as a results of an instruction execution, such as arithmetic overflow, division by zero, attempt to execute am illegal machine instruction, and reference outside a user's allowed memory space. Timer Generated by a timer within the processor. This allows the operating system to perform certain functions on a regular basis. I/…

    • 364 Words
    • 2 Pages
    Decent Essays
  • Superior Essays

    Zillow Case Study Essay

    • 1460 Words
    • 6 Pages

    Introduction In this case study, the business of Zillow.com in providing real estate information to all users to its website is explored, and the use of business intelligence by Zillow.com in its offering to customer, and the way it uses a data mart to market its new product, are discussed. In addition, this case study includes a discussion of various characteristics of information quality as seen from Zillow’s perspective, and how Zillow is using a data-driven website. Analysis Background of Zillow.com Zillow.com is an online web-based real estate site helping homeonwers, buyers to find and share information about real estate and mortgages. It allows users to access information anonoyoumously and free of charge, using the kinds of tools…

    • 1460 Words
    • 6 Pages
    Superior Essays
  • Improved Essays

    Problem Solving Essay

    • 656 Words
    • 3 Pages

    Problem Solving      There are many different strategies that good problem solvers use to solve a problem. Before using a strategy, you must remember a few things. First, take your time. Few good problem solvers solve problems fast. Second, don't give up.…

    • 656 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    1. In Oracle, when is it better to use materialized views? A. It is always better to use materialized views because views are obsolete and materialized views replace them B. When a query is slow and its results need to be cached…

    • 794 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    Functional chart b. Posts chart Examination Paper of Principles and Practices of Management 2 IIBM of Business Management c. Master chart d. Departmental chart 7. Communication which flow from the superiors to subordinates with the help of scalar chain is known as: a. Informal communication b. Downward communication c. Upward communication d. Oral communication 8. Needs for belongingness, friendship, love, affection, attention & social acceptance are comes under___________ a. Physiological needs b. Safety needs c. Ego needs d. Social needs 9. A management function which ensures “jobs to be filled with the right people, with the right knowledge, skill & attitude” is comes under__________ a.…

    • 1352 Words
    • 6 Pages
    Great Essays