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


Cte II. TEACHERS: click here for quick copy question ID numbers.

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
c) NONE
d) HERE

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 above, visit ReviewGameZone.com and enter game ID number: 20943 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links