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
