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
Months
C
Stock names
D
Stock prices
2) A spreadsheet is created with drop down items that a user can select from. This is an example of which function?
A
Fill Series
B
List
C
Count
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
Min
D
Max
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
Max
D
If
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
Sum
C
Min
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
Days360
B
Now
C
CountA
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
Fill Series
B
Freeze
C
Link
D
Embed
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
Descending
B
Ascending
C
Primary
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
Units Sold
B
Sales
C
Products
D
Months
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
Link
B
Import
C
Embed
D
Target
*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?