Category: Excel
-
SQL : TESTS : MySQL Database Engine
Sessions: Write a query that selects userId and average session duration for each user who has more than one session. TABLE sessions( id INTEGER PRIMARY KEY, userId INTEGER NOT NULL, duration DECIMAL NOT NULL); Write a query that selects userId and average session duration for each user who has more than one session. ——————————————————————————— SELECT userId, AVG(duration) as Average_Duration…
-
How to Edit Legend Text/ Name In Excel Chart?
1.To edit the name of legend text in chart first we need to click on the chart . Then click on the new tab chart design which will appear once your click on the chart in the ribbon area. Select Chart –> Chart Design 2. Then click on the select data on the top right…
-
How to calculate the discount rate in Excel with VLOOKUP? / Conditional discount calculation in Excel
We need to get discount rate for a particular OrderID according to order amount. Calculate the order amount with Discount Table number 2. As we know in excel we put ‘=’ sign to start formula. We are going to use VLOOKUP to find the discount rate. Click on C5 and write =VLOOKUP(Lookup_value, Table_array, Col_Index_num, Range_lookup)…
Tech School Solutions 