Computer Apps Exam
83. There are ______ major types of tab
5
If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?
=AVERAGE(A1:A5), =(A1+A2+A3+A4+A5)/5, =average(a1:a5), =(a1+a2+a3+a4+a5)/5
20. Get the remarks in cell A1 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be "PASSED" or else "FAILED".
=IF(A1>74,"PASSED","FAILED")
19. Get the remarks in cell E10 that valued 75 which noted, if the remarks will be higher than 74, the remarks will be "PASSED" or else "FAILED".
=IF(E10>74,"PASSED","FAILED")
18. If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?
=SUM(A1:A5), =A1+A2+A3+A4+A5, =sum(a1:a5), =a1+a2+a3+a4+a5
1. Desktop publishing is the process of preparing commercial-quality printed a. True b. False
A
10. A SmartArt graphic contains placeholder text that you replace with your own a. True b. False
A
10. Portrait orientation is the default page orientation for Word documents. a. True b. False
A
11. Is it possible to insert an image from a file into an Excel spreadsheet ? A. Yes B. No
A
12. Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ? A. Yes B. No
A
13. On an Excel sheet the active cell is indicated by ____. A. A dark wide border B. A dotted border C. A blinking border D. None of the above
A
14. A Formula and a function are the same thing. A. True B. False
A
3. A table is a useful way to present information that is organized into categories, or a. True b. False
A
3. As you type the body of a letter, Word automatically moves the insertion point to a new line when the current line is full. a. True b. False
A
3. One of the most useful features of a word-processing program is the ability to move text a. True b. False
A
4. True or False. If you choose a larger font size, the height of the row is automatically made taller. A. True B. False
A
5. You can copy selected text by pressing Ctrl + C. a. True b. False
A
6. Once you crop a graphic, the part you cropped is hidden from a. True b. False
A
6. The PAGE LAYOUT tab displays options for adjusting the margins of your document. a. True b. False
A
6. You can enter data in a table by moving the insertion point to a cell and a. True b. False
A
7. How do you know a range is active? A. It is highlighted on the screen. B. It has a marquee around it. C. The data changes to Bold to let me know it's active D. I'm psychic & I just Know!!
A
7. Heading 1 is the highest level used for the major headings in a document and applies the most noticeable formatting. a. True b. False
A
8. True or False. A range has an address called an range address. A. True B. False
A
9. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ? A. Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet B. Right click on the spreadsheet tab and select DELETE C. Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
A
9. An example of a range address. A. A1:B3 B. A1;B3 C. A1-B3 D. A1=B3 E. A1*B3
A
9. The active cell: A. Is defined by a bold border around the cell B. Receives the data user enters C. It is the formula bar D. Receives data user enters & defined by a bold border around the cell
A
Labels are aligned at the ________ edge of the cell. A. Left B. Right C. Top D. Bottom
A
There are three worksheets with every new workbook. You can change that automatic number if you want to. A. True B. False
A
2. You can complete a cell entry by pressing A. Enter B. Tab C. Shift+tab D. An arrow key E. Another cell
All of them
1. The first cell in EXCEL worksheet is labeled as A. AA B. A1 C. Aa D. A0
B
10. A __________ is a grid with labeled columns and rows. A. Dialog box B. Worksheet C. Clipboard D. Toolbar
B
2. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10) A. The status bar does not display the cell address. B. An absolute cell address is created. C. Cell address will change when it is copied to another cell. D. The sheet tab is changed.
B
2. A numbered list is a group of related paragraphs with a black circle or other character to the left of each paragraph. a. True b. False
B
2. If a document is already divided into sections, by default, the column format is applied only to the section that currently contains the insertion point. a. True b. False
B
2. Paragraphs formatted with Heading 1 style are considered the lowest level headings and appear aligned at the left margin of the Navigation pane. a. True b. False
B
3. The default font keyed in a new work book is. A. 12 pt. Times New Romans B. 10 pt. Arial C. 12 pt. Bradley Hand ITC D. 10 pt. Times New Roman
B
4. The grammar checker marks grammatical errors with a wavy red line. a. True b. False
B
5. By default, Word documents include .5-inch margins on all sides of the document. a. True b. False
B
6. To add a new row, click a cell in the row immediately above where you want the new row. A. True B. False
B
7. What is represented by the small, black square in the lower-right corner of an active cell or range? A. Copy handle B. Fill handle C. Insert handle D. Border
B
7. Which key do you press to group two or more nonadjacent worksheets? A. CTRL. B. SHIFT C. ALT
B
8. To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs. A. True B. False
B
8. A tab stop is a location on the vertical ruler where the insertion point moves when you press the Tab key. a. True b. False
B
How do you change column width to fit the contents? A. Single-click the boundary to the left of the column heading. B. Double-click the boundary to the right of the column heading. C. Press ALT and single-click anywhere in the column.
B
###### means: A. You've entered a number wrong. B. You've misspelled something. C. The cell is not wide enough.
C
10. When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________. A. Cell selector B. Cell cross C. Selection pointer D. Range selector
C
10. Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ? A. Count B. Average C. Sum
C
15. In order to multiply items in Excel you would use: A. ^ B. @ C. * D. #
C
16. The formula = ((A2+B5)*5% is valid A. True B. False
C
5. Which button allows you to copy cell formats from one cell to another? A. Enter B. Autofit C. Format painter
C
8. In Excel, a Data Series is defined as what? A. A type of chart B. A cell reference C. A collection of related data D. A division of results
C
A fast way to add up this column of numbers is to click in the cell below the numbers and then: A. Click Subtotals on the Data menu. B. View the sum in the formula bar. C. Click the AutoSum button on the Standard toolbar, then press ENTER.
C
Say that you want to paste a formula result — but not the underlying formula — to another cell.You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next? A. Click the Paste button on the Standard toolbar. B. Click the arrow on the Paste button on the Standard toolbar, then click Formulas. C. Click the arrow on the Paste button on the Standard toolbar, then click Values.
C
83. To verify that the pointer is located at the beginning of the document, press the keys.
CTRL+HOME
77. You press ______ to paste the most recent copied
CTRL+V
3. What are the tabs that appear at the bottom of each workbook called? A. Reference tabs B. Position tabs C. Location tabs D. Sheet tabs
D
4. In Excel, the Fill Color button on the Formatting toolbar is used for what? A. To insert a background. B. To add borders. C. To select a distribution of figures. D. To add shading or color to a cell range.
D
5. In help menu of Excel, which of the following tabs are found? A. Contents tab B. Answer Wizard tab C. Index tab D. All of the above
D
6. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? A. Logical B. Math & Trigonometry C. Statistical D. Financial
D
6. A_______ is a group of cells that form a retangle on the screen. A. Label B. Workbook C. Worksheet D. Column E. Range
E
84. The ____ guidelines were designed to ensure consistency in documents so that all papers look alike.
MLA
74. To ______ a row, click in the selection bar to the left of the row.
add
85. When you ____ a paragraph, you move the entire paragraph to the right.
align right
78. The ____ feature capitalizes the first letter of a sentence automatically.
autocorrect
85. A paragraph ______ is an outline that appears around one or more paragraphs in a document.
border
73. The area where a row and column intersect is called a(n) _______
cell
80. To change the width of a selected column, drag or ____ the right column border.
click
81. If you cut off one or more of a graphic's edges, you have ______ the graphic.
cropped
73. _____ is the process of preparing commercial-quality printed material using personal computer.
desktop publishing
84. A(n) ______, or row of dots between tabbed text, makes it easier to read a long list tabbed material.
dot leader
75. A(n) ____ is a large letter that begins the text of a paragraph.
drop cap
83. The ____ gallery is divided into Theme Colors and Standard Colors.
font color
74. A(n) ____ button allows you to click once to format the selected text, and click again to remove the formatting from the selected text.
format painter
86. You will use the ______ button in the Clipboard group on the HOME tab to copy a format from selected text to other text.
format painter
78. The term ____ can refer to objects used for illustration purposes or to enhance page layout.
graphic object
81. On the ______ ruler the 0-inch mark is like the origin on a number line.
horizontal
78. The text you type in the Find what text box is known as the ____
navigation pane
73. If you insert a new paragraph, delete a paragraph, or reorder the paragraphs in a ______ list, Word adjusts the list making sure it remains consecutive.
numbered
82. By default, the ______ theme is applied in each new
office
81. As you drag the mouse pointer across a blank grid to insert a table, a(n) ____ of the table structure will appear in the document.
outline
79. Line spacing determines the amount of space between lines within a(n) _____.
page
74. A(n) ____ frames the contents of a single page.
page border
79. You can add or delete rows and columns by using the buttons in the ______ group on Mini toolbar, for example.
paragraph
76. To ______ means to place a copy of whatever is on the Clipboard into the document.
paste
82. ____ orientation is the default orientation for Word
portrait
74. To undo the last thing you did in a document, click the Undo button on the _____
quick access toolbar
81. By default, the ___ gallery offers 16 styles, each designed for a specific
quick styles
15. A text box is considered a(n) _______ shape.
rectangle
84. With ____ alignment the text is aligned along the right margin and is ragged along the margin.
right
87. To work with a photo or other type of picture in a document, you first need to ____ it.
save
78. To sort a column in reverse order, click the ____ option button.
sort
77. The term ____ refers to the process of rearranging information in alphabetical, numerical, chronological order.
sorting
76. ________ automatically corrects common typing errors.
spell check
76. To insert special characters in Word, choose the Special Characters tab from the ____ dialog box.
symbol
80. _______ in the white space to the left of the document text to select an entire document.
triple click
16. Word inserts page number fields below the bottom margin, in the area known as the footer, or above the top margin. True or False?
true
75. If you insert a table with the wrong number of rows or columns, click the ______ button on Quick Access Toolbar to remove the table.
undo
75. The ____ allows you to change the way the document is
view button
75. To move text with ____, select the text you want to move, press and hold down the mouse button, drag the text to a new location, and then release the mouse button.
word
77. The Ctrl+Right Arrow keystroke moves the insertion point right one ______ at a time.
word
