Home > Microsoft Excel > Quizzes > Management Science MGSC 290 Ross Exam
Management Science MGSC 290 Ross Exam
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 58% Most missed: “The intersection of a row and column.”
Management Science MGSC 290 Ross Exam
Time left 00:00
25 Questions

1. _________ are the data in each cell that is used in calculations in worksheets.

2. _______ refers to the required parts of a formula and the rules controlling the order of the parts

3. ___________ is the fixed location of a cell referenced in a formula or dialog box. Include a $ around both the column and row references

4. The _______ function includes the current time along with the current date

5. A _____________ occurs when a formula includes the cell address of the formula

6. __________ are the pieces of information within parentheses that determine what value a function returns

7. The _________ function finds a value in the first column of a range of cells and returns a value from any cell on the same row of the range

8. You can ___________ columns and rows to resize the column width or row height to accommodate the width or height of the largest entry by double-clicking the border of the column or row heading.

9. What are the five basic types of arithmetic operators in formulas?

10. A group of cells

11. What are the three types of cell references?

12. When more than one operator appears in a formula, Excel performs each operation by applying the _______________________.

13. ___________ allows you to quickly complete data in a series, such as days of the week, months in a year.

14. The ___________ displays a solid border around the cell.

15. The _________ function calculates loan payment amounts.

16. Cells have a ___________ which includes the intersection of column and row.

17. What is the mixed cell reference for the cell address D9 where the column letter reference is relative and the row number reference is absolute?

18. ___________ functions retrieve a value from a ranger or table of cells located in another area of the worksheet or workbook

19. _________ help the user understand what each set of data is and are not included in calculations in worksheets.

20. The ___________ command combines two or more selected cells and center aligns the text.

21. The _____________ feature expands or reduces a worksheet to fit on a specific number of pages or a specific paper size

22. ____________________ displays all cells referenced a particular cell.

23. By default, what file extension is given to Excel workbook files?

24. What do you use to change the order in which Excel performs each operation in a formula with multiple operators?

25. _____________ is a window that opens on your desktop that allows you to browse for files. It includes libraries and folders on the left side and its associated contents on the right side.