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
Which of the following data types is NOT automatically right-aligned by Excel?
(Multiple Choice)
4.8/5
(32)
When you insert a new worksheet,it is inserted to the right of the active worksheet.
(True/False)
4.9/5
(31)
You can select a noncontiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse.
(Multiple Choice)
4.8/5
(35)
Match the following keyboard shortcuts to the movement of the active cell.
Correct Answer:
Premises:
Responses:
(Matching)
4.8/5
(37)
The AutoFill property adjusts the height of a row so that its cell contents fit in the row.
(True/False)
4.8/5
(42)
A formula is a built-in program that would be used to find the average of a series of numbers.
(True/False)
4.8/5
(43)
After selecting a column,pressing the shortcut key ________ will insert a new column.
(Short Answer)
4.8/5
(42)
When collecting data in a spreadsheet,each ________ is a field in a record.
(Short Answer)
4.9/5
(38)
When printing a workbook,the default print range is Print Active Sheets.
(True/False)
4.9/5
(41)
Documentation such as the author and modification history are contained a separate documentation ________.
(Short Answer)
4.9/5
(41)
To move up one screen,you use the Ctrl + Page Up keyboard shortcut.
(True/False)
4.7/5
(34)
Match the following terms to their definition.
Correct Answer:
Premises:
Responses:
(Matching)
4.9/5
(29)
The white spaces at the edges of a printed page are called ________.
(Short Answer)
4.8/5
(30)
To insert a line break or hard return in a cell,you would press ________.
(Multiple Choice)
4.8/5
(38)
Showing 61 - 80 of 106
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)