Exam 1: Introduction to Excel
Exam 1: Introduction to Excel100 Questions
Exam 2: Formulas and Functions100 Questions
Exam 3: Charts100 Questions
Exam 4: Datasets and Tables100 Questions
Exam 5: Subtotals, Pivottables, and Pivotcharts100 Questions
Exam 6: What-If Analysis100 Questions
Exam 7: Specialized Functions100 Questions
Exam 8: Statistical Functions100 Questions
Exam 9: Multiple-Sheet Workbook Management98 Questions
Exam 10: Imports, Xml, and Power Add-Ins95 Questions
Exam 11: Collaboration and Workbook Distribution96 Questions
Exam 12: Templates, Styles, and Macros97 Questions
Exam 13: Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer115 Questions
Select questions type
When you do not need the data on a worksheet you should ________ it to make the file smaller.
(Short Answer)
4.7/5
(91)
Which Paste option would you choose if you wanted to flip the rows and columns?
(Multiple Choice)
4.7/5
(79)
The ________ feature displays any values in the column that match what the user has typed so far.
(Short Answer)
5.0/5
(74)
Where would you find the command to center the printout both horizontally and vertically on your paper?
(Multiple Choice)
4.9/5
(81)
Match the following Excel Elements with their description or action:
Correct Answer:
Premises:
Responses:
(Matching)
4.9/5
(68)
The ________ feature helps you complete an incremental series.
(Short Answer)
4.9/5
(84)
It is acceptable to use values in formulas when you know those values will never change.
(True/False)
4.8/5
(69)
It is relatively easy to copy Excel cells into other Office programs.
(True/False)
4.9/5
(86)
You should use ________ in formulas whenever possible instead of static numbers.
(Short Answer)
4.8/5
(84)
What is the best way to make sure your worksheet prints on only one page?
(Multiple Choice)
4.7/5
(91)
Match the following Paste options with their description:
Correct Answer:
Premises:
Responses:
(Matching)
4.9/5
(88)
When you copy and paste a range the relative references do not change.
(True/False)
4.7/5
(84)
What should you do if there are columns you need, but do not want to display?
(Multiple Choice)
4.8/5
(73)
What would not be a typical item to have in a header or footer?
(Multiple Choice)
4.8/5
(87)
You can ________ a cell's contents to the right or left to help it stand out from the row above or below.
(Short Answer)
4.8/5
(81)
You can add ________ color to a cell or range of cells for emphasis.
(Short Answer)
5.0/5
(83)
Showing 61 - 80 of 100
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)