ComTech Final

Created by darlenetorres 

Upgrade to
remove ads

100 terms

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)

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

NEW! Voice Recording

Click the mic to start.

Create Set