Excel Basics Question Preview (ID: 16879)


Excel Test Review. TEACHERS: click here for quick copy question ID numbers.

When keying a formulas in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text?
a) +
b) =
c) -
d) /

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

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) Cell Address
d) Entry

Urla needs to total the cells A1:A10, what is the quickest method to find the answer?
a) Label
b) Value
c) Function
d) Formula

Paul has to enter unit price for an product, who will this data be classified?
a) Label
b) Value
c) Function
d) Formula

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

ABC Corporation has listed all it’s produced in the cell range A1 to A45, where are the products displayed?
a) Row
b) Column
c) Entry
d) Cell Address

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

Urla needs to total the cells A1:A10, what is the quickest method to find the answer?
a) Label
b) Value
c) Function
d) Formula

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

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

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

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

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

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links