Excel Assessment

What is it called when you combine two or more cells in to one?

• Merge
• Combine
• Join
• Union

The horizontal placement of cells in a table or worksheet.

• range
• row
• column
• cell

What is a vertical section of a spreadsheet

• row
• addition
• column
• format

An equation that calculates a new value from values currently in a worksheet.

• Formula Bar
• column
• cell
• formula

The box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value (or the results of a formula).

• Formula Bar
• worksheet
• Name Box
• formula

A single sheet contained in an excel workbook.

• worksheet
• workbook
• Chart
• sheet tab

What function should be entered to calculate the total budget?

• =AVERAGE(B3:B6)
• =SUM(B3:B6)
• =SUM(B3-B6)
• =TOTAL(B3:B6)

You want to enter a series of dates down a column. What would be the best tool for the job?

• Find and Replace
• AutoFill
• Spelling Checker
• Cut and Paste

This operator symbol is for what type of operation?   /

• addition
• subtraction
• multiplication
• division

If you want to subtract two numbers in a formula, which formula would be correct?

• =1.2*3
• =e3+e7
• =A2-30
• -E7=A3