CSA Microsoft Excel

Which of the following adds the values in cells A1 through A10?

• =SUM(A1:A10)

• =SUM(A1,A10)

• =SUM(A1!A10)

• =SUM($A1$A10)

Alex wants to find the highest value in a range of cells. Which of the following functions should he use?

• =MIN( )

• =AVERAGE( )

• =MAX( )

• =MEDIAN( )

Which icon in the Function Library should be clicked to add the NOW function?

• AutoSum

• Date & Time

• Lookup & Reference

• More Functions

All formulas must begin with which of the following symbols?

• =

• +

• -

• ( )

Carlos needs to combine words in a First Name and a Last Name column. Which of the following functions should he use?

• IF

• MIN

• MAX

• CONCATENATE

Justin wants to create a formula which adds the values in cells A1 and B1 together and then multiplies the sum by 10. Which of the following formulas should he enter?

• +A1+B1*10

• .A1+B1*10

• =(A1+B1)*10

• &(A1+B1)*10

José notices cell A5 of his worksheet contains the railroad tracks (#####) formula error. What should he do?

• Delete the formula and just enter the value he wants in the cell

• Resize the cell to fit the contents

• Clear the formatting on the cell

• Filter the cell

Which of the following groups on the Formulas tab contains the ability to turn on Formula view?

• Formula Auditing

• Function Library

• Defined Names

• Calculations

Answer explanation

You can find the show formulas button on the formula auditing group under the Formulas Tab.

Which of the following tabs contains the command for adding a chart to an Excel worksheet?

• File

• Home

• Insert

• Formulas

Brandon wants to add a legend to his chart. Which of the following should he click to add this item?

• Quick Style

• Add Chart Element

• Shape Styles

• WordArt Styles