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
When using ________ orientation,the horizontal dimension of the paper is longer.
(Short Answer)
4.7/5
(36)
You can move a worksheet within a workbook,by clicking and holding on the worksheet tab and dragging the worksheet to its new location.
(True/False)
4.9/5
(34)
The base date for date and time data in Excel 2013 is ________.
(Multiple Choice)
4.8/5
(32)
When using a what-if analysis,you change values in spreadsheet cells to see the effects on calculated values of interest.
(True/False)
4.8/5
(31)
Match the following buttons to their action.
Correct Answer:
Premises:
Responses:
(Matching)
4.9/5
(38)
You can rename a worksheet by ________ its tab and then typing the new name.
(Multiple Choice)
4.7/5
(38)
Which of the following is typically NOT contained in a separate documentation worksheet?
(Multiple Choice)
4.7/5
(25)
When collecting data in a spreadsheet,each row contains a record.
(True/False)
4.9/5
(32)
The normal page margins are 0.5 inches top,bottom,left,and right.
(True/False)
4.8/5
(35)
Adobe System's PDF reader application CANNOT be used to edit a document that was saved with the pdf extension.
(True/False)
4.9/5
(40)
To change the width of a column,you click Column Width in the ________.
(Multiple Choice)
4.9/5
(38)
To make a different worksheet active,you click Change Worksheet in the Selection group on the HOME tab.
(True/False)
4.7/5
(40)
When copying and pasting the contents of one cell into another,the source cell has a(n)________ border.
(Short Answer)
4.7/5
(36)
The extension for Microsoft Excel 2013 workbooks is ________.
(Multiple Choice)
4.7/5
(32)
When using a touch screen,the Excel 2013 commands on the Ribbon and in shortcut menus are rearranged to accommodate the use of a fingertip.
(True/False)
4.7/5
(35)
You can select a contiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse.
(Short Answer)
4.7/5
(34)
Showing 21 - 40 of 106
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)