Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Solve the question on excel in the picture given below.T hey are just one question... XH S = Charles.xlsx - Excel (Product Activation Failed) ?
Solve the question on excel in the picture given below.T
hey are just one question...
XH S = Charles.xlsx - Excel (Product Activation Failed) ? ? 6 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER Sign in AutoSum4 Calibri 11 7 Wrap Text General * Cut ED Copy Format Painter > E A H Insert Delete Format Fill- Paste BIU A Merge & Center - $ % +8.00 Conditional Format as Cell Formatting Table Styles Styles Clear Z Sort & Find & Filter - Select - Editing Clipboard Font Alignment Number [5 Cells M12 : v A F L P CA 1 A 2 B 3 C 4 D 5 E B D E G H I J K M N 0 Make a sequence of numbers from 1 to 20 Generate one-week dates for May. Date format "May 5, 2022" Notebook Make a list of items from the K2:K7 table Pen Generate a quantity from 2 to 15 with "pcs" Sleeves Generate price from 1.00 to 1.80 with cents. Formula:=rand()(b-a)+a, where a - lowest interval number, b-largest. Apply function Round(). Notepad Apply a discount to all items if the quantity purchased is more than 10 Pencils Give a mark-up to the price of all goods at a discount. Define the name to Mark-up value cell. Markers Calculate price with VAT. Define the name to VAT value cell. Count the data below the table Make columnar chart showing the products in horizontal axes, discounted price of the items and the price with the mark-up price. Show values, legend and columns color red and green. Format tables without expanding the columns. Apply conditional formatting to item quantities from 5 to 10 6 F 7 G 8 H 9 10 11 12 13 14 15 Discount Mark-up 5% VAT 25% 16 21% 17 18 Price of all goods Quantity Cost per unit Discounted pric Price with marl Price including VAT 19 No. Date Products 20 21 22 task task2 task3 + READY 6 + 100% 1 Type here to search O E 99+ SE x] 530F lla ) 9:52 AM 5/13/2022 XH S = Charles.xlsx - Excel (Product Activation Failed) ? ? 6 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER Sign in - 11 Calibri AutoSum4 7 Wrap Text General * Cut E Copy Format Painter > E A TI H Insert Delete Format Fill- Paste BI U - - A Merge & Center - $ % +8.00 Conditional Format as Cell Formatting Table Styles Styles Clear Z Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells M12 : A B D E F G H I J K L M N N 0 P CA 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Sum Average Middle value Largest 5th value Number of items benefiting from the discount Average discounted price of items if quantity >12 Average discounted price for items with quantity 1.3 Price of goods with mark-up quantity up to 10 pcs and price E A H Insert Delete Format Fill- Paste BIU A Merge & Center - $ % +8.00 Conditional Format as Cell Formatting Table Styles Styles Clear Z Sort & Find & Filter - Select - Editing Clipboard Font Alignment Number [5 Cells M12 : v A F L P CA 1 A 2 B 3 C 4 D 5 E B D E G H I J K M N 0 Make a sequence of numbers from 1 to 20 Generate one-week dates for May. Date format "May 5, 2022" Notebook Make a list of items from the K2:K7 table Pen Generate a quantity from 2 to 15 with "pcs" Sleeves Generate price from 1.00 to 1.80 with cents. Formula:=rand()(b-a)+a, where a - lowest interval number, b-largest. Apply function Round(). Notepad Apply a discount to all items if the quantity purchased is more than 10 Pencils Give a mark-up to the price of all goods at a discount. Define the name to Mark-up value cell. Markers Calculate price with VAT. Define the name to VAT value cell. Count the data below the table Make columnar chart showing the products in horizontal axes, discounted price of the items and the price with the mark-up price. Show values, legend and columns color red and green. Format tables without expanding the columns. Apply conditional formatting to item quantities from 5 to 10 6 F 7 G 8 H 9 10 11 12 13 14 15 Discount Mark-up 5% VAT 25% 16 21% 17 18 Price of all goods Quantity Cost per unit Discounted pric Price with marl Price including VAT 19 No. Date Products 20 21 22 task task2 task3 + READY 6 + 100% 1 Type here to search O E 99+ SE x] 530F lla ) 9:52 AM 5/13/2022 XH S = Charles.xlsx - Excel (Product Activation Failed) ? ? 6 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER Sign in - 11 Calibri AutoSum4 7 Wrap Text General * Cut E Copy Format Painter > E A TI H Insert Delete Format Fill- Paste BI U - - A Merge & Center - $ % +8.00 Conditional Format as Cell Formatting Table Styles Styles Clear Z Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells M12 : A B D E F G H I J K L M N N 0 P CA 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Sum Average Middle value Largest 5th value Number of items benefiting from the discount Average discounted price of items if quantity >12 Average discounted price for items with quantity 1.3 Price of goods with mark-up quantity up to 10 pcs and priceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started