PLS Answer this as soon as possible
Q1. How is the TOTAL calculated for each student?
By adding C2:C5
By adding D2: D5
By multiplying C2: D5
By multiplying C2 and D2
picture given
Q2. A pictorial representation of data is called as ______
Smart art
Chart
Plot area
Workbook
Q3. Amar was asked by his teacher to create a suitable chart for the SALES ANALYSIS table for 4 years for each salesman. Which chart will he opt for?. Hint: Observe the given table carefully for reference
Scatter chart
SmartART chart
Sparkline chart
Doughnut chart
Q4. Renuka wants to purchase a house which costs Rs 40,00,00 and planning for a bank loan of Rs.20,00,000. But she was unsure about the monthly payment for 3 years if the interest rate of the bank is 8%. What do you think the best function which will solve her confusion?
Goal seek()
PMT()
SQRT()
SUMIF()
Q5. Rehan was helping his brother to create an excel sheet where he was creating a table for his half-yearly marks. Rehan thought of applying orange colour in cells where his brother scored less than 35 marks and green in cells where he scored above 45. Which excel feature do you think Rehan would have used for this?
SUMIF()
Sorting
Auto filter
Conditional Formatting
Q6. Keerthi has created a pie chart for the population of metropolitan cities in India for her Geography assignments. Now she wants to change the background colour of its plot area according to her choice. Guide her from the following options.
Click on chart--> chart elements
Click on chart -->chart design
Click on chart-->chart styles
Right click on plot area and select FORMAT PLOT AREA
Q7. The following EXCEL sheet shows 2 related tables. The RESULT column in the second table is generated using which function?
PMT()
SUM()
TOTAL()
SUMIF()
Answers
Answer:
fydtrftttft86
Explanation:
PLS Answer this as soon as possible
Q1. How is the TOTAL calculated for each student?
By adding C2:C5
By adding D2: D5
By multiplying C2: D5
By multiplying C2 and D2
picture given
Q2. A pictorial representation of data is called as ______
Smart art
Chart
Plot area
Workbook
Q3. Amar was asked by his teacher to create a suitable chart for the SALES ANALYSIS table for 4 years for each salesman. Which chart will he opt for?. Hint: Observe the given table carefully for reference
Scatter chart
SmartART chart
Sparkline chart
Doughnut chart
Q4. Renuka wants to purchase a house which costs Rs 40,00,00 and planning for a bank loan of Rs.20,00,000. But she was unsure about the monthly payment for 3 years if the interest rate of the bank is 8%. What do you think the best function which will solve her confusion?
Goal seek()
PMT()
SQRT()
SUMIF()
Q5. Rehan was helping his brother to create an excel sheet where he was creating a table for his half-yearly marks. Rehan thought of applying orange colour in cells where his brother scored less than 35 marks and green in cells where he scored above 45. Which excel feature do you think Rehan would have used for this?
SUMIF()
Sorting
Auto filter
Conditional Formatting
Q6. Keerthi has created a pie chart for the population of metropolitan cities in India for her Geography assignments. Now she wants to change the background colour of its plot area according to her choice. Guide her from the following options.
Click on chart--> chart elements
Click on chart -->chart design
Click on chart-->chart styles
Right click on plot area and select FORMAT PLOT AREA
Q7. The following EXCEL sheet shows 2 related tables. The RESULT column in the second table is generated using which function?
PMT()
SUM()
TOTAL()
SUMIF()