Question

4 multiple choice 2 points which type of bar graph is commonly used for simple comparisons in excel? 3 - d bar line chart stacked bar clustered bar 5 multiple choice 2 points if you wanted to find the largest value in cells d1 to d10, what formula would you use? = max(d1) = min(d1) = if(d1) = sum(d1) 6 multiple choice 2 points what happens when you press the tab key after entering data in a cell? it moves to the cell to the right it moves to the cell to the left it moves to the cell above it moves to the cell below

Explanation:

• Question 4: Clustered Bar graphs in Excel are used for simple comparisons as they place bars for different categories side - by - side, making it easy to compare values across categories.
• Question 5: The =MAX() function in Excel is used to find the largest value in a range of cells. Here, if we want to find the largest value from D1 to D10, we should use a function that can take a range. =MAX(D1) only considers cell D1. But among the given options, if we assume a typo (should be =MAX(D1:D10)), and comparing with other functions: =MIN() finds the smallest value, =IF() is a conditional function, and =SUM() sums the values.
• Question 6: By default, when you press the Tab key after entering data in a cell in Excel, it moves to the cell to the right.

Answer:

• Question 4: Clustered Bar
• Question 5: =MAX(D1) (assuming a range - related typo in the option, as the correct formula for D1 - D10 is =MAX(D1:D10), but among the given options, =MAX is the function for maximum value)
• Question 6: It moves to the cell to the right