Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 1.10 - 1.11 (Part 1)
Test Description: Part 1
Instructions: Answer all questions to get your test result.
1) James wants to use an advanced function to search his spreadsheet for a specific string in a text string?
A
FIND
B
VLOOKUP
C
REPLACE
D
SUBSTITUTE
2) Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this?
A
Export
B
Tracking Changes
C
Share Workbook
D
Protect Workbook
3) Where is the spellchecker located?
A
Review Ribbon
B
Home Ribbon
C
View Ribbon
D
Page Layout Ribbon
4) IF, AND, OR and NOT are all part of which category of functions?
A
Lookup Reference
B
Math Trig
C
Logical
D
Text
5) Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose?
A
New
B
Delete
C
Show Ink
D
Edit Comment
6) Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?
A
FIND
B
VLOOKUP
C
SEARCH
D
SUBSTITUTE
7) What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
A
Protect Workbook
B
Share
C
Protect Sheet
D
Protection
8) All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made?
A
History
B
Track Changes
C
Change History
D
Names Manager
9) Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
A
Trim
B
Upper
C
Proper
D
Lower
10) In Sam's spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use?
A
Comma Delimited
B
Convert Text to Column Wizard
C
View Side by Side
D
Split View
11) Lilly is making changes to a spreadsheet her FBLA Advisor created. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should she use?
A
New
B
Edit Comment
C
Show Ink
D
Delete
12) Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?
A
COUNTIF
B
TOTALIF
C
SUMIF
D
AVERAGEIF
*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?