Deck 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Question 1

Fonts are associated with different themes and can be customized by ________.

A)clicking in the default themes option
B)using the predefined themes that come with Office 2016
C)mixing Colors and Fonts from any of the supplied themes
D)using Live Preview

Answer 1

C

Question 2

You can force the data in a worksheet into a selected number of pages by using the ________ command.

A)scaling
B)percentages
C)extra pages
D)formulas

Answer 2

A

Question 3

To freeze column and row titles on the screen so that they are visible while you scroll,which of the following command(s)would you use?

A)Hide
B)Freeze Panes
C)Go To
D)Insert

Answer 3

B

Question 4

A predesigned set of colors,fonts,lines,and fill effects that look good together and that can be applied across all Office 2016 applications is called a ________.

A)layout
B)design
C)style
D)theme

Question 5

Before printing or distributing a large worksheet,the Print Preview option enables you to see ________.

A)orientation and page breaks
B)only orientation
C)small errors
D)large objects

Question 6

A theme combines font sets for ________.

A)functions and headings
B)text and headings
C)names and ranges
D)cells and formulas

Question 7

A hyperlink in a worksheet may take you to which of the following locations ________.

A)another location in the worksheet or the company intranet
B)a page break
C)home
D)links dialog box

Question 8

You can create a custom table style by clicking ________.

A)table designs
B)Cell Styles
C)Format as Table
D)table elements

Question 9

The portions of a worksheet window bounded by and separated from other portions by vertical or horizontal lines as a result of using the Freeze Panes command are referred to as ________.

A)tasks
B)borders
C)panes
D)windows

Question 10

Clicking a ________ will take you to another location in the worksheet,another file location,a webpage on the intranet,or to your organization's Internet.

A)Save As dialog box
B)page break
C)hyperlink
D)welcome screen

Question 11

To move to cells that have special characteristics,are blank,or contain constants,use the ________ command.

A)Find and Select
B)Go To Special
C)Replace
D)Tab

Question 12

A defined set of formatting characteristics for a cell,such as fonts,font sizes,number formats,cell borders,and cell shading is known as a(n)________.

A)format option
B)theme
C)enhancement
D)cell style

Question 13

The Page Break view shows where the page breaks will occur by displaying ________.

A)an arrow to move the pages around in the worksheet
B)blue dashed lines and the page number on the worksheet
C)the header and footer
D)a welcome screen

Question 14

To tile multiple open worksheets on the screen,use the ________ command.

A)Rearrange
B)Split
C)Go To
D)Arrange All

Question 15

If the file to which a hyperlink refers to is moved or renamed,or a webpage to which a hyperlink refers has a new address,which of the following do you need to do to the hyperlink to make it work correctly?

A)Leave the hyperlink as is
B)Modify the hyperlink to reflect the change
C)Call the webmaster to fix the link
D)Delete the hyperlink altogether

Question 16

Hyperlinks can be attached to which of the following items?

A)Page breaks
B)Text and graphics
C)An instructor
D)Another hyperlink

Question 17

To move to a specific cell or range of cells in a large worksheet use the ________ command.

A)Insert
B)Find and Replace
C)Tab
D)Go To

Question 18

You can share worksheets or workbooks with others by ________.

A)printing paper copies,sending the file electronically,or posting the file to the web or a shared workspace
B)inserting a page break
C)repeating the row and column titles on the pages of the worksheet
D)using File Save As and renaming the file "share"

Question 19

A predesigned set of colors,fonts,lines,and fill effects that look good together and can be applied to your workbook is a ________.

A)Page Layout
B)Gallery
C)Theme
D)View

Question 20

Scaling reduces the ________ size of the printed data by a percentage or by the number of pages you specify.

A)page and worksheet
B)horizontal and vertical
C)logical and proportionate
D)column and row

Question 21

Which of the following file formats is commonly used to import data into a database program?

A)MDB
B)CSV
C)TBL
D)DOC

Question 22

Saving an Excel worksheet as a CSV file separates the cells of each row with ________.

A)quotes
B)commas
C)periods
D)tabs

Question 23

A ________ is a single piece of information that is stored in every record.

A)field
B)value
C)database
D)query

Question 24

If you want every one of the comparison criteria that you specify to be true,you would use the ________.

A)Or comparison operator
B)Equals operator
C)And comparison operator
D)Less than operator

Question 25

By default,Excel 2016 files are saved in the native Microsoft Excel Workbook file format with the following file extension ________.

A))xls
B))xlsx
C))xlsd
D))csv

Question 26

An organized collection of facts related to a specific topic is known as a ________.

A)field
B)database
C)query
D)record

Question 27

You can save an Excel file as a text file with which of the following file extensions?

A))csv
B))pdf
C))rtf
D))txt

Question 28

Which of the following are some frequently and commonly used file formats for Excel?

A)Bitmap or JPEG
B)MDB or PDF
C)Excel Template,Excel 97-2003 Workbook,CSV or tab delimited
D)TXT or DOC

Question 29

Use a(n)________ to apply complex criteria to a single column.

A)Custom filter
B)Sort
C)Advanced Filter
D)Find and Replace

Question 30

A series of rows that contains related data is known as a ________.

A)list
B)record
C)block
D)query

Question 31

________ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results.

A)Custom filtering
B)Criteria
C)Filtering
D)AutoFiltering

Question 32

To save an Excel file in another file format,use the ________ command.

A)Delete
B)Format
C)Save As
D)Save

Question 33

Subtotaled rows that are totaled and summarized are referred to as ________ data.

A)summary
B)subtotal
C)actual
D)detail

Question 34

The first step in adding subtotals to a group or list is to sort the data by the ________ for which you want to create a subtotal.

A)query
B)list
C)field
D)block

Question 35

Instead of displaying a filtered list,you can copy the results of a filter to another area of your worksheet for comparison purposes;this action is known as ________.

A)extracting
B)filtering
C)pasting
D)coping

Question 36

Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.

A)macro
B)template
C)comma separated value
D)tab delimited text file

Question 37

To apply complex criteria to a single column,use a(n)________.

A)advanced filter
B)AutoFilter
C)custom filter
D)extracting filter

Question 38

The outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click.

A)paste and close
B)copy and open
C)show and hide
D)copy and paste

Question 39

The defined table range will automatically display as the ________ range in the Advanced Filter dialog box.

A)Criteria
B)List
C)Conditional
D)Action

Question 40

Which of the following describes all of the categories of data pertaining to one person,place,thing,event,or idea within a table row?

A)Database
B)Query
C)Field
D)Record

Question 41

Data can be pulled out or copied from a filtered list and placed below the table of data.

Question 42

Using the Advanced command disables the AutoFilter command and removes the AutoFilter arrow from the column headings.

Question 43

You can create your own themes,cell styles,and table styles in Excel.

Question 44

When filtering by format or value using AutoFilter in Excel,each filter type is mutually exclusive for the column;that is,you can use only one at a time.

Question 45

When you create a custom list,the list remains available for all workbooks that you use in Excel.

Question 46

Defining data as a table prior to sorting the data is optional.

Question 47

When using compound criteria on the same row,all the conditions must be met for the records to be included in the results.

Question 48

The criteria range must have a row for the column headings and at least one row for the criteria.

Question 49

If your worksheet is wider than one page,you will also want to repeat the row titles on each page when you print or view the worksheet.

Question 50

The active area of a worksheet contains data or has contained data and does NOT contain cells that were not used in the worksheet.

Question 51

To quickly locate specific text,formatting,or type of information within a workbook,use the Find command.

Question 52

Excel worksheets and workbooks can be saved as web pages.

Question 53

You can customize your table by creating and applying a custom table style of your own design.

Question 54

The file format known as Portable Document Format was developed by Microsoft.

Question 55

Use a wildcard character to search a field when you are uncertain of the exact value for which you are searching.

Question 56

You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.

Question 57

Both the List and the Criteria ranges use absolute references.

Question 58

A question mark (?)in a search criteria enables you to search for single characters in the field.

Question 59

The criteria range is an area on your worksheet where you define the criteria for the filter.

Question 60

When using custom or advanced filters,the selected range can be formatted as a table or a database.

Question 61

Subtotal rows that are totaled and summarized are referred to as actual data.

Question 62

In Excel,the applied theme has a set of complimentary ________,which are defined sets of formatting characteristics,such as fonts,font sizes,number formats,cell borders,and cell shading.

Question 63

You can save a single worksheet as a webpage,where Excel changes the content of the worksheet into ________,a language web browsers can interpret.

Question 64

When outlining a worksheet,if the data is not organized so that Excel can outline it automatically,you can create an outline manually.

Question 65

The portions of a worksheet bounded by and separated from other parts of the worksheet by horizontal and vertical lines are called ________.

Question 66

Clicking a ________ will take you to another location in the worksheet,another file location,a webpage on the intranet,or to your organization's Internet.

Question 67

To move to a specific cell or range of cells in a large worksheet use the ________ command.

Question 68

To set column and row titles on the screen while you scroll,use the ________ command.

Question 69

You can use a(n)________ list to sort in an order that you define.

Question 70

To publish a document and ensure that the appearance of the document is the same no matter what computer it is displayed on,save the document in ________ format.

Question 71

A custom list that you define must be based on a ________ such as text,a number,a date,or time.

Question 72

The default font for headings in Excel is ________.

Question 73

Use the ________ mark wildcard to search criteria that represents a single position or character that is unknown in a group of specified values.

Question 74

A sort on a group of numbers that is sorted from highest to lowest is known as a(n)________ sort.

Question 75

A file format that was created by Adobe Systems to create a representation of what an Excel spreadsheet would look like when printed is ________.

Question 76

To force data into a selected number of pages,use the ________ command.

Question 77

The outline bar along the left side of a worksheet enables you to show and hide levels of detail with a single mouse click.

Question 78

A series of rows that contains related data is known as a query.

Question 79

Detail data refers to the subtotaled rows that are totaled and summarized.

Question 80

A text file can be converted from tab delimited text to a Word table by selecting the ________ command that easily converts a tabbed file into a table.