Deck 46: Cells and Cell Data
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/35
Play
Full screen (f)
Deck 46: Cells and Cell Data
1
Which of the following is NOT considered an object in Excel?
A) chart
B) equation
C) video
D) cell reference
A) chart
B) equation
C) video
D) cell reference
D
2
To select a range of adjacent cells,right-click in a cell and then drag the mouse pointer to select additional cells.
False
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
A) right-clicking on
B) dragging
C) pressing Ctrl+O for
D) pressing the right-arrow key on
B
4
In Excel,a red line surrounds a range of cells marked for copying.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
5
A formula always begins with an equal sign.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
6
In Excel,once you have created and saved a workbook,individual spreadsheets within the workbook cannot be renamed.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
7
After you select a range of cells,any formatting changes will affect all the cells in that range.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
8
In Excel,you enter data in a ____.
A) column
B) cell
C) row
D) formula grid
A) column
B) cell
C) row
D) formula grid
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
9
In Excel,cell data cannot be manipulated after a spreadsheet is saved.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
10
To insert a new row in a spreadsheet,select the row above where you want the new row inserted.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
11
An Excel spreadsheet opens in ____ if you downloaded it from the Internet.
A) Protected View
B) Yellow
C) Protected Mode
D) Locked View
A) Protected View
B) Yellow
C) Protected Mode
D) Locked View
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
12
Only Microsoft Office's Excel program makes use of "objects."
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
13
To select non-adjacent cells,hold down the Ctrl key and move the mouse over the cells to be selected.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
14
Across the bottom of each workbook are its ____,each representing an individual spreadsheet.
A) borders
B) tabs
C) views
D) cells
A) borders
B) tabs
C) views
D) cells
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
15
A spreadsheet's column width can be adjusted by clicking and dragging the column's border.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
16
The default name for a worksheet within a workbook is Tab1.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
17
When a spreadsheet opens in Protected View,you are unable to make changes to the file.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
18
An example of an Excel object is a ____.
A) ribbon name
B) Help topic
C) picture
D) row number
A) ribbon name
B) Help topic
C) picture
D) row number
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
19
A new feature in Excel 2013 is ScreenTip.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
20
If you leave Protected View on,your ability to print will be limited.
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
21
After you copy a cell,a ____ appears around the cell.
A) range
B) red,solid line
C) marquee
D) blue highlight
A) range
B) red,solid line
C) marquee
D) blue highlight
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) click on the tab name
B) double-click
C) click and hold down the left mouse button
D) press F2
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) Shift
B) Alt
C) Tab
D) Ctrl
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) fill handle
B) contents
C) formula bar
D) ribbon
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) Ready
B) Edit
C) Change
D) Enter
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
26
A column's width should be stated as ____.
A) 85
B) 85 pixels
C) 85 points
D) 85 colrow
A) 85
B) 85 pixels
C) 85 points
D) 85 colrow
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
27
After pasting copied cell data,unselect it by pressing the ____ key.
A) Shift
B) Esc
C) Ctrl
D) F2
A) Shift
B) Esc
C) Ctrl
D) F2
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) Format
B) Styles
C) Adjust
D) Clipboard
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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)
A) =today()
B) =date()
C) =current()
D) =equation(today)
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) grouping
B) range
C) function
D) Autofit
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) Protected View
B) auto-detect
C) flash fill
D) identity fill
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) Enable Edit
B) Autofit
C) Autofill
D) Alt+Enter
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
33
Which of the following is a proper cell range reference?
A) 12H:27M
B) A3-D3
C) H12:M27
D) A3::D3
A) 12H:27M
B) A3-D3
C) H12:M27
D) A3::D3
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
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
A) C2
B) B3
C) A2
D) none of the above; the cursor does not move
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck
35
A row's height should be stated as ____.
A) 85
B) 85 pixels
C) 85 points
D) 85 rowcol
A) 85
B) 85 pixels
C) 85 points
D) 85 rowcol
Unlock Deck
Unlock for access to all 35 flashcards in this deck.
Unlock Deck
k this deck