1. If you wished to highlight, not hide, some information in a worksheet because it met some criteria, what Excel tool would you use?
1) Table
2) Format
3) Conditional Format
4) Filter
5) None of these
2. What Excel tool allows you to create quickly and automatically summary data from a large data set?
1) Conditional formatting
2) Sorting
3) Pivot tables 4
4) Field lists
5) None of these
3. When creating a custom filer in Excel, which of the following would not be considered a Boolean operator?
1) If
2) And
3) Or
4) Not
5) None of these
4. Which of the following is a good habit to get into when creating a worksheet?
1) Placing titles for columns in the first row of data
2) Using conditional formatting to spot spelling errors
3) Inserting comments in each cell to define that data or type of data
4) Grouping records according to some classification
5) None of these
5. What term is used to describe a collection of information that you can use to build reports or discover facts about an environment?
1) Database
2) Web site
3) Wiki
4) Relation
5) None of these
6. Microsoft's Access and Corel's Paradox are both examples of which type of software?
1) Network database systems
2) Relational database systems
3) Flat-file database systems
4) Hierarchical database systems
5) None of these
7. What type of graphical model is used to define a database?
1) Flowchart
2) E-R diagram
3) Organizational model
4) Programming model
5) None of these
8. After you develop a model for your database, you should then _____ it before building it.
1) normalize
2) design
3) plan
4) approve
5) None of these
9. Which of the following contains information about the structure of a database?
1) Database management system
2) Data dictionary
3) Data repository
4) Data warehouse
5) None of these
10. The rules of a language are called its __________.
1) structure
2) code
3) syntax
4) rigidity
5) None of these
11. A language that can be written on one platform and executed on another platform is said to be __________.
1) portable
2) robust
3) third generation
4) dynamic
5) None of these
12. __________ is Microsoft’s latest entry into the programming arena.
1) Java
2) .NET
3) Visual Basic
4) Pascal
5) None of these
13. A next-generation Web content development language, __________ typically refers to a suite of technologies that allow developers to store data in a readable format.
1) HTML
2) XSL
3) XML
4) PHP
5) None of these
14. JavaScript was developed by __________ to run inside of web pages.
1) Microsoft
2) Sun
3) Oracle
4) Netscape
5) None of these
1) Table
2) Format
3) Conditional Format
4) Filter
5) None of these
2. What Excel tool allows you to create quickly and automatically summary data from a large data set?
1) Conditional formatting
2) Sorting
3) Pivot tables 4
4) Field lists
5) None of these
3. When creating a custom filer in Excel, which of the following would not be considered a Boolean operator?
1) If
2) And
3) Or
4) Not
5) None of these
4. Which of the following is a good habit to get into when creating a worksheet?
1) Placing titles for columns in the first row of data
2) Using conditional formatting to spot spelling errors
3) Inserting comments in each cell to define that data or type of data
4) Grouping records according to some classification
5) None of these
5. What term is used to describe a collection of information that you can use to build reports or discover facts about an environment?
1) Database
2) Web site
3) Wiki
4) Relation
5) None of these
6. Microsoft's Access and Corel's Paradox are both examples of which type of software?
1) Network database systems
2) Relational database systems
3) Flat-file database systems
4) Hierarchical database systems
5) None of these
7. What type of graphical model is used to define a database?
1) Flowchart
2) E-R diagram
3) Organizational model
4) Programming model
5) None of these
8. After you develop a model for your database, you should then _____ it before building it.
1) normalize
2) design
3) plan
4) approve
5) None of these
9. Which of the following contains information about the structure of a database?
1) Database management system
2) Data dictionary
3) Data repository
4) Data warehouse
5) None of these
10. The rules of a language are called its __________.
1) structure
2) code
3) syntax
4) rigidity
5) None of these
11. A language that can be written on one platform and executed on another platform is said to be __________.
1) portable
2) robust
3) third generation
4) dynamic
5) None of these
12. __________ is Microsoft’s latest entry into the programming arena.
1) Java
2) .NET
3) Visual Basic
4) Pascal
5) None of these
13. A next-generation Web content development language, __________ typically refers to a suite of technologies that allow developers to store data in a readable format.
1) HTML
2) XSL
3) XML
4) PHP
5) None of these
14. JavaScript was developed by __________ to run inside of web pages.
1) Microsoft
2) Sun
3) Oracle
4) Netscape
5) None of these
1. 3
2. 3
3. 1
4. 1
5. 1
6. 1
7. 2
8. 2
9. 1
10. 3
11. 1
12. 2
13. 3
14. 4
No comments:
Post a Comment