✅ How do you create a heatmap in a table, such as this one, which is responsive to the values? ✅ How would you search an entire workbook with Find & Select? ✅ Which value is calculated when the formula =AVERAGE(G2:G6)/AVERAGE(C2:C6) is entered into cell H7? ✅ To create this PivotTable, drag the _ field to the Rows area and the _ field to the Values area? ✅ What happens if you use the AutoSum button in cell H4? ✅ Which formula contains a valid absolute reference? ✅ How would you connect the slicer to both PivotTables? ✅ What is the difference between a workbook and a worksheet? ✅ How do you remove everything (values, formatting, etc.) from a cell? ✅ What is the result of the formula =4&3? ✅ You want to group your slides based on their content to better organize your presentation. ✅ How do you remove the background of an inserted image? ✅ Before publishing a document, you want to identify issues that may make it difficult for people with disabilities to read. ✅ Columns D, E, and F are hidden in your worksheet. ✅ How can you use Format Painter to apply the format of a single source cell to several nonadjacent destination cells? ✅ This data needs to be sorted by Group, then by Last Name, then by First Name. What is the fastest way to copy that formula into cells D3:D501 (the bottom of the data set)? ✅ To ensure the VLOOKUP function returns the value of an exact match, what do you need to enter into the Range_lookup field? ✅ How can you drill down into a PivotTable to show details? It is important to reduce a long list of body weights to a smaller set of weight categories. Another continuous variable is in the Sum Values field. ✅ In this PivotTable, the continuous variable weight is shown in the Row field. ![]() ✅ What is the intersection of a worksheet row and column? ![]() ![]() ✅ What is the difference between pressing the delete key and using the clear command in the Home tab’s Editing group? What is the most likely reason that #N/A is returned in cell C6 instead of mallory’s ID (2H54) ✅ In the worksheet shown below, cell C6 contains the formula=VLOOKUP(A6,$F$2:$G$10,2,FALSE). ✅ From which field list was the pivotTalble created? ✅ If a worksheet has the value 27 in cell B3, what value is returned by the function =MOD(B3,6)? ✅ Monthly revenues of 2019 are entered in B2:M2, as shown below, To get year-to-date running total revenues, what formula should you enter in B3 and autofill through M3? ✅ Which Excel feature allows you to hide rows or columns with an easily visible expand/collapse? How can you pivot this table to show the column fields as subtotals of each value in the row field? ✅ The PivotTable below has one row field and two column fields. ✅ Which formula, when entered into cell D2 and then dragged to cell D6, calculates the average total number of minutes spent on phone calls for each representative? ✅ Which function returns the number of characters in a text string in cell A1? ✅ How can you create the lower table from the top one when the tables are not linked? ✅ Which value is returned when you enter =LEN(C3) into cell F3? ✅ Which formula calculates the total value of a single row of cells across a range of columns? ✅ Which VLOOKUP function, when entered into cell L2 and then dragged to cell L5, returns the average number of calls for the representative IDs listed in column J? ✅ Which function, when entered into cell F2 and then dragged to cell F6, returns the performance rating text (e.g., “Good”, “Poor”) for each representative? ✅ Which function, when entered into cell G7, allows you to determine the sum total of annual sles for market regions 18 and greater? ✅ Which chart type can display two different data series as different series type within the same chart? ✅ Which function returns the largest value in the range H2:H30? ✅ To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use? ✅ You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. ✅ An organization chart, which shows the hierarchy within a compmay or oraginization, is available as _ that is include with Excel. ✅ To ensure shapres and other objects are an equal left-to-right distance apart, select the shapes, click Page Layout > Align, and the click _. ![]() ✅ The text filter in column A is designed to display only those rows where column A entry has a particular attribute. ✅ The AutoSum formulas in the range C9:F9 below return unexpected values. ✅ Of the four chart types listed, which works best for summarizing time-based data? What tool should you use to solve the problem? Yet the columns are too narrow to display all the text in each cell. ✅ You’re working with columsn whose width and font-size should not be changed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |