Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a resulta. IFb. ANDc. ORd. NOTMacros are “run” or executed from the ….. menu.a. Insertb. Frmatc. Toolsd. DataYou can open the consolidate dialog box byt choosing Consolidate from the ….. menu.a. Insertb. Formatc. Toolsd. DataEach excel file is called a workbook becausea. It can … [Read more...]

Charts tips cana. Show the formatting of a data labelb. Show the name of a data seriesc. Show the value of data pointd. b and cThe Name boxa. Shows the location of the previously active cellb. Appears t the left of the formula barc. Appears below the status bard. Appears below the menu barHow do you change column width to fit the contents?a. Single-click the boundary to the … [Read more...]

What term refers to a specific set of values saved with the workbook?a. Rangeb. Scenarioc. Trend lined. What-if analysisGot functions? No? You need the insert function dialog box. How do you get it?a. Right click a cell and then click insertb. Click the insert menu and then click functionc. Type = in a celld. All of the aboveWhich of the following describes how to select all … [Read more...]

To edit data in an embedded Excel worksheet object in a Word documenta. Use the Excel menu bar and toolbars inside the word applicationb. Edit the hyperlinkc. Edit the data in a Excel source applicationd. Use the Word menu bar and toolbarsStatus indicators are located on thea. Vertical scroll barb. Horizontal scroll barc. Formula bard. Formatting toolbarYou can open the … [Read more...]