Deck 46: Cells and Cell Data

Question 1

Which of the following is NOT considered an object in Excel?

A) chart
B) equation
C) video
D) cell reference

Answer 1

D

Question 2

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

Answer 2

False

Question 3

You can reorganize the order of tabs in a workbook by ____ each tab and indicating a new position.

A) right-clicking on
B) dragging
C) pressing Ctrl+O for
D) pressing the right-arrow key on

Answer 3

B

Question 4

In Excel,a red line surrounds a range of cells marked for copying.

Question 5

A formula always begins with an equal sign.

Question 6

In Excel,once you have created and saved a workbook,individual spreadsheets within the workbook cannot be renamed.

Question 7

After you select a range of cells,any formatting changes will affect all the cells in that range.

Question 8

In Excel,you enter data in a ____.

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

Question 9

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

Question 10

To insert a new row in a spreadsheet,select the row above where you want the new row inserted.

Question 11

An Excel spreadsheet opens in ____ if you downloaded it from the Internet.

A) Protected View
B) Yellow
C) Protected Mode
D) Locked View

Question 12

Only Microsoft Office's Excel program makes use of "objects."

Question 13

To select non-adjacent cells,hold down the Ctrl key and move the mouse over the cells to be selected.

Question 14

Across the bottom of each workbook are its ____,each representing an individual spreadsheet.

A) borders
B) tabs
C) views
D) cells

Question 15

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

Question 16

The default name for a worksheet within a workbook is Tab1.

Question 17

When a spreadsheet opens in Protected View,you are unable to make changes to the file.

Question 18

An example of an Excel object is a ____.

A) ribbon name
B) Help topic
C) picture
D) row number

Question 19

A new feature in Excel 2013 is ScreenTip.

Question 20

If you leave Protected View on,your ability to print will be limited.

Question 21

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

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

Question 22

To view the exact size of a column's width,position the cursor on the right border of the column and ____.

A) click on the tab name
B) double-click
C) click and hold down the left mouse button
D) press F2

Question 23

To select multiple cells in a spreadsheet that do not connect to each other,use the ____ key and click on each cell.

A) Shift
B) Alt
C) Tab
D) Ctrl

Question 24

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 25

A worksheet is set for changes when the mode indicator found in the lower-left corner of the Excel window displays ____.

A) Ready
B) Edit
C) Change
D) Enter

Question 26

A column's width should be stated as ____.

A) 85
B) 85 pixels
C) 85 points
D) 85 colrow

Question 27

After pasting copied cell data,unselect it by pressing the ____ key.

A) Shift
B) Esc
C) Ctrl
D) F2

Question 28

To alter 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) Styles
C) Adjust
D) Clipboard

Question 29

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 30

Cells in a spreadsheet that are selected as a group for a specific purpose are defined as a(n)____.

A) grouping
B) range
C) function
D) Autofit

Question 31

A feature in Excel called ____ identifies patterns in your data and automatically fills in values based on what it learned.

A) Protected View
B) auto-detect
C) flash fill
D) identity fill

Question 32

To insert a line break within a selected cell,position your cursor and use ____.

A) Enable Edit
B) Autofit
C) Autofill
D) Alt+Enter

Question 33

Which of the following is a proper cell range reference?

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

Question 34

By default,pressing Enter 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 35

A row's height should be stated as ____.

A) 85
B) 85 pixels
C) 85 points
D) 85 rowcol