Number 584002RR

Click Here to Download this Answer Instantly

Exam Number: 584002RR
Lesson Name: Microsoft Excel 2016
Question 1 of 20 : Select the best answer for the question.
1. Which function should be used to display a value based on a comparison?
A. IF
B. MIN
C. COUNT
D. AVERAGE
Question 2 of 20 : Select the best answer for the question.
2. If you have long column labels with columns so wide that they affect the readability of a
worksheet, you should first
A. leave the column labels as is.
B. decrease the column widths.
C. format the column labels.
D. consider how you could shorten the column labels.
Question 3 of 20 : Select the best answer for the question.
3. Circular errors are caused by adding the cell name of a/an _______ cell to a formula.
A. adjacent
B. absolute
C. active
D. relative
Question 4 of 20 : Select the best answer for the question.
4. Which is the correct formula to add the values in cells A1 and B1?
A. A1+B1
B. =SUM(A1+B1)
C. SUM(A1+B1)
D. =SUMA1+B1
Question 5 of 20 : Select the best answer for the question.
5. The data selected to create a chart must include
A. formulas.
B. formatted cells.
C. blank rows and columns.
D. column titles and row labels.
Question 6 of 20 : Select the best answer for the question.
6. How many worksheets display in the Excel window when you create a new blank workbook?
A. 3
B. 2
C. 4
D. 1
Question 7 of 20 : Select the best answer for the question.
7. What would be a situation in which you could use an Excel chart to present your data?
A. Required ingredients for three different kinds of cake.
B. Compiling survey questions and answers from business clients.
C. What percentage of customer 101 buys product A, and what percentage of the same customer
buys product B?
D. Listing team members on a soccer team with their address information.
Question 8 of 20 : Select the best answer for the question.
8. You are able to drag a cell to a new location by pointing to the cell border until the pointer
displays a
_______ arrow, and then dragging the cell to the new location.
A. single
B. double-headed
C. four-headed
D. three-headed
Question 9 of 20 : Select the best answer for the question.
9. When you see ##### in a cell, you should
A. decrease the cell height.
B. increase the cell width.
C. decrease the cell width.
D. increase the cell height.
Question 10 of 20 : Select the best answer for the question.
10. You can tell a cell is the active cell when it has a
A. bold border and it is where the data you type will appear.
B. colored border and it is where the data you type will appear.
C. colored border and data you type will appear next to it.
D. bold border and data you type will appear next to it.
Question 11 of 20 : Select the best answer for the question.
11. Press the _______ key to move to the next cell in a row.
A. Home
B. Enter
C. Page Down
D. Tab
Question 12 of 20 : Select the best answer for the question.
12. The data selected to create a table must include
A. formatting.
B. row headers.
C. formulas.
D. column headers.
Question 13 of 20 : Select the best answer for the question.
13. Which feature of the Excel window displays the contents of an active cell?
A. Ribbon
B. Quick Access Toolbar
C. Formula bar
D. Tell Me box
Question 14 of 20 : Select the best answer for the question.
14. A _______ refers to the entire Excel file.
A. sheet
B. workbook
C. worksheet
D. spreadsheet
Question 15 of 20 : Select the best answer for the question.
15. You can apply several different worksheet themes from which tab?
A. Insert
B. Home
C. File
D. Page Layout
Question 16 of 20 : Select the best answer for the question.
16. Which key removes all data from an active cell with one click?
A. F2
B. Delete
C. Tab
D. Esc
Question 17 of 20 : Select the best answer for the question.
17. The mathematical order of operations is used in Excel when formulas are evaluated. This order
of operations states the order to be
A. exponentiation, multiplication and division, addition and subtraction.
B. multiplication and division, addition and subtraction, exponentiation.
C. multiplication and division, exponentiation, addition and subtraction.
D. addition and subtraction, multiplication and division, exponentiation.
Question 18 of 20 : Select the best answer for the question.
18. Create a cell reference in a formula by typing in the cell name or
A. right-clicking the cell.
B. clicking the row where the cell is located.
C. clicking the column where the cell is located.
D. clicking the cell.
Question 19 of 20 : Select the best answer for the question.
19. When long labels are required, which of these commands can you use to improve readability of
a worksheet?
A. Conditional Formatting
B. Merge & Center
C. Sort & Filter
D. Wrap Text
Question 20 of 20 : Select the best answer for the question.
20. Once you have selected the range of cells for your table data, from which tab can you open the
Insert Table dialog box?
A. Layout
B. Review
C. Insert
D. Home