PLEASE HELP I FAILED TWICE AND HAVE ONLY ONE MORE TRY BEFORE MY GRADE ARE SET I AM CRYINGGGGG PLEASEEE IM BEGGINGGGGG
1.What is an effective way to display calculations in a Word document?
A. Insert a chart as a picture.
B. Add a Word object.
C. Add an Excel object.
D. Create a table.
2. When you use the Copy and Paste commands, you are accessing
A. a data source.
B. the Office Clipboard.
C. a compound document.
D. an application-specific object.
3. If you want to include a long explanation about data in an Excel worksheet, what type of object can you use in the sheet?
A. Spreadsheet
B. Chart
C. Text Box
D. Word
Circular errors are caused by adding the cell name of _______ cell to its own formula.
A. the active
B. an absolute
C. a relative
D. the adjacent
5. The most efficient way to perform data entry is to keep your hands on the keyboard and press _______ to move to the next cell in the row or press _______ to move to the next cell in the column.
A. Enter; Tab
B. Tab; Home
C. Tab; Enter
D. Home; Tab
6. An inserted graphic in Excel is
A. inserted in the active cell.
B. a freely moving object.
C. inserted in cell A1.
D. a nonmovable object.
7. When the Clipboard dialog box launcher is clicked, the Clipboard displays in _______ view.
A. task pane
B. shortcut menu
C. dialog box
D. window
8. The _______ has shortcuts to commonly used commands.
A. File tab
B. ScreenTip
C. Status bar
D. Quick Access toolbar
9. To copy text in a Word document to an Excel spreadsheet, you should first format the text as a Word table or as text separated by
A. line breaks.
B. spaces.
C. tabs.
D. paragraphs.
10. When long labels are required, which of these commands can you use to improve readability of a worksheet?
A. Wrap Text
B. Sort & Filter
C. Merge & Center
D. Conditional Formatting
11. Most editing commands in Word, such as cut, copy, and paste, can be found on which tab?
A. Home
B. Insert
C. Design
D. File
12. Which is the correct formula to add the values in cells A1 and B1?
A. A1+B1
B. SUM(A1+B1)
C. =SUMA1+B1
D. =SUM(A1+B1)
13. When you see ##### in a cell, you should
A. decrease the cell height.
B. decrease the cell width.
C. increase the cell height.
D. increase the cell width.
14. Which key removes all data from an active cell with one click?
A. Delete
B. Esc
C. F2
D. Tab
15. Which of the following statements is true of a new Word object in an Excel spreadsheet?
A. It's limited to a specific size.
B. It's not bound to a cell range.
C. It's limited to a small number of formatting options.
D. It's not draggable on the spreadsheet.
16. Which of these charts has only one data series?
A. Line
B. Pie
C. Bar
D. Area
17. Which function should be used to display a value based on a comparison?
A. IF
B. COUNT
C. MIN
D. AVERAGE
18. The _______ button automatically displays next to the data when you select a range of numeric data, which is an available option for creating a chart.
A. Chart Elements
B. Quick Analysis
C. Chart Styles
D. Recommended Charts
19. You must start with what mathematical operator to create a formula?
A. =
B. +
C. -
D. *
20.When you right-click a word with a red squiggly line under it, which of the following displays?
A. Smart Lookup dialog box
B. Spelling menu
C. Grammar menu
D. Replace dialog box