As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations
When you changed a value on which a chart is dependent, Excel immdetiately redraws the chart based on the Background dialog box
To make a slide background appear on all sides in a presentation, click the Format All button in the Format Background dialog box
To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab/Charts group)
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing
In PowerPoint 2010, you can embed and edit videos from within PowerPoint instead of needing to use a separate program
You can comfortably mix writing styles within a presentation as long as you are consistent with writing syles on each individual slide
Dates that include years both before and after the year 2000 should be formatted with a two-digit year
The modernist movement of the late nineteenth and twentieth centuries influenced the design principles in use today
Effective speakers do not waste time preparing their verbal message that will accompany each slide
You can move the _____ slider in the Format Background dialog box by pressing the RIGHT ARROW or LEFT ARROW to move the slider in one-percent increments
_____ _____ meanst that the width of a column will be increased or decreased so the widest entry will fitin the column
Once a(an) _____ _____ is inserted into a slide, you can specify options that control playback and appearance
_____ is a background feature that allows you to move the background from the slide borders in varying distances by percentages
You can learn more about Excel's functions with options in the Insert Function dialog box
The easiest way to select a cell is to move the block plus sign __________ to the cell and then click
The list of available fonts in the Fonts gallery may differ, depending on what fonts you have installed and the type of *printer you are using
The group of adjacent cells beginning with B4 and ending with B8, wrtitten as B4:B8, is called a(n) *range
When cell entries are short, *right -aligning the entries within their respective columns improves the apprearance of the worksheet
Researchers have known for decades that documents with visual elements are *less effective than those that consist of only text
You can quickly move between worksheet tabs by:
clicking a tab scrolling button, dragging the tab split box, clicking a sheet tab
Which of the following methods can you use to group selected slide objects?
Click the Group button(Drawing Tools Format tab/Arrange group), Press CTRL+G, Right -click selected objects and click Regroup
The recommended methodology for creating worsheets includes:
analyze requirements, design solution, validate design, document solution
Which of the following is true of a function?
Performs a calculation, Takes a value or values, Returns a result to the cell, Contains arguments
If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?
Monday, Saturday, Thursday
Which of the following shapes can be converted to a Circle or Square shape by pressing a key as you draw or insert the shape?
Which of the following are considered guidelines to use when making decisions about creating a new workbook?
Identify how to format various elements of the worksheet, Determine the necessary formulas and functions needed, Specify how the hard copy of the worksheet should appear
Which of the following design choices are appropriate for a presentation containing illustrations?
Use the color wheel to choose warm or cool colors, Vary text alignment, Evaluate your finished presentation
Spelling dialog box; change all occurrences of mispelled word with replacement word
Change All button
You can enter the correct range in a function by typing the beginning and ending cell references separated by a _____
The Picture Styles gallery is displayed by clicking the More button located on the ______
(Picture Tools Format tab/Picture Styles group)
You can click the Print tab in _____ view to preview your slides and set print options, as show in the accompanying figure
You can display the Background Styels gallery by clicking the Background Styles button on the_____
(Design tab/Background group)
The _____ button allows you to choose whether you want to copy the values from the source are to the destination area with formatting
Autot Fill Options
The _____ Option button lists formatting options following an insertion of cells, rows, or columns
The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry
Clicking the _____ opens the Insert Function dialog box
Functions & Formulas button on the status bar
You can change the shape of selected WordArt by clicking the _____ button in the WordArtStyles group on the Drawing Tools Format tab
You can insert a picture saved in a file into a slide by clicking the Insert Picture from File button on the _____
(Insert tab/ Images group)
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
The _____ area on the status bar displays common calculations, such as SUM, or AVERAGE, for selected numbers in the worksheet
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message