User Account

All Pages

How complicated are my data management tasks

Assignment Help Database Management System
Reference no: EM13948436

1. Cell E23 has a date value and you wish to place that date on an invoice prefaced with the text located in B15. What is the command to do that? (This question is from Chapter 6.)

a. =B15&E23

b. =proper(B15)&" "&text(E23,"mmmm dd, yyyy")

c. B15&" "&E23

d. =join(B15&E23)

e. =proper(B15)&" "&proper(E23)

2. To evaluate what a series of payments will be worth at some point in the future, which of the following should be used? (This question is from Chapter 6.)

a. =PMT

b. =FV

c. =PV

d. =ANNUITY

e. =IRR

3. The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called:

a. freezing

b. locking

c. selecting

d. fixing

e. securing

4. When you create two or four separate windows containing part of the spreadsheet that can be viewed, you have created:

a. sections

b. panes

c. views

d. subsheets

e. panels

5. To keep specific rows and columns from scrolling off the screen you first must position the cell pointer:

a. to the right of the column you want to remain on the screen

b. below the row you want to remain on the screen

c. on the row you want to remain on the screen

d. both A and B are correct

e. both A and C are correct

6. In order to determine the best approach for creating an Auto Outline, Excel uses the worksheet's existing:

a. formulas

b. table structure

c. layout

d. formatting

e. design

7. Which of the following indicates that a cell contains a note or comment?

a. the cell has a hashed border

b. a small red triangle appears in the upper-right corner of the cell

c. the cell is highlighted with a blue border

d. the cell has light blue shading

e. the cell has a moving marquee border

8. What questions do you ask yourself to determine whether Excel 2003 or a database management program, such as Access 2003, is the more suitable software? (Page: EX 432 Section: 8.1)

a. How complicated are my data management tasks?

b. How much data needs to be stored?

c. How much redundant data is expected?

d. How important is data validation?

e. All the above questions are very important in order to determine it.

9. If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort?

a. zip codes (ascending), then last name (ascending), then first name (ascending)

b. last name (ascending), then first name(ascending), then last name (ascending)

c. zip codes (descending), then last name(ascending), then first name(ascending)

d. last name (descending), then first name (descending), then last name (descending)

e. zip codes (ascending), then last name (descending), then first name (descending)

10. Which of the following commands will find a subset of records that match a particular range of values?

a. Data, Filter, AutoFilter

b. Data, Sort

c. Data, Sort, Consolidate

d. Data, Sort, Criteria, Find

e. Data, Filter, Filter Criteria

11. Which one of these can you not do using the Print dialog box?

a. print a range selection

b. print worksheet list

c. print the active worksheet

d. print the entire workbook

e. you can do all of the above using the Print dialog box

12. Which of the following will remove all filters placed on a worksheet list?

a. Data, Filter, Show All

b. Data, Sort, Show All

c. Data, Sort, Remove Filter

d. Data, Sort, Criteria, Find All

e. Data, Filter, Unfiltered

13. If you require more than two conditions or if you want to analyze a list using Excel 2003's database functions, you must define which filter?

a. Auto Filter

b. Update Filter

c. Advantage Filter

d. Advanced Criteria Filter

e. Extract Filter

14. Which of the following is the correct syntax for the COUNTIF function?

a. =COUNTIF(criteria, field_name, list_range)

b. =COUNTIF(criteria, field_range)

c. =COUNTIF(field_range, criteria)

d. =COUNTIF(list_range, field_name, criteria_range)

e. =COUNTIF(field_name, list_range, criteria_range)

15. Which of the following is the correct syntax for DAVERAGE?

a. =DAVERAGE(criteria_range, field_name, list_range)

b. =DAVERAGE(field_name, list_range, criteria_range)

c. =DAVERAGE(list_range, criteria_range, field_name)

d. =DAVERAGE(criteria_range, list_range, field_name)

e. =DAVERAGE(list_range, field_name, criteria_range)

Reference no: EM13948436

Questions Cloud

Identifies the primary principles of sociotechnical systems : Which of the following identifies the primary principles of sociotechnical systems theory, Which of the following HR responsibilities concerning virtual work is a source of heated debate
Stagnation pressure ratio of the compressor : Assuming both the diffuser and the compressor to be isentropic, determine (a) the stagnation pressure at the compressor inlet and (b) the required compressor work per unit mass if the stagnation pressure ratio of the compressor is 8.
Compute the fixed overhead spending and volume variances : Compute the following variances: Materials price and usage variances. Labor rate and efficiency variances. Variable overhead spending and efficiency variances. Fixed overhead spending and volume variances.
Should they experiment with other warehousing options : What did the original solver solution show as the minimum cost per month? What will be the minimum cost per month if Indianapolis is shut down?
How complicated are my data management tasks : To keep specific rows and columns from scrolling off the screen you first must position the cell pointer
Sphere and a uniform aluminium sphere : A uniform lead sphere and a uniform aluminium sphere have the same mass what is the ratio of the radius of aluminium sphere to the radius of the lead sphere?
Describes the point at issue between mike and joel : Which of the following questions describes the point at issue between Mike and Joel
Online banking management system - java project : Online Banking Management System Java Project - Identify Technical Advisor by name, contact information, position and responsibility
Minutes between successive arrivals : Arrivals at a telephone booth are considered to be poison, with an average time of 10 minutes between successive arrivals. The length of a phone call is distributes exponentially with mean3 minutes. The probability that an arrival does not have to..

Reviews

Write a Review

Database Management System Questions & Answers

  Database modeling and normalization

Database Modeling and Normalization

  Imagine that you have been hired as a consultant to assist

imagine that you have been hired as a consultant to assist in streamlining the data processing of an international

  Explain techniques for distributed data placement

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length.

  Draw the general hardware company entity-relational diagram

Draw the General Hardware Company Entity-Relational diagram. Choose a primary key for each of the relations. Choose foreign key(s) for each of the relations.

  The development of a centralized database

To allay these concerns and to improve the ease and efficiency with which the apartment managers conduct their daily business, the company is proposing the development of a centralized database that the managers can use to track the daily business..

  Write queries to find out the unused structures

Write queries to find out the unused structures e.g. there is one Superannuation client but no Partnership clients on the starter database.

  Find that the data structure holds redundant data

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks..

  Display structure of the i_model table

Display structure of the i_model table. Display all the information stored in the i_model table belonging to car group ‘A4'.

  Database system development

The database application project (DAP) for this course consists of the creation of a fully functional Microsoft Access database application for a real client.

  Create a database named ctsdb studentid

Create a text file named Create_ StudentID .sql (for example, Create_3087654.sql) that will contain SQL statements to: Create a database named CTSDB StudentID.

  Implementing a database management system

They have asked you to write a business case (search term business case template) to explain the justification for implementing a database management system to improve business intelligence within the company

  Discuss landmark contributions made in development of ehr

Discuss the landmark contributions made in the development of the EHR. Include pioneers and describe their efforts.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd