Spreadsheets Question Preview (ID: 37042)


Module 7. TEACHERS: click here for quick copy question ID numbers.

When keying a formula in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text?
a) Addition Operator
b) Division operator
c) Equal sign
d) Subtraction sign

ABC Corporation has listed all of its sales information for one product in the cell range A1 to K1. Where is this sales information displayed?
a) Row
b) Column
c) Entry
d) Cell Address

A sales manager has requested the total sales for the first quarter. Which function will be used?
a) SUM
b) MIN
c) MAX
d) AVG

ABC Corporation has listed all of its products in the cell range A1 to A45. Where are the products displayed?
a) Row
b) Column
c) Entry
d) Cell Address

Paul has to enter the zip code for a client. How will this data be classifed?
a) Label
b) Value
c) Formula
d) Function

Paul has to enter a unit price for a product. How will this data be classifed?
a) Label
b) Value
c) Formula
d) Function

Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
a) Label
b) Value
c) Formula
d) Function

A sales manager has requested the highest sale for the first quarter. Which function will be used?
a) SUM
b) MIN
c) MAX
d) AVG

A sales manager has requested the lowest sale for the first quarter. Which function will be used?
a) SUM
b) MIN
c) MAX
d) AVG

After entering the number of sales for the first quarter, where will they align?
a) Right
b) Left
c) Centered
d) Justified

The column letter and row number make up what?
a) Cell address
b) Cell content
c) Formula bar title
d) Chart

When entering the client's names, what is the default alignment?
a) Right
b) Left
c) Centered
d) Justified

Which if the following is the correct way to write a function in a spreadsheet?
a) =SUM(A1-A5)
b) =SUM(A1+A5)
c) SUM(A1:A5)=
d) =SUM(A1:A5)

The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?
a) =MAX(A1:A6)
b) =MIN(A1:A6)
c) =AVERAGE(A1:A6)
d) =SUM(A1:A6)

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: 37042 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links