It adds data from cell D18 of Sheet1 and cell D18 of Sheet4 It adds data from cell A1 of[...]
Category: LinkedIn Microsoft Excel Assessment Answers
Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?
Value Formatting Cell Style Formatting Conditional Formatting Tabular format[...]
Which format setting does not change the background appearance of a cell?Which format setting does not change the background appearance of a cell?
Fill color Font Color Pattern Style Cell Style[...]
Which of these functions returns the largest value within the range H2:H30?Which of these functions returns the largest value within the range H2:H30?
=MAXIMUM (H2:H30) =MAX(H2:H30) =LARGE (H2:H30, 29) =UPPER(H2:H30,1)[...]
For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?
OR(B3=>15,B3<=20) AND (B3>=15,B3<=20) OR(B3>15,B3<20) AND(B3>15, B3<20)[...]
Of these four chart types, which works best for summarizing time-based data?Of these four chart types, which works best for summarizing time-based data?
pie chart XY scatter chart bar chart line chart[...]
You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?
A [...]
Which format setting does not change the background appearance of a cell?Which format setting does not change the background appearance of a cell?
Cell style Fill color Pattern style Font color[...]