Microsoft Excel Review

How do you rename a worksheet in Excel?

• Double-click the sheet tab and type a new name

• Go to File and select "Rename Sheet"

• Richt-click on any cell in the worksheet and select "Rename"

• Click on "Insert" and choose "New Sheet"

What happens when you press Ctrl (or Cmd on Mac) + Z in Excel?

• Saves the file

• None of these

• Undoes the last action

• Deletes the selected cell

If you selected (A1:B5) what is this called?

• row

• column

• cell range

• cell grouping

The Excel punctuation that is used to show formulas in a cell is

• ~ or `

• +

• =

• #

The Excel punctuation that shows a range is a

• :

• $

• *

• +

What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?

• cell bar

• formula bar

• status bar

• name box

f you want to freeze the top row in Excel, which option should you use?

• Hide Row

• Split Window

• Freeze Panes

• Autofill

The Excel punctuation that shows "Not Equal to"

• <

• >

• >=

• <>

The intersection of a row and column

• Active Cell

• Sort

• Cell Range

• Cell

A preprogrammed formula is called a _______. Ex: =SUM(B3*B2)

• Formula

• Spreadsheet

• Function

• Cell Range