Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Spreadsheet Unit Test CSA II
Test Description: Basics and Advanced Functions
Instructions: Answer all questions to get your test result.
1) If Jake wants to study the relationship between the daily temperature and the amount of fruit sold during a week, what kind of chart should he use?
A
D. XY scatter
B
Line
C
B. Pie
D
C. Stacked bar
2) Which chart will BEST represent the percentage of expenses for office supplies, salaries, and travel for a company's total budget?
A
A. Line
B
D. XY scatter
C
C. Stacked bar
D
B. Pie
3) Which chart will BEST represent a comparison of the average family income in three states, with emphasis on the states?
A
A. Column
B
C. Pie
C
B. Line
D
D. XY scatter
4) A spreadsheet is created with drop down items that a user can select from. This is an example of which function?
A
D. Lookup
B
A. Count
C
C. List
D
B. Fill series
5) Jaylen uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items when they reach a certain quantity. Which function should he use?
A
C. Max
B
D. Min
C
A. If
D
B. LookUp
6) Mrs. Jay uses a spreadsheet to keep track of student test scores and daily grades. Which function should she use to calculate a final grade for each student?
A
B. Count
B
D. Sum
C
A. Average
D
C. If
7) Which function can an accounting department use in Cell A2 that will result in the current date?
A
A. Count
B
C. Days360
C
D. Now
D
B. CountA
8) Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received?
A
B. CountA
B
A. Count
C
C. Days360
D
D. Now
9) What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month?
A
B. CountA
B
A. Count
C
C. Fill Series
D
D. If
10) Which type of chart displays bars side by side?
A
A. Column
B
D. Pictogram
C
B. Line
D
C. Pie
11) Data presented in a spreadsheet can be easily understood by using what?
A
D. Symbol
B
A. Database
C
B. Chart
D
C. Letter
12) What type of chart uses the height of a bar to represent a value?
A
A. Column
B
B. Line
C
C. Pie
D
D. Scattergram
13) On most charts, what is the horizontal (bottom) edge of the plot area called?
A
C. Y axis
B
A. A axis
C
D. Z axis
D
B. X axis
14) Which of the following two formatting features are applied to $5,698.87?
A
C. Currency and underline
B
D. Large font size and bold
C
B. Numbers and text
D
A. Currency and two decimal places
15) Which component of a chart describes what is contained within the chart?
A
A. Chart Gridlines
B
C. Chart Shape
C
D. Chart Color
D
B. Chart Title
16) The number of hours worked is recorded in Cell D7. Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which formula correctly determines how many (if any) overtime hours have occurred?
A
A. =IF(D7 less than sign 40),1.5*E7
B
B. =IF(D7 Greater than sign 40, D7-40)
C
D. =OVERTIME(D7*E7)
D
C. =MAX(D1:D7)*1.5
17) 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
C. Freeze
B
B. Fill series
C
A. Embed
D
D. Link
18) What is the BEST way to resolve repeated pound signs in a formula's result?
A
A. Delete the formula and key the answer
B
C. Shorten the formula so it fits
C
B. Delete the formula and rekey it
D
D. Widen the column
19) Repeated pound signs in a spreadsheet cell indicate what?
A
B. Column width too wide
B
D. Row height too wide
C
C. Row height too narrow
D
A. Column width too narrow
20) What are the three most common types of charts used to illustrate spreadsheet data?
A
B. Bar, line, and scattergram
B
A. Bar/column, line, and pie
C
D. Pie, scattergram, and stacked bar
D
C. Line, pie, and area
*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?