Exam 1: Navigate, manipulate, and Print Worksheets
Exam 2: Formatting, functions, and Formulas100 Questions
Exam 3: Cell References, named Ranges, and Functions102 Questions
Exam 4: Effective Charts98 Questions
Exam 5: Complex Conditional and Retrieval Functions100 Questions
Exam 6: Analyze Data Using Tables100 Questions
Exam 7: Multiple Worksheets workbooks and Templates100 Questions
Exam 8: Refine an Excel Application100 Questions
Exam 9: Organize, import, export, and Cleanse Data Sets100 Questions
Exam 10: Data Tables, scenario Manager, and Solver101 Questions
Exam 11: Loan Amortization, investment Analysis, and Asset Depreciation100 Questions
Exam 12: Business Statistics and Regression Analysis103 Questions
Exam 13: Excels Data Model, Power-pivot, and Power View96 Questions
Exam 14: Visual Basic for Applications99 Questions
Exam 15: Appendix:efficient Interaction With a Touch Screen67 Questions
Exam 16: The Common Features of Microsoft Office81 Questions
Select questions type
In Page Layout,an inserted page break is indicated by a(n)________ line.
(Short Answer)
4.8/5
(40)
________ shows you what your document will look like when it is printed.
(Short Answer)
4.8/5
(30)
The ________ view is used to show page margins,print headers and footers,and page breaks.
(Short Answer)
4.9/5
(39)
The default time interval for automatically saving Excel files is every five minutes.
(True/False)
4.8/5
(30)
Dragging and dropping is an effective method for moving the contents of a cell or a range of cells to others cells.
(True/False)
4.9/5
(35)
The active worksheet has a white tab with bold letters and a thick bottom border.
(True/False)
4.9/5
(28)
The keyboard shortcut to move one column to the right is ________.
(Short Answer)
4.8/5
(35)
If you mistakenly delete a worksheet,you can recover it by pressing Undo.
(True/False)
4.9/5
(41)
A(n)________ cell range consists of cells directly adjacent to one another.
(Short Answer)
4.8/5
(30)
The keyboard shortcut to display the Save As dialog box is ________.
(Multiple Choice)
4.9/5
(33)
The keyboard shortcut for inserting today's date is ________.
(Multiple Choice)
4.7/5
(24)
To print headings on multiple pages,you click Print Titles in the ________.
(Multiple Choice)
4.8/5
(37)
When cutting and pasting the contents of a cell,everything in the cell,including formatting,is moved.
(True/False)
4.8/5
(42)
You can use ________ to manually adjust the location of page breaks.
(Short Answer)
4.7/5
(32)
You can use ________ to copy information from one cell,or a series of contiguous cells,into contiguous cells by dragging its handle in the desired direction.
(Short Answer)
4.7/5
(47)
In Page Layout,default page breaks are indicated by dashed blue lines.
(True/False)
4.9/5
(35)
Information such as the modification history of a workbook would be found in a separate documentation worksheet.
(True/False)
4.9/5
(41)
Showing 41 - 60 of 106
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)