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
Count
B
Fill Series
C
List
D
Lookup
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
If
C
Max
D
Min
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
If
B
Lookup
C
Max
D
Min
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
Min
B
Max
C
Sum
D
Average
6) Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received?
A
CountA
B
Days360
C
Now
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
Embed
B
Link
C
Fill Series
D
Freeze
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
Ascending
B
Primary
C
Descending
D
Secondary
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
Months
B
Sales
C
Products
D
Units Sold
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
Link
D
Import
*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?