Computer Skills Questions
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