Exam 1: Getting Started With Excel
Exam 1: Getting Started With Excel93 Questions
Exam 2: Formatting Workbook Text and Data58 Questions
Exam 3: Performing Calculations With Formulas and Functions37 Questions
Exam 4: Analyzing and Charting Financial Data47 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks27 Questions
Exam 6: Managing Data With Data Tools50 Questions
Exam 7: Summarizing Data With Pivottables39 Questions
Exam 8: Performing What-If Analyses22 Questions
Exam 9: Exploring Financial Tools and Functions5 Questions
Exam 10: Analyzing Data With Business Intelligence Tools25 Questions
Exam 11: Exploring Pivottable Design22 Questions
Exam 12: Developing an Excel Application60 Questions
Exam 13: Customizing Your Workspace Text and Graphics.(Digital Only).10 Questions
Exam 14: Introducing Power BI (Digital Only).3 Questions
Exam 15: Collaborating with Your Team.(Digital Only).53 Questions
Select questions type
When you select a cell range,the cells must be adjacent to each other.
Free
(True/False)
4.8/5
(28)
Correct Answer:
False
Which of the following functions inserts the total of a range?
Free
(Multiple Choice)
4.7/5
(40)
Correct Answer:
D
Which of the following is true about pasting copied text? Select all the options that apply.
Free
(Multiple Choice)
4.8/5
(33)
Correct Answer:
B,D
What feature inserts a function that totals the cells above or to the left of the selected cell?
(Multiple Choice)
4.9/5
(35)
Which of the following statements is true about COUNT functions?
(Multiple Choice)
4.7/5
(31)
Which of the following lets you search for a function or select one from a category?
(Multiple Choice)
4.9/5
(39)
To fit all worksheet content on one page,you can set page scaling in Backstage view.
(True/False)
4.8/5
(36)
In the formula =SUM(A6:A9),which of the following best describes A6?
(Multiple Choice)
4.9/5
(29)
To enter a range of text based on examples that are already in your worksheet,which of the following can you use?
(Multiple Choice)
4.9/5
(27)
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.
(True/False)
5.0/5
(52)
To print your worksheet at its actual size,which of the following would you select?
(Multiple Choice)
4.7/5
(40)
Which of the following is a built-in formula that helps you perform complex calculations?
(Multiple Choice)
4.9/5
(30)
You can edit cell contents in the Formula bar or in the cell itself.
(True/False)
4.9/5
(28)
When you enter a value in a worksheet cell,it is automatically left-aligned.
(True/False)
4.9/5
(41)
Which of the following would you use to print only one page of a multipage worksheet?
(Multiple Choice)
4.8/5
(39)
Which of the following can you use to insert a formula using a function?
(Multiple Choice)
4.8/5
(29)
Where can you see a preview of how your worksheet will look when printed,including headers?
(Multiple Choice)
4.9/5
(39)
Where do you rename a workbook and adjust its save location?
(Multiple Choice)
4.7/5
(34)
Showing 1 - 20 of 93
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)