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 organize data
B
To calculate costs
C
To calculate revenue(Money)
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
=A5+A6
B
A5A6
C
=A5-A6
D
A5-C6
3) Which is a function of excel?
A
SUM
B
NONE
C
HERE
D
FUN
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
=E5/E6
D
=E6;E5
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
List
C
Fill series
D
Count
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
If
B
Max
C
Min
D
Average
8) Which function will calculate how much time has elapsed since a customer's payment was received?
A
CountA
B
Days360
C
Now
D
Count
9) Which function can an accountant use that will result in the current date?
A
Count
B
CountA
C
Now
D
Max
10) Which function will be used to find how many cells have an actual number in them?
A
Days360
B
Count
C
Min
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?