DIT 2020-2021 FINAL EXAM STUDY GUIDE: POWERPOINT, EXCEL, and InDESIGN

How do you open a blank presentation in PowerPoint? ______

1. Select the File tab to go to Backstage view. 2.Select New on the left side of the window, then click Blank Presentation. 3.A new presentation will appear- go to file

In Excel, which of the following formulas will find the average value between the range of B7 and P7?

=AVERAGE(B7:P7)

In Excel, which is a valid syntax for the COUNT function?

=COUNT(A1:C38)

In Excel, which of the following is a valid TODAY formula to calculate the number of years you have lived if you were born in 1975? ______

=YEAR(TODAY())-1975

Define: Master Page

A Master Page is a nonprinting page that you can use as the template for the rest of the pages in your document_

In PowerPoint or Excel, how does the dialog box launcher tool appear?

A dialog box launcher is a small icon that appears in a group

In order to display all formulas in your worksheet in Excel, what do you do

Click the SHow formulas command button on the formulas tab

Which chart in Excel is useful forcomparing values across categories or a time period?

Column Charts

In order to cut data in PowerPoint or in Excel, which keyboard shortcut do you use?

Control _+X____

What can you do to keep the top row headers of a worksheet visible while you scroll down the worksheet in Excel? ________

Enable the worksheet you need to keep column header viewing, and click View > Freeze Panes > Freeze Top Row. If you want to unfreeze the column headers, just click View > Freeze Panes > Unfreeze Panes. ________________________________________

Define Facing Pages

Every InDesign spread includes its own pasteboard, which is an area outside a page where you can store objects that aren't yet positioned on a page.___

In Excel, which calculation would be performed first in this formula?(((3+1)*((2+2)-2)*(1*1)))* (4+5)

Everything in the parenthesis

In Excel, if you want to calculate how much interest you will pay on your mortgage, which function icon would you click in the Formulas tab?

Financial hjh

In Excel, which option on the Conditional Formatting menu provides access to the Conditional Formatting Rules Manager dialog box? ____

Manage Rules

What Presentation View provides the ability to build a presentation skeleton?

Outline

In PowerPoint, from which tab can you turn on the Ruler, Gridlines, and Guides?

Pick the View tab and then move to the Show group, where you'll see checkboxes for Ruler, Gridlines, and Guides.

What is a way to condense and rearrange large amounts of data in Excel quickly?

PivotTable

In Excel, what are the keystrokes for utilizing the Find command?

Press Ctrl+F, and then type your search words

How do you change the orientation of row or column data in Excel? __

Select a cell, row, column, or a range. Select Home > Orientation. , and then select an option. You can rotate your text up, down, clockwise, or counterclockwise, or align text vertically

What is the sequence of steps in PowerPoint to convert lists to a SmartArt? _

Select the slide with the list you want to convert to SmartArt. Select the list text box. Click the Convert to SmartArt Graphic button on the Home tab. Select a SmartArt style. Resize and position the graphic as needed.-

From where can you expand the character spacing of text in PowerPoint? _

Select the text that you want to change. On the Home tab, click the Font Dialog Box Launcher, and then click the Advanced tab. In the Spacing box, click Expanded or Condensed, and then specify how much space you want in the By box.

In Excel, what functions do not use arguments? __

TODAY, and DATE______

Define: Trim

This is the final dimension of the document, after it has been printed and then cut down to size

In Excel, what is the term for the values that a function uses to perform operations or calculations?

_AVERAGE function.__

In Excel, which function counts the number of cells within a range that meet the criteria?

_COUNTIF___

In order to undo the last action in PowerPoint or in Excel, which keyboard shortcut do you use?

_Control+Z_

Define: Slug_

_In InDesign however, the slug refers to an area outside of the boundaries of the document page that can be used for any number of things including job information, notes, and agency logos just to name a few.

Which is the default paragraph alignment in PowerPoint?

_Left Alignment

What controls the position of the objects and text on a single slide in PowerPoint?

_Slide Layout

Define: Cropping the Image

_To crop frame content precisely, select the frame with the Direct Selection tool, and use the Transform or Control panel to change the size of the frame

What can you do after clicking on the title placeholder in PowerPoint?

_YOU CAN CUSTOMIZE THE PROMPT TEXT

The Conditional Formatting menu is located in which group on the Home tab in Excel?

__ Styles group______________

Define: Bleed

__A Bleed is the area just extending past the edge of the page, past the trim edge

Define: Resampling

__Changing the pixel dimensions of an image is called resampling.__

In Excel, a shared workbook on a network allows multiple users to do what?

__Click the Review tab. Click Share Workbook in the Changes group. On the Editing tab, click to select the Allow changes by more than one user at the same time. In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it.

Which tab in Excel is selected to build a chart?

__From the Insert tab, click the desired Chart command. In our example, we'll select Column. Choose the desired chart type from the drop-down menu. The Selected chart will be inserted into the worksheet.- CHARTS AND TABS

What type of chart should be used for analyzing trends in Excel?

__Line chart______________________________

In Excel, which function adds the cells in a range specified by a given criteria?

__SUMIFS function.

In InDesign, these two graphics are known as what?

__VECTOR GRAPHICS__

In Excel, which function quickly adds a contiguous range of cells?

___AUTOSUM_________________________

In InDesign, what is the vertical spacing between lines of text?

___Leading is measured from the baseline of one line of text to the baseline of the line above it.

Define: Gutter

___The gutters in a page layout separate elements from one another

In Excel, what defines a condition and can be a number, text, or expression?

____if function____

In Excel, in which group can you find the Paste Special command on the Home tab?

__clipboard___

Excel provides the tools to create which type of documents

__workbooks______________________________

In Excel, what separates a function containing multiple arguments

_comma_______________________________

In Excel, which of the following is a predefined formula that performs a calculation?

_function_____________

In Excel, you can reposition a chart on a worksheet after clicking on the chart and seeing what?

a four-headed black arrow

_charts_

are visual representations of numerical data so that one can easily compare values or trends.

In Excel, where is the Fill handle located

bottom right cell of the selected cells

In Excel, any formula that includes cells whose values change should include what

cell reference

In Excel, what command lets you add or change chart elements?

charts layouts ad styles

In Excel, which number format displays the default currency symbol with two decimal places?

currency

What option helps when presenting a long list of items?

decrease text box height_

In Excel, an absolute cell reference requires which symbol?

dollar sign

In Excel, when you insert a cell in a column, you force the other cells in the same column to move

down

In Excel, all formulas must start with what character(s)?

equal sign =

Excel templates are files that include present formatting and formulas

formatting and formulas

In Excel, the commands on each ribbon tab are organized into logical command

groups

In Excel, on the _________________________________ tab in the Font menu in the Font group, select the desired font to change the selected cells.

home _

In Excel, what is an absolute cell reference?

is one that does not change when it's moved, copied or filled

In Excel, what is meant by naming a range of cells?

it makes it easier to refer back to the data in excel

What is the best option to use for procedural steps, action items, and other ordered information?

numbered list

In Excel, when you insert a cell in a row, you force the other cells in the same row to the

right

In PowerPoint, a/an ________________ is a grid that consists of cells and is created through the intersection of rows and columns.

rows and colomns

In PowerPoint, where can you locate the gallery of default layouts?

slides layout