Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #9
Test Description: Review
Instructions: Answer all questions to get your test result.
1) Jessica needs to capitalize the first letter in each word. Which function would she use?
A
LOWER
B
PROPER
C
UPPER
D
TRIM
2) Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
A
TRIM
B
PROPER
C
UPPER
D
LOWER
3) Tom wants to convert all text to lowercase. Which function should he use?
A
PROPER
B
UPPER
C
LOWER
D
TRIM
4) 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
COUNTIF
B
SUMIF
C
AVERAGEIF
D
TOTALIF
5) 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
6) 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
AVERAGEIFS
B
TOTALIFS
C
COUNTIFS
D
SUMIFS
7) Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
A
LOOKUP
B
HLOOKUP
C
SEARCH
D
VLOOKUP
8) Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
A
HLOOKUP
B
SEARCH
C
LOOKUP
D
VLOOKUP
9) Which is an example of a function that extracts the year from a date that is typed in cell B9?
A
=YEAR(B21)
B
=YEAR(DATE,B9)
C
=DATE(B9)
D
=DATE(YEAR,B9)
10) In order to change the name of a range of cells, the user must first click the Formulas tab. What feature should the user click next?
A
Name Manager
B
Name Selector
C
Define Name
D
Trace Dependents
11) Tyrone would like to use a function that returns a value that meets criteria in the second row of a table in his spreadsheet. Which function should he use?
A
MATCH
B
INDEX
C
HLOOKUP
D
VLOOKUP
12) What is the maximum number of characters in a range name?
A
125
B
55
C
355
D
255
13) AVERAGEIFS, COUNTIFS, and GROWTH are found in which category of functions?
A
Statistical
B
Text
C
Logical
D
Lookup and Reference
14) A spreadsheet contains 50 rows with pet records. Column A is Breed, column B is Name, and column C is Gender. To determine the number of animals that are female, what is the range when using the COUNTIF function?
A
C2:C50
B
A2:A50
C
B2:B50
D
A2:C50
15) Which function takes three separate values and combines them to form a date-time code?
A
DATE
B
NOW
C
TODAY
D
YEAR
16) As the manager of a furniture store, Sally is using an Excel spreadsheet to keep track of the store sales goals. She wants to use a function that will return TRUE if at least one of the two goals is reached. Which function should she use?
A
AND
B
OR
C
NOT
D
IF
17) Naming ranges or an individual cell is a time-saving technique. Range names may include a letter, an underscore, and:
A
a backslash.
B
an exclamation point.
C
a question mark.
D
a forward slash.
18) Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?
A
TODAY
B
IF
C
NOW
D
COUNT
19) Larry has created a spreadsheet containing student grades. Which function would he use to return the current date and time in cell A1?
A
IF
B
COUNT
C
NOW
D
TODAY
20) Which is an example of a correctly written nested function?
A
=PROPER((RIGHT(B4,LEN(B4-FIND( ,B4)))
B
=(PROPER(RIGHT(B4,LEN(B4)-FIND( ,B4)))
C
=PROPER(RIGHT(B16,LEN(B16)-FIND( ,B16)))
D
=PROPERRIGHT(B4,LEN,B4)-FIND( ,B4))
*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?