Lesson 10
Still 10
10 Again
Miss
Elainious
100
Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
A. VLOOKUP
B. HLOOKUP
C. LOOKUP
D. SEARCH
VLOOKUP
100
Tom wants to convert all text to lowercase. Which function should he use?
A. Trim
B. Proper
C. Upper
D. Lower
Lower
100
James wants to use an advanced function to search his spreadsheet for a specific string in a text string. What function should he use?
A. FIND
B. SUBSTITUTE
C. VLOOKUP
D. REPLACE
FIND
100
Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use?
A. SUMIF
B. AVERAGEIF
C. TOTALIF
D. COUNTIF
SUMIF
100
What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?
A. Copy method from Shortcut Menu
B. Copy using the Fill Handle
C. Copy from the Home Ribbon
D. Copy using the Quick Access Toolbar
Copy using the Fill Handle
200
Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use?
A. IF
B. AND
C. OR
D. NOT
AND
200
Jill would like to use a function that will return “True” when only one of the arguments in the function is true. What function should she use?
A. VLOOKUP
B. AND
C. OR
D. NOT
OR
200
Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?
A. FIND
B. SUBSTITUTE
C. VLOOKUP
D. SEARCH
SUBSTITUTE
200
What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
A. Styles
B. Alignment
C. Editing
D. Font
Styles
200
Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
A. =D4+F4
B. =D4*F4
C. =D4 x F4
D. =D4-F4
=D4*F4
300
Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in that range that are greater than 100 but less than 500. What function should he use?
A. SUMIFS
B. AVERAGEIFS
C. TOTALIFS
D. COUNTIFS
AVERAGEIFS
300
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 she use?
A. SUMIF
B. AVERAGEIF
C. TOTALIF
D. COUNTIF
COUNTIF
300
SUMIF and SUMIFS are in which category of functions?
A. Math & Trig
B. Text
C. Logical
D. Lookup & Reference
Math & Trig
300
How can a table style be quickly modified to meet user preferences?
A. Right-click on a style and choose Modify
B. Right-click on a style and choose Duplicate
C. Double-click a style from the Table Quick Styles Gallery
D. Choose Modify from the Styles Group on the Home Ribbon
Right-click on a style and choose Duplicate
300
Which is a prewritten formula that is built into Microsoft Excel?
A. Utility
B. Procedure
C. Function
D. Statement
Function
400
IF, AND, OR and NOT are all part of which category of functions?
A. Math & Trig
B. Text
C. Logical
D. Lookup & Reference
Logical
400
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
A. Trim
B. Proper
C. Upper
D. Lower
Upper
400
Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
A. VLOOKUP
B. HLOOKUP
C. LOOKUP
D. SEARCH
HLOOKUP
400
What is the process of bringing data containing text fields separated by commas into Excel called?
A. Importing data
B. Data collection
C. Data integration
D. Data migration
Importing data
400
Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that?
A. Ascending
B. Descending
C. Filter
D. Custom Filter
Custom Filter
500
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. Split View
C. View Side-by-Side
D. Comma Delimited
Convert Text to Column Wizard
500
James wants his spreadsheet to return true when the logical value is false. What function should he use?
A. IF
B. AND
C. OR
D. NOT
NOT
500
Jessica needs to capitalize the first letter in each word. Which function would she use?
A. Trim
B. Proper
C. Upper
D. Lower
Proper
500
Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a summary view of all of the first period classes. Which feature would allow him to do this?
A. Group
B. Collapse
C. Subtotal
D. Outline
Collapse
500
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
A. Home
B. Page Layout
C. Data
D. View
Page Layout