COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN: 9780357392676
Author: FREUND, Steven
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
1. Apply ID Codes in the ID Code column (Insert random ID code that is accepted by the validation rule), except in column A5, A10 and A11.
Inputs in the following cells:
A5 – TYC89123
A10 – Z90865
A11 – BD1209
Q1 The book Id number is represented in the following pattern: 0-07-041183-2. The first part(0)
represents a region, the second part(07) is a publisher, the third part(041183) is a book subject, and
the fourth part(2) is a book code. The book code is calculated as below:
dig = (1 x first digit) + (2 x second digit) + (3 x third digit) +
+(9 x ninth digit)
Book code is remainder when the dig is divided by 7. Write a python program that reads Book Id
as a number and checks whether it represents correct or valid Book Id.
Sample input and output -
Input: 0070411835
Output: Valid
Input: 1234567893
Output: Invalid
1. Apply a data validation for the ID Code Column that will only accept entry of 2 letters followed by 5 digits (e.g. ab12345).
Knowledge Booster
Similar questions
- Microsoft Excel Formula assignment: The objective of this assignment is to create 20 [5x5] tables and each 5 by 5 table will have mix of numbers from 1 to 100. (NOTE: There can't be ANY duplicate numbers in the 25 cells). The numbers placed in the 5x5 table cannot match with any other table AND again, each table cannot repeat the same number. I need to create this without having to manually type numbers and create the 5 by 5 tables.What is the fastest way to create these tables using formulas? This assignment demonstates the examples for formulas on excel. Here is two examples for 2 tables.TABLE 1:1 2 3 4 56 7 8 9 1011 12 13 14 1516 17 18 19 2021 22 23 24 25TABLE 2:59 2 3 4 133 72 8 9 6611 22 13 88 1516 17 18 19 529 40 99 30 21Here is an example that will NOT work.1 2 66 4 216 7 8 7 910 11 12 39 4182 88 88 88 29100 33 35 32 51arrow_forward1- 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_forwardPlease give me correct solution with explanation. The DATE option of the COLUMN command does not allow a specific format to be applied to date values. True Falsearrow_forward
- Create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, state, and zip code for each customer. Each customer’s name should be listed in order of last name followed by first name, separated with a comma, and have the column header “Name.” The city and state should be listed as one column of output, with the values separated by a comma and the column header “Location.”arrow_forwardTask 3: The InstantRide Finance team wants to know the average discount amounts for each car in the InstantRide. Calculate the average discount amount as monetary value for the travels where a discount is applied. You need to create a subquery over the TRAVELS table to retrieve CAR_ID and DISCOUNT_AMOUNT, calculated with 2 decimals using the ROUND function. To calculate the DISCOUNT_AMOUNT , multiply the TRAVEL PRICE by the TRAVEL_DISCOUNT where the TRAVEL_DISCOUNT value is not NULL. Round the result to 2 decimals. Then you can use this subquery to get the CAR_ID and AVG of DISCOUNT_AMOUNT values, once again using the ROUND function on the average results. Group the results by the CAR_ID. Use CAR ID and DISCOUNT_AMOUNT as column aliases and return it back to the Finance team.arrow_forwardWrite the missing jQuery code so that clicking the hide button will hide the text and clicking show button will show the text. This text is important! Click the button to make it bold if needed! hide showarrow_forward
- Some rows of the STUGRADE table of a school are shown below: STU_CODE CLS_CODE GRADE YEAR 291 111 3.1 2010 938 101B 2.3 2011 931 M101 3.3 2040 291 M101 3.4 2018 190 111 2.0 2021 931 321 3.9 2003 You want to show all STU_CODE with average grades higher than 3.0. Which of the following gets the required data? a. SELECT STU_CODE, AVG(GRADE) FROM STUGRADE WHERE AVG(GRADE) > 3.0 GROUP BY STU_CODE b. SELECT STU_CODE, AVG(GRADE) FROM STUGRADE WHERE GRADE > 3.0 GROUP BY STU_CODE c. SELECT STU_CODE, AVG(GRADE) FROM STUGRADE GROUP BY STU_CODE HAVING AVG(GRADE) > 3.0 d. SELECT STU_CODE, AVG(GRADE) FROM STUGRADE WHERE AVG(GRADE) > 3.0 AND STU_CODE GROUP BY STU_CODEarrow_forwardWhich result set requires a JOIN? a.) Showing all album titles with artist IDs b.) Showing all album titles with artists' names c.) Showing all artist names with artist IDs d.) Showing all album titles with both artist ID and album IDarrow_forwardSELECT COUNT(INV_NUMBER) AS 'Total Invoices', SUM(TOTAL_PRICE) AS 'Total Sales', MIN(TOTAL_PRICE) AS 'Minimum Customer Purchases', MAX(TOTAL_PRICE) AS 'Largest Customer Purchases', ROUND(AVG(TOTAL_PRICE), 2) AS 'Average Customer Purchases'FROM (SELECT CUS_CODE, LINE.INV_NUMBER AS INV_NUMBER, ROUND(SUM(LINE.LINE_PRICE * LINE.LINE_UNITS), 2) AS TOTAL_PRICEFROM INVOICE, LINE WHERE INVOICE.INV_NUMBER = LINE.INV_NUMBER GROUP BY CUS_CODE, LINE.INV_NUMBERORDER BY CUS_CODE, LINE.INV_NUMBER)INVOICELINE; i use this code but it didn't show the same value as in the questionarrow_forward
- Write a jQuery code to format a phone number as following examples below when you enter them to an online input field. You need also to add a paragraph about the purpose of this code. (xxx) xxx-xxxx xxx-xxx-xxxxarrow_forwardD Question 11 Perform the indicated operations. Do not type subscripts in your answers and do not include redundant zeros in front of a number. 1112+10112= A8F16+7.BC16= 110002-100112= 1012x112=arrow_forwardMySQL Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter). Place these values in the variables I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME, respectively. Output the contents of I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAMEarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning