Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
CSA II Test 1 Spreadsheet Basics
Test Description: Cte II
Instructions: Answer all questions to get your test result.
1) Which is not a use of spreadsheets for businesses?
A
To calculate revenue(Money)
B
To calculate costs
C
To organize data
D
To post phone numbers
2) Which of the following in an example of the correct format for adding data from two cells together?
A
A5A6
B
A5-C6
C
=A5-A6
D
=A5+A6
3) Which is a function of excel?
A
HERE
B
NONE
C
FUN
D
SUM
4) Which is a formula to multiply two cells in EXCEL?
A
=D6*D7
B
D6+D7
C
D6*D7
D
D6xD7
5) What formula will divide E5 by E6?
A
=E6;E5
B
=E6;E5
C
=E6/E5
D
=E5/E6
6) A spreadsheet is created with drop down items a user can select from, this is an example of which function?
A
Look up
B
Count
C
Fill series
D
List
7) Which function will calculate your final grade if your exam counts 25%, your test grades count 25%, and your daily work counts 50%?
A
Min
B
Max
C
If
D
Average
8) Which function will calculate how much time has elapsed since a customer's payment was received?
A
Now
B
Days360
C
Count
D
CountA
9) Which function can an accountant use that will result in the current date?
A
CountA
B
Now
C
Max
D
Count
10) Which function will be used to find how many cells have an actual number in them?
A
Days360
B
Min
C
Count
D
Now
*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?