Excel Chapter 1 MC

Question 1

Excel is an electronic version of a(n) ____.

Answer 1

Spreadsheet

Question 2

Excel stores its documents as files called ____.

Answer 2

workbooks

Question 3

The contents of an active cell are displayed in the ____.

Answer 3

formula bar

Question 4

A chart can be displayed ____.

Answer 4

in a worksheet or a chart sheet

Question 5

The name given to an Excel workbook before you rename it is ____.

Answer 5

Book1

Question 6

You can have more than ____ cells in each worksheet.

Answer 6

17 billion

Question 7

“AD” is an example of a ____.

Answer 7

column heading

Question 8

Row headings identify each row using a different ____.

Answer 8

number

Question 9

The intersection of a row and column is known as a ____.

Answer 9

cell

Question 10

To go to column A of the current row, click ____.

Answer 10

Home

Question 11

By default, an Excel workbook is made up of ____ worksheets.

Answer 11

three

Question 12

An Excel worksheet can have a maximum of ____ columns in a worksheet

Answer 12

16,385

Question 13

To make A1 the active cell, press which of the following keys?

Answer 13

Ctrl+Home

Question 14

The active cell has a ____ border.

Answer 14

thick

Question 15

There are ____ ways to view the current worksheet.

Answer 15

three

Question 16

Text data is any combination of ____.

Answer 16

letters, numbers, and some symbols

Question 17

To complete a cell entry, press the ____ key.

Answer 17

Enter

Question 18

Text is ____-aligned in cells.

Answer 18

left

Question 19

The characters +, -, *, and / are examples of ____.

Answer 19

arithmetic operators

Question 20

The expression used to calculate values displayed in a worksheet is called a(n) ____.

Answer 20

formula

Question 21

An Excel formula always begins with a(n) ____.

Answer 21

equals sign

Question 22

The formula used to multiply cell A1 by cell C1 is ____.

Answer 22

=A1*C1

Question 23

To divide the value of a cell by some number, use the ____ operator.

Answer 23

/

Question 24

A(n) ____ is a group of cells.

Answer 24

range

Question 25

Removing the contents of a cell is known as ____ a cell.

Answer 25

clearing

Question 26

To view formulas, rather than the resulting values in a worksheet, switch to ____.

Answer 26

formula view

Question 27

To select a nonadjacent range, select an adjacent range, press and hold ____ and then select other adjacent ranges.

Answer 27

Ctrl

Question 28

Excel provides the ability to create new worksheets and new ____ sheets

Answer 28

chart

Question 29

To select a large range of cells, click the first cell in the range, press and hold ____, and then click the last cell in the range.

Answer 29

Shift

Question 30

Copying a range of cells is similar to moving a range, except that you must press the ____ key while you drag the selection to its new location.

Answer 30

Ctrl