Computer 7 (Review) 3rd Quarter

The vertical part of the worksheet

• Row

• Column

• Cell

• Range

A group of cells in a worksheet

• cell address

• active cell

• range

• cell pointer

What is the purpose of the Quick Access Toolbar

• It displays functions you have recently used as well as frequently used functions.

• You can only use it to save, redo and undo, create new documents, open documents and print.

• It provides shortcuts to functions you may use frequently as well as functions that may not be on the Ribbon.

• It provides access only to open and close the file

A file containing a set of spreadsheets is called ___________

• workbook

• spreadsheet

• worksheet area

• cell

Instead of deleting worksheets, you may do this to preserve them so that you might retrieve them later

• Unhide

• Hide

• Save

• Show

If you want to select multiple adjacent worksheets, click the tab of the first sheet you want to select; then hold the________ Button and select the tab of the last desired sheet

• Shift

• Ctrl

• Enter

• Alt

What is the format of date value when entered in a worksheet?

• Day/Month/Year

• Month/Day/Year

• Year/Month/Day

• Month/Year/Day

MS Excel stores numbers up to _____ significant digits.

• 12

• 13

• 14

• 15

Which data can have any character from your keyboard and cannot be use for calculation?

• Date/Time

• Numeric

• Function

• Text

Which of the following options represent the correct formula to multiply two values located in cells A1 and A2 with each other?

• Entering the formula: =A1xA2

• Entering the formula: =A1*A2

• Entering the formula: =PROD(A1:A2)

• Entering the formula: =MULTIPLY(A1:A2)