Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Unit 4.0 B
Test Description: Unit 4.0 B
Instructions: Answer all questions to get your test result.
1) When creating a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the x axis?
A
Oil prices
B
Stock prices
C
Months
D
Stock names
2) A spreadsheet is created with drop down items that a user can select from. This is an example of which function?
A
Lookup
B
List
C
Fill Series
D
Count
3) What function should Eva use to calculate her final grade if her exam counts 25%, her test grades count 25%, and her daily work counts 50%?
A
Average
B
Min
C
Max
D
If
4) What function will display the word "Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" when otherwise?
A
Lookup
B
Min
C
If
D
Max
5) What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost?
A
Average
B
Min
C
Sum
D
Max
6) Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received?
A
Now
B
CountA
C
Days360
D
Count
7) What operation will Eve use to keep rows and columns visible so that they don't scroll off the screen as she moves around the worksheet?
A
Freeze
B
Fill Series
C
Embed
D
Link
8) Mr. Evans sorted the student athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part of the sort operation?
A
Primary
B
Descending
C
Secondary
D
Ascending
9) A chart is created that compares the number of units of Product a sold against the number of units of Product B sold for a period of three months. Which data appears on the y-axis?
A
Sales
B
Units Sold
C
Months
D
Products
10) What procedure should be followed to ensure that an object does NOT change in a word processing document when it is edited in the spreadsheet of its original creation?
A
Embed
B
Target
C
Import
D
Link
*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?