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
The ________ property adjusts the width of a column so that its cell contents fit in the column.
(Short Answer)
4.8/5
(28)
The keyboard shortcut to move one column to the left is ________.
(Multiple Choice)
4.9/5
(24)
________ data contains numbers and special characters such as the period (.)and hyphen (-).
(Short Answer)
4.8/5
(26)
To place the insertion point in the contents of a cell,you ________ the cell.
(Short Answer)
4.8/5
(28)
Which of the following is NOT an example of worksheet documentation?
(Multiple Choice)
4.9/5
(29)
A(n)________ is an equation that produces results such as numbers or text.
(Short Answer)
4.8/5
(31)
________ data contains a combination of letters,numbers,and special characters available on a keyboard.
(Short Answer)
4.8/5
(31)
By default,Excel places all information in a single line in a cell.
(True/False)
4.8/5
(35)
A ________ application is a computer program has a user interface comprised of a grid of rows and columns.
(Multiple Choice)
4.9/5
(37)
A contiguous cell range consists of multiple cells where at least one cell is not directly adjacent to other cells.
(True/False)
4.7/5
(24)
The dollar sign ($)and comma (,)are stored as part of a numeric cell value.
(True/False)
4.8/5
(36)
Match the following pointers to their use.
Correct Answer:
Premises:
Responses:
(Matching)
4.8/5
(33)
Match the following buttons to their action.
Correct Answer:
Premises:
Responses:
(Matching)
4.8/5
(31)
To move up one row,you would use the ________ + Enter keyboard shortcut.
(Short Answer)
4.9/5
(37)
When copying and pasting the contents of one cell into another,the destination cell has a dashed border.
(True/False)
4.8/5
(35)
A red triangle in the upper-right corner of a cell indicates the existence of a(n)________.
(Short Answer)
5.0/5
(37)
A cell reference is a combination of a row number followed by a column letter such as 12C.
(True/False)
4.9/5
(37)
Showing 81 - 100 of 106
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)