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

    PICT Case Study

    • 1546 Words
    • 7 Pages

    Test parameter and parameter value was insert into CTWeb in two ways, manually or upload the value file. CTWeb also support constraints and weight where the value can be defined by CTWeb user. Another additional features of CTWeb is its ability to set base test suite where a list of test case was used as base for PROW algorithm. Having all information needed, CTWeb execute PROW algorithm for the second times to reduce pairs obtained from the first execution. Then, the result will be sorted according to the weight of each pairs.…

    • 1546 Words
    • 7 Pages
    Improved Essays
  • Improved Essays

    By modifying the various input values and then viewing the source code, one can gain a great deal of information on CSS column layouts. In the IBDjohn template generator, a user can enter such things as color, size, width and others into any form that leads to generation of an entire template. Once the user completes the last layout for the design, he or she can copy and paste the HTML -CSS code in order to get instant answers. In this format, there are five variables involved, each relating to different parts and settings of the web page. The first variable is Basic Settings, which includes font color, size and style as well as the border color.…

    • 1887 Words
    • 8 Pages
    Improved Essays
  • Superior Essays

    Facial Recognition Essay

    • 1426 Words
    • 6 Pages

    After this, the variance is found for all classes by using this mean value. Sigma2 = 1 / (n-k) * sum((x-mu)2). There are two additional steps required before making a final prediction using the LDA method, this paper will only look at the final function. Dk(x) = x * muk/〖sigma〗^2 -(〖muk〗^2/〖2sigma〗^2 +ln⁡(Plk)) where “Dk(x) is the discriminate function for class k given input x, the muk, sigma2 and Plk are all estimated from your data. (Browniee).…

    • 1426 Words
    • 6 Pages
    Superior Essays
  • Improved Essays

    In first step we was modeling and analyzing some square shaped structure with ABAQUS and used results to solve finite-element partial differential equation adaptive to structural analysis. r r t ve a fini l mesh g er ormul n ruc ral analys i to e n sic equ eri lly. Follo la e s ur lem ̈ ( + ) − + − ̈ = 2. In the 2nd step, we start improving our Kohonen algorithm by using Computer Programming and Math softwares MATLAB and STUDIO-1. During this step, the network must be fed a large number of example vectors that represent the kinds of vectors expected during mapping.…

    • 1393 Words
    • 6 Pages
    Improved Essays
  • Great Essays

    Serial Correlation Essay

    • 1588 Words
    • 6 Pages

    MSER Technique Our final analysis method was the MSER technique. MSER seeks to determine an optimal truncation point that helps mitigate bias without losing precision in our results. Using the data generated from the replication/deletion method, we generated the MSER statistics using the Ruby script, mser.rb. The script created a data file with 10 different means (x ̅) and the remaining observations after truncation (n), outlined in Table 2. We will refer to n as our sample size for each run.…

    • 1588 Words
    • 6 Pages
    Great Essays
  • Great Essays

    Home Page – Login Input Data Elements To get access to the system, the users input username and password. The inputs are of VarChar data type with 10 characters limit. They will be passed by value to the database. 4.5.3 Output Data Elements Identifier Description Data Type Limit/Range Destination(s) Output Method isSuccessful Message Bool 0 = False 1 = True Home Page GUI Table 2. Home Page – Login Output Data Elements The output is of boolean type.…

    • 713 Words
    • 3 Pages
    Great Essays
  • Great Essays

    UUIDs fit the bill here, so each device was identified by a UUID (Leach, Mealling, & Salz, 2005). The value in the dictionary had to be customized to store data for a client. Therefore, I created a class that could hold a variety of information regarding the client. The next step was to create the handlers for each command. I created a “connect” URL that clients visited the first time they connected to the botnet, a “checkin” URL that they check in to every 30 seconds, and a “fileupload” URL where the client sends a file and metadata to the server.…

    • 2049 Words
    • 9 Pages
    Great Essays
  • Great Essays

    The Wordpress homepage and main user tasks were studied Once these usability problems were identified, they were prioritized based on their severity and ease in fixing. Heuristics Used Many heuristics methods are available to help evaluate websites. To best evaluate the website, I combined a set of ten heuristics by Jacob Nielson, Norman principles as well as Gestalt principle. The ten heuristics used to evaluate the Wordpress website are listed below. 1.…

    • 867 Words
    • 4 Pages
    Great Essays
  • Great Essays

    Calculate descriptive statistics for the mean and median columns that where created above. Pull up Stat > Basic Statistics > Display Descriptive Statistics and set Variables: to mean and median. The output will show up in your Session Window. Print this information. Calculating Confidence Intervals for one Variable ?…

    • 2523 Words
    • 11 Pages
    Great Essays
  • Improved Essays

    The purpose of an operating system is to run applications, such as Microsoft word, PowerPoint, adobe flash and Firefox browser. It manages devices by detecting if they are not working and telling you to remove the device and replace it with a new deice. It manages the processor by making sure that each application and process receives enough of the processors time. The operating system manages files by allowing you to save files and to allow you to make the files. It also allows you to sort them into folders.…

    • 2321 Words
    • 9 Pages
    Improved Essays