Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Access Final Review 41-60
Test Description: Excel access final review 41-60
Instructions: Answer all questions to get your test result.
1) Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
A
theme
2) John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
A
split
B
unhide
3) Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
A
numbers
B
text
4) How would you move sheet tabs to a new position in the workbook
A
Choose Relocate on the Quick Access Toolbar
B
Click and drag the sheet tab to the new location
5) John would like to remove a worksheet from his workbook. Which option would he choose?
A
insert
B
delete
6) Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
A
hide
B
freeze
7) How is an exact copy of a worksheet created within the same workbook?
A
Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
B
Choose Move or Copy from the Quick Access Toolbar
8) John would like to change the order of the worksheets in his workbook. Which option would he choose?
A
move
B
insert
9) John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
A
split
B
hide
10) What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
A
thread
B
string
11) Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
A
freeze
B
header
12) Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
A
move
B
rename
13) When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
A
relative reference
B
absolute reference
14) Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
A
=B4-C4
B
=B4+C4
15) 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?
A
=SUM(D1-D13)
B
=SUM(D1:D13)
16) 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?
A
restrictions
B
condition
17) Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
A
max
B
average
18) Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
A
if
B
today
19) 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?
A
=MAX(1D:13D)
B
=MAX(D1:D13)
20) Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
A
calculation
B
formula auditing
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?