Basic Spreadsheets

How do formulas begin

• With  a () ( parenthesis)
• With a Question  (?)
• With an = (equal sign)
• None of these

What do (parenthesis) tell EXCEL to do in formulas?

• To  begin
• Where results are needed for order of operation
• What number format to use
• None of these

Which of the following tells EXCEL to Divide the value in cell A3 by 27?

• =27/A3
• = A3/27
• = 27^A3
• =A3^27

Which of the following tells EXCEL to subtract the value in cell A4 from the value in cell A3?

• A4-A3=
• A3-A4=
• =A4-A3
• =A3-A4

Which says multiply the value in cell A3 times 27 and then divide the product by the value in cell A4

• =A4/ (A3 x 27)
• (A3*27)/A4
• =(A3*27)/A4 
• = (A4*27)/A3

What do you do before you insert a graph in your worksheet?

• First Click Insert Graph
• First select the data to include
• First Select the type of graph you desire
• None of these

What symbol do we use for multiplication in EXCEL? 

• /
• =
• ^
• *

What is the fill handle?

• Copies cell data/formulas to adjacent cells
• Works with  the slim black plus sign
• Is found in the bottom right corner of a cell
• All of the above

Where do you find the formulas?

• Name box
• In the cell 
• In the formula bar
• Both in the cell and formula bar

What is Auto SUM

• A fast way to key addition formulas
• A Greek Letter
• A predictive tool for addition
• All of the above