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
To select a column,click the letter in the header.
Free
(True/False)
5.0/5
(34)
Correct Answer:
True
To edit the contents of a cell,you right-click the cell to enter edit mode.
Free
(True/False)
4.8/5
(37)
Correct Answer:
False
A worksheet is a file containing at least one workbook.
Free
(True/False)
4.9/5
(35)
Correct Answer:
False
A comment is indicated by the presence of a ________ in the upper-right corner of a cell.
(Multiple Choice)
4.7/5
(32)
You can copy a worksheet within a workbook,by ________,and then dragging a copy of the worksheet to its new location.
(Multiple Choice)
4.7/5
(39)
If a numerical value is too narrow to be displayed in a cell,a series of ________ characters is displayed.
(Multiple Choice)
4.9/5
(35)
After selecting a row,pressing the shortcut key ________ will insert a new row above the selected row.
(Multiple Choice)
4.9/5
(30)
When using Excel,a spreadsheet is also referred to as a(n)________.
(Short Answer)
4.9/5
(37)
A(n)________ is a built-in program that performs a task such as finding the sum of a series of numbers.
(Short Answer)
4.9/5
(33)
To AutoFit the width of a column,you click Format and then click AutoFit Column Width in the ________.
(Multiple Choice)
4.9/5
(37)
Clicking a cell and then right-clicking in the formula bar displays the insertion point in the formula bar.
(True/False)
4.9/5
(31)
When pasting the contents of one cell into another,the cell receiving the contents is called the ________ cell.
(Short Answer)
4.7/5
(38)
To move right one screen,you would use the keyboard shortcut ________.
(Multiple Choice)
4.9/5
(44)
When there are multiple worksheets,you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right.
(Multiple Choice)
4.9/5
(39)
To insert a comment into a cell,you click New Comment in the ________.
(Multiple Choice)
4.8/5
(34)
Showing 1 - 20 of 106
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)