CIS 101

If you copy the formula =C4*$D$9 from C4 to C5, what will the formula be in cell C5? Your anwser should include the equal sign and use all uppercase letters. Leave no spaces between. ___________

=C5*$D$9

5.3 Write an if function that adds 5 to cell B2 if A2 is equal to USA, if A2 is not equal to USA, add 0 to cell B2. Include an equal sign, use uppercase letters and do not include spaces. ____________________________

=IF(A2="USA",5,0)

To add a shape to a PowerPoint presentation, click on the __________ tab on the Ribbon. See Ribbon below.

insert

In PowerPoint, a photo's color intensity can be modified by changing the brightness and _______________ .

contrast

To write an Excel Formula , always start with the _____________ sign. Write the name of the sign. Do not use the symbol

equal

In Microsoft Word, the the top of the document with the tabs and commands is called the _____________

ribbon

To resize a shape in PowerPoint, you can select the shape, and press and hold down the ___________ key and then drag the lower right corner sizing handle. See illustration below.

shift

As you type paragraphs, press ENTER to move from one paragraph to another. True False

true

If you use both Outlook Web App and Outlook , you need to create a signature in both. True False

true

When using Outlook email signature feature, to send an email with a prepared signature you always have to return to the Compose and Reply page and click the check box to include your signature. True False

False

In the formula below, which reference will update when copies? =$D$3 + $E5 Column D Column E Row 3 Row 5

Row 5

When using citation, if the author's last name is mentioned in the text, then it does not need to be included in parentheses. True False

True

When using the Command Prompt, you can type commands using capital letters, lowercase or any combinations of them. The commands CD, cd, Cd, all work the same way. True False

True

Supose the formula =D7+F8/G8-H5+2 is in cell D10. Which is the best method to work out the value required in F8 to get a value of 850 from the formula? Use Goal Seek to set F8 to 850 by changing D10 Use Goal Seek to set D10 to 850 by changing F8 Use the Scenario Manager to place 850 in D10 Use the Input Table to place 850 in D10

Use Goal Seek to set D10 to 850 by changing F8

Refer to the portion of the spreadsheet shown below, what is the absolute address of the cell indicated by the red arrow. Use UPPER CASE Letters. ___________

$B$2

The default file extension of a 2016 Excel Workbook is .__________ ( do not add a dot)

.xlsx

The octal number system uses the digits from ___________ to ________

0 & 7

What is the binary notation equivalent for the decimal number 30? Express the answer as a byte.

00011110

What is the value of the least significant bit in the decimal number 267?

1

What is the decimal equivalent of the binary 10101010?

170

The Hexadecimal equivalent the the Decimal number 9 is ____________

9

5.3 Company A is looking into four potential projects and will accept them if the IRR (Internal Rate of Return) is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below? _______________

=IF(B2>=$E$2,"Accept","Reject")

Which of the following content can you insert in a header or footer region of a document? A table An image Document Name All of the above

All of the above

If you've created a signature, but didn't choose to automatically add it to all outgoing messages, you cannot add it later when you write an email message. True False

False

You change or remove a theme by making a selection from the gallery on the __________ tab in PowerPoint

Design

In the illustration below, which language has a faster processing time. ________________Write Low level or High level

Low level

The _____________ function ( name the function ), if placed in cell C12 will return the lowest value from the cell range C4:C11. Use UPPER CASE letters for the function name.

MIN

_____________ View is the main editing view, which is used to write and design a presentation. The view has three working areas: on the left, tabs that alternate between an outline of slide text (Outline Tab) and slides displayed as thumbnails (Slides Tab); on the right, the slide pane, which displays a large view of the current slide; and on the bottom, the notes pane.

Normal

Which of the following is required to add different headers or footers to different parts of a document? Page breaks at the end of each page Section breaks, Next Page Alignment tabs All of the above

Section breaks, Next Page

In Microsoft PowerPoint, slide ___________ are motion effects that occur in Slide Show view when you move from one slide to the next during a presentation.

Transitions

You place the insertion point in the middle of a paragraph and start typing. But the new text deletes existing text. What's the problem and how do you fix it? a. Word is in Overtype mode. Press BACKSPACE and retype. b. The DELETE key is pressed in. Press DELETE again. c. Word is in Overtype mode. Press INSERT to turn it off d. Press ENTER and continue

c. Word is in Overtype mode. Press INSERT to turn it off