Deck 94: Cells and Cell Data

Question 1

In Excel,an individual spreadsheet within a workbook cannot be renamed.

Answer 1

False

Question 2

Numbers and characters can be entered directly in a spreadsheet cell.

Answer 2

True

Question 3

What keystrokes do you use to change the name of a spreadsheet?

A) alt+command
B) command+click
C) option+click
D) return

Answer 3

B

Question 4

To select a range of adjacent cells,right-click in a cell and then drag the mouse pointer to select additional cells.

Question 5

You can select a range of nonadjacent cells in a spreadsheet.

Question 6

When typing in a cell,press and hold the command and option keys and then press the return key to create a line break in the cell.

Question 7

The default name of the first worksheet in a new workbook is Sheet1.

Question 8

A spreadsheet's column width can be adjusted by clicking and dragging the column's border with the mouse.

Question 9

You can open a blank workbook by clicking the Excel icon on the Dock.

Question 10

The term "calendar year" is used when a company's accounting calendar does not begin in January.

Question 11

You can use the tabs at the bottom of a workbook to create,name,rearrange,and delete individual ____.

A) worksheets
B) workbooks
C) cells
D) columns

Question 12

To select non-adjacent cells,hold down the command key and click the cells to be selected.

Question 13

You want the current date to display in your spreadsheet.What formula should you use to accomplish this task?

A) =TODAY()
B) =DATE()
C) =Current()
D) =equation(TODAY)

Question 14

An equation is a type of ____.

A) cell
B) value
C) object
D) thumbnail

Question 15

In Excel,you enter data in a ____.

A) column
B) cell
C) row
D) formula grid

Question 16

By default,pressing the return key after entering a value in cell B2 moves the cursor to cell ____.

A) C2
B) B3
C) A2
D) none of the above; the cursor does not move

Question 17

In Excel,an individual spreadsheet within a workbook can be deleted.

Question 18

After you select a range of cells,you can format all the cells in the range at the same time.

Question 19

In Excel,cell data cannot be edited after a spreadsheet is saved.

Question 20

An example of an Excel object is a ____.

A) Ribbon name
B) Help topic
C) picture
D) print preview

Question 21

To move an individual spreadsheet to a new tab location,you ____________________ it and drag it to its new location.

Question 22

To insert a new column in an open spreadsheet,you must first select the column to the ____________________ of where you want to insert the new column.

Question 23

When you are editing a cell,Excel's mode indicator displays the word ____________________.

Question 24

After you copy a cell,a ____ appears around the cell.

A) range
B) solid line
C) marquee
D) blue highlight

Question 25

A group of specific cells in a worksheet is called a(n)____________________.

Question 26

A row's height should be stated as ____.

A) 85
B) 85 pixels
C) 85 points
D) none of the above

Question 27

You click on a cell and want to replace its contents.How can you accomplish this?

A) Right-click the cell and click "Replace text".
B) Delete the cell and replace it with a new cell.
C) Type the new cell contents.
D) Click the File tab and select Delete from the menu.

Question 28

After pasting copied cell data,turn off the flashing lines by pressing the ____ key.

A) shift
B) esc
C) command
D) option

Question 29

To add a border to a cell,click the Border button arrow in the Font group on the ____ tab.

A) Insert
B) Page Layout
C) Design
D) Home

Question 30

Cell B24,which is set to its default height and width,is not fully displaying its text.What should you do to display its entire contents?

A) Position the pointer on the left border between columns C and D so that it changes to a black two-headed arrow with a horizontal bar in the middle,then double-click it.
B) Position the pointer on the bottom border between rows 24 and 25 so that it changes to a black two-headed arrow with a horizontal bar in the middle,then double-click it.
C) Position the pointer on the right border between columns C and D so that it changes to a black two-headed arrow with a horizontal bar in the middle,then double-click it.
D) Position the pointer on the top border between rows 23 and 24 so that it changes to a black two-headed arrow with a horizontal bar in the middle,then double-click it.

Question 31

Selected cells in a range are highlighted in ____.

A) red
B) blue
C) orange
D) yellow

Question 32

When examining a cell,its ____________________ is the small blue box in the lower-right corner.

Question 33

When you move the mouse over a cell's ____,the pointer changes from a white cross to a black one.

A) fill handle
B) contents
C) formula bar
D) Ribbon

Question 34

To adjust a group of rows,begin the process by first selecting the rows,and then click the ____ button in the Cells group on the Home tab.

A) Format
B) Insert
C) Adjust
D) Row Height

Question 35

How do you edit a cell's contents?

A) Press command+click.
B) Click the cell and start typing.
C) Click the cell and press return.
D) Double-click the cell.

Question 36

To delete a selected column in a spreadsheet,click the Delete button in the Cells group on the ____ tab.

A) Insert
B) Home
C) View
D) Review

Question 37

To insert a new row in an open spreadsheet,you must first select the row ____________________ where you want to insert a row.

Question 38

A column's width should be stated as ____.

A) 85
B) 85 characters
C) 85 points
D) none of the above

Question 39

In Excel,a(n)____________________ is anything that appears on screen that can be selected,edited,or manipulated.

Question 40

Which of the following is a proper cell range reference?

A) 12H:27M
B) A3-D3
C) H12:M27
D) A3::D3