Basic Spreadsheet Formulas

How do formulas begin

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

What do (parenthesis) 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 will Divide the value in cell A3 by 27?

• =27/A3

• = A3/27

• = 27^A3

• =A3^27

Which of the following will 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 Sheets?

• /

• =

• ^

• *

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

Which of the following raises the value of cell B6 to the 11th power?

• B6 ^ 11
• 11 ^ B6
• =B6 ^ 11
• =11 ^ B6