MYSQL [jsohn6]> SELECT • FROM COURSE; | COURSE_TYPE_CODE | | COURSE_TYPE | PROF_NUM | DEPARTMENT_ID | COURSE_TITLE | COURSE_DESCRIPTION 101 | Costume Designs 101 | Couture Fashion 101 | Costume Designs 101 | Textile Designs 201 | Fine Arts 103 | Computer Patterns 103 | Web Retail 103 | Web Design 202 | Design with Technolo | Intro to Computer Design Fundamentals of Costume Design | F | Fundamentals of Luxury Design | F | Fundamentals of Costume Design | F | Fundamentals of Textile Design | F Advanced Printmaking FASH-100 FASH-110 3 | FASH-120 FASH-150 7| 4 | FASH-210 TECH-100 Intro to Computer Patterns | Intro to Retail Ecommerce | Fundamentals of Graphic Design | T TECH-110 TECH-120 4 TECH-200 2 > rows in set (0.01 sec) MYSQL [jsohn6]> SELECT * FROM PROFESSOR; MYSQL [jsohn6]> SELECT * FROM TECHNOLOGY; | PROF_NUM | PROF_LASTNAME | PROF_FIRSTNAME | | COURSE_TYPE | LABTOP_NUMBER | 1 | Smith 2 | Banks з| Таylor 4 | Smith 6 | Smith 7 | Banks | Mary | Jane | Hazel | Terry | Jenny | Tim TECH-100 12345 67890 | 13579 | 24680 | TECH-110 TECH-120 | TECH-200 4 rows in set (0.00 sec) 6 rows in set (0.00 sec)

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 11EYW

See similar textbooks

Similar questions

struct DateTag{ int nMonth; int nDay; int nYear; }; struct NameTag{ char strFirst[ 31 ]; char strLast[ 21 ]; }; struct EmployeeTag{ int nId; struct NameTag sName; struct DateTag sBirth; }; struct DepartmentTag{ char strName[ 21 ]; char strDescription[ 51 ]; struct EmployeeTag sManager; struct EmployeeTag arrEmployees[ 15 ]; }; struct CompanyTag{ char strName[ 31 ]; struct DepartmentTag arrDepartments[ 10 ]; }; struct CompanyTag c1, c2; struct DepartmentTag d1, d2; struct EmployeeTag e1, e2; struct EmployeeTag *pEmp; 1. Which statement(s) is/are syntactically correct? a) e1 = d1.sManager; b) e1 = d1.arrEmployees; 2. Which statement(s) is/are syntactically correct? a) d1.arrEmployees[ 0 ] = pEmp; b) pEmp = d1.arrEmployees; 3. Which statement(s) is/are syntactically correct? a) c1.d1 = d2; b) c2.arrDepartments[1] = d2;
EXERCISE 1 R PROGRAMMING Use the dataset below for this assignment.1. diamonds Dataset (A dataset containing the prices and other attributes of almost 54,000 diamonds.)Use the given dataset (diamonds) to create the basic and interactive dashboard as shown in the image attached. Figure 1.0 is merely an example; you may apply and customize the interface outlook, as well as modify the code, as long as it fits the best criteria to show the diamonds dataset analysis. a. In your dashboard, you should display the following information:1. Display the dataset header and print the first 5 rows.2. Display a brief explanation of the diamonds dataset. Sample dataset: mobility_data.csv -> https://www.google.com/covid19/mobility/
JS-> // selecting required elementconst element = document.querySelector(".pagination ul");let totalPages = 10;let page = 2; //calling function with passing parameters and adding inside element which is ul tagelement.innerHTML = createPagination(totalPages, page);function createPagination(totalPages, page){ let liTag = ''; let active; let beforePage = page - 1; let afterPage = page + 1; if(page > 1){ //show the next button if the page value is greater than 1 liTag += <liclass=btn prevonclick=createPagination(totalPages, ${page - 1})><span><iclass=fas fa-angle-left><i>Prev<span><li>; } // how many pages or li show before the current li if (page == totalPages) { beforePage = beforePage - 2; } else if (page == totalPages - 1) { beforePage = beforePage - 1; } // how many pages or li show after the current li if (page == 1) { afterPage = afterPage + 2; } else if (page == 2) { afterPage = afterPage + 1; } for (var…
// Defines what category we're choosing and updates the webpage with this. // ********************************// 1. Customize these with your own category and items! // ********************************let what = "Video Game"; //CATEGORY - Change me!document.querySelector("#what").innerText = what; // Defines our options to choose from - change these Strings in the array to something you want to choose from!let options = [ "Dead Space", "Overwatch 2", "Fortnite", "World of warships", "Legends of Dragoon", "Sims 4","Stardew Valley"];const optionsList = document.querySelector("#options"); // ********************************// 2. Alphabetize the options list // ********************************// Your code here: // ********************************// 3. Make the options list use title case // ********************************// The first letter of each word should be capitalized. For 2 bonus points: Make it skip words like "and", "a", "the", "to", etc.// Your code here: // Don't code #3…
Create a simple contact us page using your own design (contact-page.php) for gettingcontact details of potential customers. Customer information needed are names, digital- address, email, telephone number and message. All fields must be validated using JavaScript only.4. Create a simple database with name nuksoftdb, create a table contactstb to store the contact details. Write appropriate php codes to connect to the database and insert records from the contact page into the database table.
To vary your reporting, you decided to include graphical representation. Create a clustered column chart that shows the total amount each active customer with a data plan must pay. Format the total pay column to currency and give the chart an appropriate title. Remember to label the axes. (Hint: Create a query and export it to a spreadsheet application to create the chart.) Ensure that the chart is labelled appropriately and is placed on a new sheet. Name the Spreadsheet as MGMT2006_G#_<first name last name>. For example, MGMT2006_G50_ Jane Doe.
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…
PHP According to table the in the image and code program 1 <?php include ('config.php'); $ matrixnum = $_POST['matrixnum']; $ subject_code = $_POST['subject_code ']; $ quiz = $_POST['quiz']; $ assignment = $_POST['assignment']; $ project = $_POST['project']; $ total_marks= $_POST['total_marks']; $ grade = $_POST['grade']; Code program 1 (Based on the program section (Code Program 1), assume that the data wants to be updated by the user. Build program code to provide instructions for updating the data to the assessments table. In addition, build a link to view the updated data.)
Sort results by reverse domain: Create a data category. Domain that depicts domain names, including a suitable compareTo() function where the natural order is in reverse domain name order. For example, cs.princeton.edu's mirror name is edu.princeton.cs. This is helpful for analysing site logs. Use s.split(".") to divide the string s into pieces separated by underscores. Create a client that takes normal input and displays the reverse domains in sorted order.
1. Create/ a sequence, GOV_SEQUENCE_xx, that begins with 100 and increments by 100 and uses all other defaults. Use your initials instead of the xx in the sequence name. 2. Select the next value of your sequence. 3.Use the next value of the sequence you created , GOV_SEQUENCE_xx as the value for the employee ID for every row inserted
What function does this Syntax perform? function myMap() {var map Canvas = document.getElementById("map");var mapOptions = {center: new google.maps.LatLng(51.5, -0.2),zoom: 10};var map = new google.maps.Map(mapCanvas, mapOptions);}
###Important variables below # gauteng ebp data as a listgauteng = ebp_df['Gauteng'].astype(float).to_list() # dates for twitter tweetsdates = twitter_df['Date'].to_list() # dictionary mapping official municipality twitter handles to the municipality namemun_dict = { '@CityofCTAlerts' : 'Cape Town', '@CityPowerJhb' : 'Johannesburg', '@eThekwiniM' : 'eThekwini' , '@EMMInfo' : 'Ekurhuleni', '@centlecutility' : 'Mangaung', '@NMBmunicipality' : 'Nelson Mandela Bay', '@CityTshwane' : 'Tshwane'} # dictionary of english stopwordsstop_words_dict = { 'stopwords':[ 'where', 'done', 'if', 'before', 'll', 'very', 'keep', 'something', 'nothing', 'thereupon', 'may', 'why', '’s', 'therefore', 'you', 'with', 'towards', 'make', 'really', 'few', 'former', 'during', 'mine', 'do', 'would', 'of', 'off', 'six', 'yourself', 'becoming', 'through', 'seeming', 'hence', 'us', 'anywhere', 'regarding', 'whole', 'down', 'seem', 'whereas', 'to', 'their',…