Deck 13: Excel 2013 : Managing Workbook Data

Question 1

A translucent background design that prints behind your data is called a ____.

A) transparency
B) bitmap
C) watermark
D) logo

Answer 1

C

Question 2

The Hide and Unhide buttons in the Window group are used for hiding individual worksheet cells.

Answer 2

False

Question 3

When you view each worksheet from a workbook in its own window,you are viewing ____.

A) copies
B) instances
C) work windows
D) mirrors

Answer 3

B

Question 4

To inspect a document for issues,you first click the Protect Workbook button in the Inspect Workbook area.

Question 5

A worksheet displayed in its own window is called a(n)____.

A) workspace
B) instance
C) workbook
D) group

Question 6

When you protect a worksheet,unlocked areas can still be changed.

Question 7

In the accompanying figure,item number 1 indicates a(n)____.

A) vertical split
B) horizontal split
C) watermark
D) instance

Question 8

To open two instances of one Excel workbook,you need to open it twice from its original location.

Question 9

The Excel Custom Views feature allows you to create several views of a worksheet without having to create separate sheets.

Question 10

The cell lock option does not change the way a user interacts with a worksheet until the protection feature is activated.

Question 11

A picture added to the worksheet background will show on screen and will also print.

Question 12

A watermark will print behind worksheet data.

Question 13

Cells in the data entry area are generally locked.

Question 14

The area in which data in cells may be changed is sometimes called the data entry area.

Question 15

When you create custom views,you name the view first and then set the worksheet display.

Question 16

In the accompanying figure,item number 2 indicates a(n)____.

A) vertical split
B) horizontal split
C) watermark
D) instance

Question 17

In order to see who has permission to open,copy,or change your workbook,click the FILE tab and review the information area.

Question 18

The Synchronous Scrolling button allows you to scroll through arranged worksheets simultaneously.

Question 19

To open two instances of one Excel workbook,you open the file and then create a new window using the New Window button in the Window group.

Question 20

To show and hide custom views,you click the Add View button in the Custom Views dialog box.

Question 21

When you save an Excel workbook as an earlier version of Excel,what appears in the title bar when you open the file?

A) Enable Worksheet
B) [Protected]
C) [Compatibility Mode]
D) The version number of Excel

Question 22

A company's internal website is called a(n)____.

A) Internet
B) Intranet
C) Server
D) Weblink

Question 23

Which button do you click to add information about a hyperlink?

A) ScreenTip
B) Caption
C) Info
D) INSERT

Question 24

If you want to enter header or footer information on one worksheet and have it appear on several other worksheets,you should first ____ the worksheets.

A) protect
B) group
C) show
D) hide

Question 25

A ____ will print behind worksheet data.

A) background
B) keyword
C) watermark
D) digital signature

Question 26

To ____ an Excel workbook,is to place it on a network or on the Web so that others can access it using their Web browsers.

A) link
B) export
C) publish
D) upload

Question 27

Metadata is information that describes ____.

A) keywords
B) hyperlinks
C) workspaces
D) data

Question 28

Which of the following cannot be a hyperlink in Excel?

A) filename
B) word
C) graphic
D) title bar

Question 29

Which of the following is not a possible window arrangement in the Arrange Windows dialog box?

A) Tiled
B) Layered
C) Horizontal
D) Cascade

Question 30

In the accompanying figure,the worksheet is split into how many panes?

A) 1
B) 2
C) 3
D) 4

Question 31

MHTML is also known as ____.

A) MHT
B) MHL
C) HTML
D) XML

Question 32

In the accompanying figure,which item allows users to select worksheet cells?

A) 1
B) 2
C) Password text box
D) Format cells check box

Question 33

Which of the following save options should you use so that someone who has an earlier version of Excel can view your Excel document?

A) Excel 2010 Workbook
B) Excel 97-2003 Workbook
C) Excel 2003-2007 Workbook
D) Excel 98 and Later Workbook

Question 34

In the accompanying figure,item 1 points to the check box option that ____.

A) groups the worksheets
B) freezes the worksheet cells
C) opens the Document Inspector
D) prevents locked cells from changes

Question 35

The coding format used for all Web documents is called ____.

A) HTML
B) XML
C) MHTML
D) JAVA

Question 36

Which of the following cannot be a target?

A) Web site home page
B) hyperlink
C) Word document
D) Excel worksheet

Question 37

To save a single-file Web page that integrates all worksheets and graphics from one workbook,you need to save the file as ____.

A) XLS
B) view
C) MHTML
D) HTML

Question 38

In the accompanying figure,which of the following is true?

A) Users can select locked cells but not edit them.
B) Users can select and edit locked cells.
C) Users cannot select or edit locked cells.
D) Users can edit locked cells but not select them.

Question 39

Which of the following is a way to edit grouped worksheets?

A) Freeze the worksheet panes
B) Create a read-only version
C) Protect them
D) Insert a header

Question 40

A hyperlink jumps to a ____.

A) source
B) target
C) Web page
D) dialog box

Question 41

The color of a hyperlink depends on the worksheet ____ colors.

A) theme
B) background
C) watermark
D) font

Question 42

In the accompanying figure,there are ____ link to choices.

A) 1
B) 2
C) 3
D) 4

Question 43

In the accompanying figure,one of the files in the Data Files folder will be the ____.

A) ScreenTip
B) category
C) destination
D) hyperlink target

Question 44

____ help users locate,identify and understand a file.

A) Targets
B) Properties
C) Names
D) Hyperlinks

Question 45

The ____________________ Scrolling button allows you to scroll through arranged worksheets simultaneously.

Question 46

In the accompanying figure,the term "Category" refers to the ____ for the hyperlink.

A) source
B) ScreenTip
C) category
D) target

Question 47

You can split an Excel worksheet into multiple ____________________ using the Split button in the Window group on the VIEW tab.

Question 48

A background that is repeated to fill a background is a(n)____________________ background.

Question 49

The area or range of cells whose data is allowed to change is known as the ____________________ entry area.

Question 50

Cells that are protected so that their contents cannot be altered are called ____________________ cells.

Question 51

To view the Document Inspector dialog box,click the Check for Issues button,and then click ____.

A) Check Document
B) Document Info
C) Inspect Document
D) Protect Document

Question 52

The single-file Web page file format is called ____________________.

Question 53

To avoid problems when ____________________ your pages to a Web server,it is best to use lowercase letters.

Question 54

____________________ are terms users can search for to help them locate a workbook.

Question 55

What appears in the title bar when you mark a workbook as final?

A) [Compatibility Mode]
B) [Final]
C) [Read-Only]
D) [Enable Content]

Question 56

A(n)____________________ is a translucent background design that prints behind your data.

Question 57

The hyperlink button is in the ____ group on the INSERT tab.

A) Data
B) Links
C) Interactive
D) Web

Question 58

A worksheet displayed in its own workbook window is called a(n)____________________.

Question 59

A hyperlink jumps to a ____.

A) target
B) server
C) source
D) publisher

Question 60

Which of the following can users search for to help them locate a workbook?

A) groups
B) folder names
C) keywords
D) links

Question 61

____________________ include keywords,the author's name,a title,the status,and comments.

Question 62

A(n)____________________ is a set of display and / or print settings that you can name and save and then access at a later time.

Question 63

A word or object in a worksheet that,when clicked,displays,or "jumps to," another location is called a(n)____________________.

Question 64

HTML is the ____________________ format used for all Web documents.

Question 65

How do you create custom margins in Excel?

Question 66

Keywords,the author's name,a title,the status,and comments are all examples of helpful information about a workbook,more specifically called ____________________.

Question 67

What is the difference between a view and an instance?

Question 68

How do you create a view?

Question 69

You must be connected to the ____________________ to test a hyperlink.

Question 70

Cells in the ____________________ format can be viewed but no changes can be made.

Question 71

The ____________________ Inspector dialog box lists items from which you can have Excel evaluate hidden or personal information.

Question 72

The destination of a hyperlink is called the ____________________.

Question 73

____________________ is information that describes data.

Question 74

How do you create a hyperlink?