✅ 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 |