BAT Chapter 2

Question 1

.csv

Answer 1

A common file format that can be opened by many applications

Question 2

Ctrl+ A

Answer 2

Used to quickly select all cells in a worksheet

Question 3

SUM

Answer 3

A built in formula that adds the values in a selected range

Question 4

Workbook

Answer 4

File you create and edit

Question 5

Range

Answer 5

A rectangular group of cells in Excel

Question 6

When you click on a cell to activate it, the cell address appears in the —-.

Answer 6

Name box

Question 7

Ctrl + (+plus sign)

Answer 7

Use when inserting a new column or row in an existing worksheet

Question 8

Worksheet Tab

Answer 8

Displays the name of the worksheet at the bottom left

Question 9

Home Tab

Answer 9

Where the clipboard group is found

Question 10

Destination Cell

Answer 10

Where cut or copied data is pasted

Question 11

Freeze Panes

Answer 11

Select when you want columns and row headings displayed anywhere on the spreadsheet

Question 12

.html

Answer 12

The extension for a web page workbook

Question 13

After you select and cut cells, the cells are temporarily placed where?

Answer 13

On the clipboard

Question 14

Format Cells

Answer 14

Applies a border or shading to select cells

Question 15

Function

Answer 15

A built in formula

Question 16

Save as

Answer 16

Saves workbook with a different name

Question 17

Auto Fit

Answer 17

Resizes columns width or row height to accommodate the largest entry