Homework answers / question archive /   Excel Quiz     1

  Excel Quiz     1

Computer Science

Share With

---

 

Excel Quiz

 

 

1. A chart sheet can contain

2. When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

3. The formula used to multiply cell A1 by cell C1 is

4. An error value begins with a pound sign (#) followed by an error name that indicates the type of error. _

5. A constant is a value in a formula that doesn’t change.

6. Case 3-2

Susan is in charge of the inventory reports for her company.  She will need to find specific inventory items as well as project increases in inventory costs.  To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools.

?

Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.

 

7. An Excel formula always begins with a(n)

8. Formatting changes only the appearance of data—it does not affect the data itself.

9. When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.

10. A mixed reference “locks” one part of the cell reference while the other part can change.

11. Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting.

 

12. PMT(rate, nper, pv [, fv=0] [, type=0])

 

The possible values for the type argument in the function above are.

 

13. mm/dd/yyyy is known as _

14. Normal view shows how the worksheet will appear when printed

15. Absolute references are marked with a _

16. Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.

17. The AutoComplete feature automatically completes an entry based on previous entries in a column. 

18. A(n) ____ is a group of cells in a rectangular block

19. Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab

20. Calculated values too large to fit into the cell are displayed in scientific notation.

21. Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent

22. A ____________ displays data values as columns with the height of each column based on the data value.

23. To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.

24. The characters +, -, *, and / are examples of ____.

25. Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal.

26. According to the order of operation in Excel:

27. In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell

28. If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

29. In ____ orientation, a page is taller than it is wide.

30. PMT(rate, nper, pv [, fv=0] [, type=0])

 

In the figure above, fv and type are ____.

31. =IF(G22=“x”, SUM(H22:J22),  “ ”) with display ______ if G22 is not equal to “x”.

32. A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value.

33. =ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.

 

34. AutoFit changes the column width or row height to display the longest or tallest entry within the column or row. _

35. A pie slice is a data marker that represents ____ from a data series.