CSA II Test 1 Spreadsheet Basics: Question Preview (ID: 20943)

Below is a preview of the questions contained within the game titled CSA II TEST 1 SPREADSHEET BASICS: Cte II .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

Play games to reveal the correct answers. Click here to play a game and get the answers.

Which function will calculate how much time has elapsed since a customer's payment was received?
a) Count
b) CountA
c) Days360
d) Now

Which function will calculate your final grade if your exam counts 25%, your test grades count 25%, and your daily work counts 50%?
a) Average
b) If
c) Max
d) Min

What formula will divide E5 by E6?
a) =E5/E6
b) =E6;E5
c) =E6/E5
d) =E6;E5

A spreadsheet is created with drop down items a user can select from, this is an example of which function?
a) Count
b) Fill series
c) List
d) Look up

Which is a function of excel?
a) FUN
b) SUM

Which is a formula to multiply two cells in EXCEL?
a) D6+D7
b) D6*D7
c) =D6*D7
d) D6xD7

Which of the following in an example of the correct format for adding data from two cells together?
a) A5-C6
b) =A5+A6
c) =A5-A6
d) A5A6

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

Which function can an accountant use that will result in the current date?
a) Count
b) CountA
c) Max
d) Now

Which function will be used to find how many cells have an actual number in them?
a) Count
b) Days360
c) Now
d) Min

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from the data set above, visit ReviewGameZone.com and enter game ID number: 20943 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

Log In
| Sign Up / Register