BiM II Semester 1 Exam

Front

A _____ is an Excel file.

Back

workbook

Front

A _____ is an Excel spreadsheet page.

Back

worksheet

Front

Each rectangle in a spreadsheet is a _____.

Back

cell

Front

The _____ box shows the address of the cell you have selected.

Back

name

Front

Which one of the following is an electronic spreadsheet program?

Back

Front

What are the basic components of the ribbon?

Back

tabs, groups, dialog launchers, command button

Front

The formula that adds values in a specified range that meet a certain condition or criteria is called:

Back

SUMIF

Front

The absolute cell reference uses which symbol: $ , % , * , &

Back

$

Front

To combine text that is in two different cells, use the formula:

Back

CONCATENATE

Front

Unlocked cells are NOT editable if a worksheet or workbook is protected.

Back

FALSE