Microsoft EXCEL

In a spreadsheet, where can cells be found? 

• At the top, where each column is defined
• At the bottom, where all the numbers are added up 
• On the right-hand side, where each row is defined
• At the intersection of every row and every column

In Excel, what is this button used for? 

• Adding a border 
• Changing the font
• Changing margins
• Creating a Table

In Excel, what is this button used for? 

• To change the color of the background 
• To change the font color
• That button is not used in Excel
• To fill the cell with a color

In Excel, what currency format is this in? 

• Accounting
• Currency
• General
• It’s not in a currency format

Which of the following formulas is correctly written for Excel? 

• =5B*4
• 5+8=
• D3/4=
• =b1-d23

Which of the following formulas is NOT written correctly for Excel? 

• =A4*9
• =6-2
• =(s2+4)/5
• =Minimum(A2:A8) 

What is the formula to calculate the AVERAGE of a range of cells?  

• =AVERAGE(B3:B8)
• =AVERAGE:B3:B8
• =(AVERAGE)B3:B8
• AVERAGE(B3:B8)=

What is the formula to calculate the MAXIMUM of a range of cells? 

• =(MAX)B3:B8
• = MAX(B3:B8)
• MAX(B3:B8)= 
• = MAXIMUM(B3:B8)

What is the formula to calculate the MINIMUM of a range of cells? 

• = MIN(B3:B8)
• = MIN:B3:B8
• =MINIMUM(B3:B8)
• MIN(B3:B8)= 

In Excel a Chart is a Graph.

• TRUE
• FALSE