Advanced Spreadsheets

Front

Which formula correctly calculates the total of cells B2, B3, B4, and B5? Options: =SUM(B2-B5), =(B2+B5)SUM, =SUM(B2:B5), =SU<(B2:B5)

Back

=SUM(B2:B5)

Front

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

Back

function library

Front

Which of the following is true about equations and functions? None can calculate cell ranges., They all start with an equals sign., None can be updated once created., They all require absolute cell addresses.

Back

They all start with an equals sign.

Front

Choose the logical function: SUM, MIN, OR, MAX

Back

OR

Front

Choose the correct function for displaying the current date.

Back

=TODAY()

Front

Which function calculates the minimum value of cells G1 through G14? Options: =MIN(G1:G14), =MINIMUM(G1:G14), =MIN(G1,G14), =MINIMUM(G1,G14)

Back

=MIN(G1:G14)

Front

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

Back

77%

Front

Choose the formula that will calculate if the tech support call goal of 500 calls was met based on the number of tech support calls in column A:

Back

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

Front

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

Back

Pie chart

Front

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

Back

comma-separated values (CSV)