Excel Basics Quiz

A formula in the spreadsheet should always start with

• A bracket

• A capital letter

• A plus sign

• An equals sign

• An asterisk

In a spreadsheet formula which symbol is used to divide?

• x

• /

• *

• +

• -

In a spreadsheet formula which symbol is used to multiply ?

• x

• /

• *

• +

• -

Which of these would add up the numbers from A3 to A6

• +(A3:A6)

• =(A3:A6)

• =Sum(A3:A6)

• =(Ave(a3:a6))

To copy the formatting of one cell to another you would use the

• Chart Wizard

• Copy and Paste

• Format Painter

• Delete key

What is the name of the area within a worksheet that is current, or ready to receive information?

• Cell

• Active Cell

• Worksheet

• Office Assistant

Which filename extension is used for Excel workbooks?

• .com

• .htm

• .doc

• .xls

• .ppt

How are rows designated?

• Numbers

• Letters

• Stars

• Circles

What is the name given to the intersection of a row and a column in a spreadsheet?

• Cube

• Square

• Cell

• Block

What is the name given to the bar that allows you to enter values and perform calculations in a spreadsheet?

• Numbers bar

• Math bar

• Formula bar

• Calculation bar