Advanced Spreadsheets

Which formula correctly calculates the total of cells B2, B3, B4, and B5?

• =SUM(B2-B5)

• =(B2+B5)SUM

• =SUM(B2:B5)

• =SU<(B2:B5)

Where can a list of available functions be found in Microsoft Excel?

• function library

• help

• equations

• formula lookup

Which of the following is true about equations and functions?

• None can calculate cell ranges.

• They all start with an equals sign.

• None can bu updated once created.

• They all require absolute cell addresses.

Choose the logical function.

• SUM

• MIN

• OR

• MAX

Choose the correct function for displaying the current date.

• =TODAYmmddyyyy

  ="TODAY"

• =TODAY()

• =TODAY

• ="TODAY"

Which function calculates the minimum value of cells G1 through G14?

• =MIN(G1:G14)

• =MINIMUM(G1:G14)

• =MIN(G1,G14)

• =MINIMUM(G1,G14)

If a cell is formatted as a percentage, how will a data entry of .77 appear?

• .77

• 77%

• 7700%

• .77%

You are creating a spreadsheet that contains tech support call goals. Column A lists the number of tech support calls. Based on the value in column A, column B indicates if the tech support call goal of 500 calls was met. Choose the formula that will calculate if the goal was achieved.

• =IF(A1>=500, "Yes","No")

• A. =IF(A1>=500,[Yes", "No"])

• A. =IF(A1>=500,(Yes), (No))

• A. =IF[A1>=500, Yes, No]

What chart would be used to demonstrate the percentage of technicians who have hardware and software certifications?

• Bar chart

• Pie chart

• Line chart

• Table

A _____ file contains data with commas to denote the beginning and end of each datum in a row.

• comma-included (CI)

• comma-separated values (CSV)

• comma-organized table (COT)

• comma-established values (CEV)