excel access final review 41-60

Match it! Select the correct answer from the pull down...Good luck!

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?

John would like to change the order of the worksheets in his workbook. Which option would he choose?

Which of the following is made up of two values and a relational operator, and is true or false for each cell in the range?

What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?

Wendy has created a spreadsheet to keep track of company sales. Sales for the East region are located in cells D1 through D13. Which function would she use to find the highest sales for the East region?

Wendy has created a spreadsheet to keep track of company sales. Sales for the East region are located in cells D1 through D13. Which function would she use to calculate total sales for the East region?

John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?

Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?