Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN: 9781337508841
Author: Carey
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
x = 0:1/100:1;1 ______________;2 ______________;3 ______________;4 ______________;title('Subplots')subplot(2,2,1), plot(x,y1,' 5 ___')xlabel('0 \leq x \leq 1'), ylabel('sin(3 \pi x)')6 _____________subplot(2,2,2), plot(x,y2,'7 ___')xlabel('0 \leq x \leq 1'), ylabel('cos(3 \pi x)')grid offsubplot(2,2,3), plot(x,y3,'8 ___')xlabel('0 \leq x \leq 1'), ylabel('sin(6 \pi x)')grid onsubplot(2,2,4), plot(x,y4,'9 ___')xlabel('0 \leq x \leq 1'), 10 ________________grid off
61. Which of the following statements is true of field sets?
Group of answer choices
a. Field sets can contain a maximum of two fields.
b. Field sets are created using the <area> tag.
c. Field sets act like control elements, which are also called widgets.
d. Field sets act like block elements that can expand to accommodate their content.
Please do not give solution in image format thanku
2. Examine the table shown below and answer the questions below: StaffNo branchNo branchAddress name position hoursPerWeek S4555 B002 City Center Plaza, Seattle, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 – 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 S4612 B002 City Center Plaza, Seattle, WA 98122 Dave Sinclair Assistant 14 S4612 B004 16 – 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 S5723 B005 23 Pitt Street, Sydney Donald Duck TeaBoy 25 i. Identify the primary key for the above relation. ii. Why is this table not normalised? What normal form is it in? i. Identify the functional dependencies for this relation. Is hoursperweek position one of them? Why, or why not? ii. Describe and illustrate the process of normalizing
Knowledge Booster
Similar questions
- 1- Display contact First name and contact Last name for customers after sorting the customersby their contact Last name in ascending order.2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table.Also, display the subtotal (quantityOrdered * priceEach) for each line item and sorts the resultset based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantity ordered(itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition “total”greater than 1000.8- Display product code, product…arrow_forwardTask 5: The marketing team wants to print out branded name tags for the properties with the StayWell logo and resident names. They require the first and last names of the residents combined and converted to uppercase for printing. You need to send them a single-column table with the column name of LABEL.arrow_forwardAcknowledge any single capital letter letters in order and a positive whole number between 1 to 10 from the client. Create the three-sided design out of it. The quantity of columns in the example ought to be equivalent to the number acknowledged from the client. Add suitable approvals, for example, the person is letters in order and capital letter. Likewise approve in the event that the number is a positive number between 1 to 10. For example Assuming that character entered is 'G', then result ought to be as per the following: G G G G G GG G G Greply?arrow_forward
- 1- Start 2- Input the documents KTP of the new vehicle owner and a photocopy The original and photocopy of BPKB Original and photocopy of STNK Receipt and Fotocopy with stamp and signed by seller and buyer Documents of the result of the physical vehicle if(checkdocument==correct) Display("Physical checks is okay") else Display("Please complete document first for physical check") End if Next step :- Register the transfer name Propmt - How will you pay amount for registration Input : ModeOfPayment=Pay mode If (ModeOfPayment==Mobile Banking) Display "Mobile banking option" else if(ModeOfPayment==bank transfer) Display "Account Details to the user else ("Choose any one option") end if Prompt: "Please fill registration form now" Prompt - "enter user name:" Input name Prompt "Please enter your complete address" Input address if(registerForm==completed) Validate form if(ValidateForm==okay) "Send document archive else "Please fill the correct form first" end if else Display…arrow_forward1- Start 2- Input the documents KTP of the new vehicle owner and a photocopy The original and photocopy of BPKB Original and photocopy of STNK Receipt and Fotocopy with stamp and signed by seller and buyer Documents of the result of the physical vehicle if(checkdocument==correct) Display("Physical checks is okay") else Display("Please complete document first for physical check") End if Next step :- Register the transfer name Propmt - How will you pay amount for registration Input : ModeOfPayment=Pay mode If (ModeOfPayment==Mobile Banking) Display "Mobile banking option" else if(ModeOfPayment==bank transfer) Display "Account Details to the user else ("Choose any one option") end if Prompt: "Please fill registration form now" Prompt - "enter user name:" Input name Prompt "Please enter your complete address" Input address if(registerForm==completed) Validate form if(ValidateForm==okay) "Send document archive…arrow_forwardq15- Which statements are correct about references in Excel? a. An absolute reference will not be changed when it is copied to another cell. b. Press F4 on an absolute reference will not change anything. c. To create an absolute reference, add a # sign before the row and column indexes. d. Press F4 on a relative reference will change it to an absolute reference.arrow_forward
- 1. Using the values on the Data worksheet, create a column chart. 2. Change the column chart so it uses the Year values in cells A3:A9 as the horizontal (category) axis values, and the Volume values in cells B3:B9 as the vertical axis values. 3. Using the same set of values, create a line chart. 4. Using the Quick Analysis Lens, create a pie chart from the same data..arrow_forwardNeed help with Excel spreadsheet. Using the table on the Enrollment worksheet, insert a PivotTable on a new worksheet named PivotAnalysis. Complete the following to create your PivotTable. • Add the Fee, Gender, and Class_Name fields to the PivotTable. • Ensure Class_name is in the Rows area. • Move Gender to the Columns area. • In cell B3, replace Column Labels with Gender. In cell B4, replace F with Female. In cell C4, replace M with Male. In cell A3, replace Sum of Fee with Revenue. In celln A4, replace Row Labels with Classes. • Format the Revenue field as Accounting with 0 decimal places. • Resize the column widths as needed. • Apply Light Orange, Pivot Style Light 10 to the PivotTable.arrow_forwardBook (Book_id, book_title, category, language, pages, price, sales, publisher_id)Publisher (publisher_id, publisher_name, city)Author (Author_id, fname, city)Author_book (Book_id, Author_id)1) Display the book title, pages and category of books written in French language.2) List the id of publishers who have published books in category science.3) Find the cities where there is an author but no publisher.4) List the book titles of books that have pages less than 5000 and price greater than 2000.5) Rename the Publisher table to P and columns publisher_id, publisher_name to pid and pname.arrow_forward
- can you help me with this assignment? *This is the last page (#3 page) INSERT INTO position VALUES (2, 'Manager'); INSERT INTO position VALUES (3, 'Programmer'); INSERT INTO position VALUES (4, 'Accountant'); INSERT INTO position VALUES (5, 'Salesman'); INSERT INTO emplevel VALUES (1, 1, 25000); INSERT INTO emplevel VALUES (2, 25001, 50000); INSERT INTO emplevel VALUES (3, 50001, 100000); INSERT INTO emplevel VALUES (4, 100001, 500000); INSERT INTO qualification VALUES (1, 'Doctorate'); INSERT INTO qualification VALUES (2, 'Masters'); INSERT INTO qualification VALUES (3, 'Bachelors'); INSERT INTO qualification VALUES (4, 'Associates'); INSERT INTO qualification VALUES (5, 'High School'); INSERT INTO dept VALUES (10, 'Finance', 'Charlotte', 123); INSERT INTO dept VALUES (20, 'InfoSys', 'New York', 543); INSERT INTO dept VALUES (30, 'Sales', 'Woodbridge', 135); INSERT INTO dept VALUES (40, 'Marketing', 'Los Angeles', 246); INSERT INTO employee VALUES (111, 'Smith', 'John', 1, NULL,…arrow_forward3. When you click on ………… the Format Cells - Alignment dialog box will appear in which we can control the border properties of the cell. 4. ………….. is considered one of the important things in the Office files, as it includes information such as page numbers and addresses. 5. The group commands……… define the shape and color of tables and cells by means of a set of properties. 6. ........ Through it, the row height and column width are determined manually or automatically according to the data it contains.arrow_forwardUse the HOL Small Company ERD and HOL Small Company Details xlsx to completethe steps listed below.It is important to name the tables and columns exactly as they are shown in theERD/xlsx.Failure to do so will cause future assignment to fail.*//*()Comments1. At the beginning of your script, make single-line comments for yourname, the name of the assignment, and the date.2. At the beginning of your script, make a multi-line comment thatdescribes the issues you had with this assignment.*//* ()Creating TablesAfter the 5 DROP TABLE statements, complete the 5 CREATE TABLE statementsbelow to create the tables listed below.Make sure you choose the appropriate data types.Include NOT NULL and UNIQUE constraints.DO NOT include key constraints (i.e., primary keys, foreign keys) in yourstatements.The table names are:() HOL_CUSTOMERS(6) HOL_BOOKS(6) HOL_BOOK_CATEGORY(6) HOL_ORDERS(6) HOL_ORDER_ITEMS */DROP TABLE HOL_ORDER_ITEMS;DROP TABLE HOL_ORDERS;DROP TABLE HOL_CUSTOMERS;DROP TABLE…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScriptComputer ScienceISBN:9781305503922Author:Patrick M. CareyPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning