. Maybe you will be wondering: Can Excel also make slides? It's a bit difficult to have Excel make slides alone, but with the help of Crystal Tables (Xcelsius 2008), making interactive slides is a breeze. Xiaobian recommended "Microsoft Office 2015" 1. Make a thumbnail photo presentation We will make a slideshow using the thumbnail image menu to switch images (Figure 1). The interactive behavior in Xcelsius 2008 is done by widgets. After opening Xcelsius 2008, drag the sub-components of the desired category in the "Parts" window and drag directly to the right canvas. In this example, the author selects the “Fisheye Picture Menu” in the “Selector” category, and the “Image Parts” in the “Pictures and Backgrounds” category. (Drag 6 times) and rename the part in the “Object Browser” window. (Figure 2) To make an animation, interaction, and appearance of a component, you need to set its properties. Right click on the widget and select the "Properties" menu. Step1: Set the “fisheye picture menu” to the widget properties. In its "General" property, enter the desired title at the "Title" (of course, if you need to select the corresponding cell content in Excel), click on the rightmost button in the "Label" tab. To modify the display content of the label, select "Embedded" in the "Image" area and click the "Import" button to select the corresponding image (the selected image should be consistent with the label display), in "Data Insertion". Insert type selection "Location", the target selects A1 in Sheet1 (the purpose is to store the order index value of the selected thumbnail, if the second thumbnail is selected, the value at A1 is 2). In the "Behavior" property" "Common" tab, set the entry to “Browse 1”, in the "Animation & Effects" tab, check “Enable Sound”. Of course, you can also set the size of the thumbnail and the title, label display, etc. in the "look and feel" properties. Step2: Set the "Image" component properties. Select the first image component, tick ““ adjust the image size according to the widget” in its “General” property, then import the desired image and use the mouse to drag to change the image size. In the dynamic behavior of the "behavior" attribute"""""" state" state" is A1 in Sheet1, the code is 1, and the animation when entering can be set in "Animation & Effects" effect. Similarly, select other image components and import the desired image, except that the dynamic visibility code of each component is different. For example, the code of the second image component is 2, which corresponds to the index value of the fisheye menu. Select all of the six image parts, and use the sub-menu such as Alignment and Same Size in the “Format” menu to adjust the position and size. In order to make the slides more beautiful, you can use the background and other components to decorate the slides. All objects are locked in the "Object Browser" window, hiding the parts that are not required to be displayed at the beginning of the screen. (Figure 3) Finally, use the “file →export” menu to export the slideshow as a separate SWF file, or export it to other files such as PPT. 2. Create an automatic scoring multiple choice question. Below we create a cross-tabulation of test questions with 3 radios. The total score will be calculated and displayed automatically during the selection process. (Figure 4) First design the question bank form. In this example, three questions are placed in an Excel table. Among them, the formula at E2 score is “=IF(C2=D2,1,0)” (meaning that if the correct answer and the answer are the same, give 1 point, otherwise give 0 point), the formula at E5 is “=SUM(E2:E4)”. Use the A6 cell as the index value for the selection list box item. (Figure 5) After opening Xcelsius 2008, use the “Import Spreadsheet” button on the toolbar to import the table into the window. Next set the component properties. For the same reason, drag a required list box, 5 labels, and 3 radio buttons into the canvas, and set their properties separately. Step1: “ list box & rdquo; set of component properties. Enter the desired title at the "General" Properties" title" attribute, select A2:A4 cells in Sheet1 at “label", insert type selection “data insertion” ; position & rdquo;, the target is the A6 cell. In the "behavior" attribute"Common" tab, set the selected item to “Label 1”, and enable the sound in the "Animation and Effects" tab. Of course, you can also set the font, color, and other formats of the widget in the "Appearance" property. (Figure 6) Step2: & ldquo; label & rdquo; set of component properties. Select the first label component, select its cell link as B2 in its "General" property, and set the dynamic visibility state to A6 cell in the "Behavior" property of the "Common" The code is 1; the cell link of the 2nd tag is B3, the dynamic visibility state is A6 cell, the code is 2; the cell link of the 3rd tag is B4, the dynamic visibility state is A6 cell, code 3; the cell of the 4th tag is linked to D5; the cell of the 5th tag is E5, which is used to display the total score. These tags can be beautified with the "Appearance" attribute. Step3: <; radio button & rdquo; set of component properties. Select the 1st radio button and modify its tag name to A, B, C, D in its "General" properties, insert type selection “tag” at “data insertion> For the D2 cell. Set the dynamic visibility status to A6 cells in the "behavior"action"property" "common" tab, with the code 1; enable sound in the "Animation and Effects" tab. Similarly, the second and third radio buttons are also set up, except that the target of the second radio button data insertion is D3 cell, the code of dynamic visibility is 2; the third radio button data insertion point The target is D4 cells, and the code for dynamic visibility is 3. After the attribute settings of these components are completed, the three tabs of the displayed title are selected, and the three radio buttons are selected, and the position and size are adjusted by using the sub-menu such as the alignment and the same size in the “Format” menu. . Finally, use the “file →export” menu to generate a SWF file. This article comes from [System Home] www.xp85.com