All Categories
Computer Skills
Explore questions in the Computer Skills category that you can ask Spark.E!
- PROJECT 3: On the "instructional hours" worksheet, modify the chart to display "hours" as the primary vertical axis title.
- PROJECT 2: On the "summary" worksheet, from the existing text in cell A2, insert a hyperlink to "http://www.nodpublishers.com" with a screentip that displays "company website"
- PROJECT 2: Remove hidden properties and personal information from the workbook. Do not remove any other content.
- PROJECT 4: On the "inventory" chart sheet, insert a chart title above the chart, at the top of the plot area. Display the percentage values as data labels to the right of each data bar.
- PROJECT 3: On the "instructional hours" worksheet, adjust the width of the colums B:G to exactly 12.
- PROJECT 2: On the "authors" worksheet, in the "bonus" column, use a function to display "500" if the "books sold" is greater than 10,000. Otherwise, display "100".
- PROJECT 4: On the "orders" worksheet, filter the table data to display only the orders from "alpine ski house".
- PROJECT 3: On the "classes" worksheet, convert the table to a cell range. Keep the formatting
- On the "projections" worksheet, in the "Quarter 2" column, enter a formula that multiplies the value in the "quarter 1" column by the "Q2_Increase" named range. Use the range name in the formula instead of a cell reference or value.
- PROJECT 1: On the "New Policies" worksheet, add a total row to the table. Configure the total row to display the number of new policies for each month and for the 6-month total
- PROJECT 4: On the "prices" worksheet, in the "tax" column, enter a formula that multiplies the value in the "unit price" column by cell L2.
- PROJECT 5: On the "last semester" worksheet, configure A3:F3 to automatically wrap the text.
- PROJECT 4: On the "prices" worksheet, apply the title style to cell A1.
- PROJECT 1: On the "contact" worksheet, in the "email address" column, use a function to construct email addresses for each person using the first name and @humongousinsurance.com
- PROJECT 1: On the "new policies" worksheet, change the elements displayed on the chart by changing the chart layout to layout 3.
- PROJECT 1: On the "New Policies" worksheet, in the "Inactive Months" column, use a function to count the number of months with no new policies, by agent.
- PROJECT 1: on the "New Policies" worksheet, change the horizontal alignment of the "Agent" names to Left (Indent). Set the indent to 1.
- Alternate between displaying cell values and displaying formulas in the worksheet
- What is the appearance of the Shape Adjustment handle?
- Displays the quick analysis options for your data when you have cells that contain that data selected