Excel 1.10 - 1.11 (Part 1) Question Preview (ID: 41450)


Part 1. TEACHERS: click here for quick copy question ID numbers.

James wants to use an advanced function to search his spreadsheet for a specific string in a text string?
a) SUBSTITUTE
b) VLOOKUP
c) FIND
d) REPLACE

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) Share Workbook
b) Export
c) Tracking Changes
d) Protect Workbook

Where is the spellchecker located?
a) Home Ribbon
b) View Ribbon
c) Review Ribbon
d) Page Layout Ribbon

IF, AND, OR and NOT are all part of which category of functions?
a) Text
b) Logical
c) Math Trig
d) Lookup Reference

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) Edit Comment
b) Delete
c) New
d) Show Ink

Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?
a) VLOOKUP
b) SUBSTITUTE
c) FIND
d) SEARCH

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
a) Share
b) Protect Sheet
c) Protection
d) Protect Workbook

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) Change History
c) Track Changes
d) Names Manager

Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
a) Trim
b) Lower
c) Upper
d) Proper

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) Convert Text to Column Wizard
b) Comma Delimited
c) Split View
d) View Side by Side

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) Delete
b) Show Ink
c) Edit Comment
d) New

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) TOTALIF
b) SUMIF
c) COUNTIF
d) AVERAGEIF

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 41450 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links