How can we help?

You can also find more resources in our Help Center.

100 terms

ComTech Final

STUDY
PLAY
The NETWORKDAYS function checks a formula for crrectness
false
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations
false
A rectangle object is used to insert text in a slide area where there is not text placeholder
false
Clips and photograpshs you see on Web pages are not covered by copyright law
false
When you changed a value on which a chart is dependent, Excel immdetiately redraws the chart based on the Background dialog box
true
To make a slide background appear on all sides in a presentation, click the Format All button in the Format Background dialog box
false
A theme's text color contrasts with it's background color
true
To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab/Charts group)
true
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing
true
In PowerPoint 2010, you can embed and edit videos from within PowerPoint instead of needing to use a separate program
true
The arithmetic operator, ^ , directs Excel to perfor the division operation
false
Contrast determines the overall lightness or darkness of an entire image
false
You can comfortably mix writing styles within a presentation as long as you are consistent with writing syles on each individual slide
false
You can apply artistice effects to a picture ised as a slide's background
false
Dates that include years both before and after the year 2000 should be formatted with a two-digit year
false
The modernist movement of the late nineteenth and twentieth centuries influenced the design principles in use today
true
The AutoCorrect feature can automatically captialize the first letter in the names of dates
true
Effective speakers do not waste time preparing their verbal message that will accompany each slide
flase
When a digital camera does not measure a picture's tone correctly, a color cast occures
true
To clear the entire worksheet, click the Clear All button on the worksheet
false
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
transperancy
The default font for a new workbook is _____ 11- point regular black
Calibri
_____ _____ meanst that the width of a column will be increased or decreased so the widest entry will fitin the column
best fit
Once a(an) _____ _____ is inserted into a slide, you can specify options that control playback and appearance
audio clip
_____ is a background feature that allows you to move the background from the slide borders in varying distances by percentages
offsets
As soon as you finish your presentation, you should critique you _____
performance
To select a placeholder for deletion, click its _____ to change it to a solid line
performance
You can create your own _____ _____ for use with the fill handle
custom lists
You can learn more about Excel's functions with options in the Insert Function dialog box
Insert Function
The easiest way to select a cell is to move the block plus sign __________ to the cell and then click
mouse pointer
Panes created using the verical split bar scroll together *horizontally
true
The *SEND TO BACK command moves a selected object underneath all stacked objects
true
You can press the *CTRL+ACCENT MARK(') to display the formulas in a worksheet
true
The opposite of merging cells is *splitting a merged cell
true
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
true
You can replace a formula with its *function so it remains constant
false, result
The Accounting number format assigns a *floating dollar sign
false, fixed
The group of adjacent cells beginning with B4 and ending with B8, wrtitten as B4:B8, is called a(n) *range
true
Statistical functions ignore *blank cells
true
In designing a worksheet, * visual aesthetics should come first
false, functional considerations
When cell entries are short, *right -aligning the entries within their respective columns improves the apprearance of the worksheet
false, centering
The *theme layouts determine where the text and content placeholders display on the slide
true
In a worksheet,, * columns typically contain information that is similar to a list
false, rows
Researchers have known for decades that documents with visual elements are *less effective than those that consist of only text
false, more
The values that you use with a function are called *arguments
true
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
The Chart Tools contextual tabs include the ___, ___, ___ tabs.
Design, Format, Layout
Which of the following are formatting symbols?
Dollar sign ($), Pound sign (#), Percent sign (%)
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?
Oval, Rectangle
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
Select non-sequential slides
CTRL
Spelling dialog box; change all occurrences of mispelled word with replacement word
Change All button
Spelling dialog box; word is spelled correctly but not found in dictionaries
Ignore Button
Right-align text
CTRL+R
Regroup selected objects
CTRL+G
Open the Replace dialog box
CTRL+H
Select sequential slides
SHIFT
Display the Research task pane
SHIFT+F7
Open the Spelling dialog box
F7
Ungroup selected objects
SHIFT+CTRL+G
Brightness and Contrast
changed in predefined percentages
Open the Font dialog box
CTRL+SHIFT+F
Turn off the Format Painter
ESC
Copy all formatting changes from one object to another
Format Painter
Multiple text selections
CTRL
Contains 24 pictures that give appearance of a physical object
Textures Gallery
More control over the exact look of an image
picture effect
A color scheme
six accent colors
Live preview
view formatting changes before you apply them
Graphic design independent of language
modernist movement
You can enter the correct range in a function by typing the beginning and ending cell references separated by a _____
colon (;)
PowerPoint's _____ feature allows you to set the timing for a video clip
Trim Video
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
Backstage
Which of the following is the path to the Comma Style button?
(Home tab/Number group)
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
_____ changes picture color into black, whitem and shades of gray
Grayscale
The _____ button is located on the Quick Access Toolbar
Undo
The _____ Option button lists formatting options following an insertion of cells, rows, or columns
Insert
Words underlined with a red wavy line are possibly____
misspelled
The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry
AutoCorrect
Excel remembers the last _____ actions you have completed
100
When you decrease the row height to _____, the row is hidden
0
Clicking the _____ opens the Insert Function dialog box
Functions & Formulas button on the status bar
The path to the text alignment button is _____
(Home tab/ Paragraph group)
Which of the following keys is an alternative to double-clicking the cell to edit it?
F2
You can change the shape of selected WordArt by clicking the _____ button in the WordArtStyles group on the Drawing Tools Format tab
Text Effects
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
Which of the following is the path to the Goal Seek button?
(Data tab/Data Tools group)
The _____ area on the status bar displays common calculations, such as SUM, or AVERAGE, for selected numbers in the worksheet
AutoCalculate
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
#REF!
An Excel _____ allows data easily to be summarized and charted
worksheet
Which of the following is the path to the Shape Fill button?
(Drawing Tools Format tab/ Shape Styles group)