Georgia State University Filter and Disable Filtering Questions

I’m working on a business multi-part question and need guidance to help me understand better.

When filtering is enabled, you can clear the filter and disable filtering from the _______ tab.

Home

Data

Design

Format

2

If the Sort by choice is Date and the Then by choice is Last Name, both ascending sorts, which of the following data pairs would sort to the top of the list?

Feb 2011, Adams

Jan 2011, Albert

Apr 2011, Adams

Mar 2011, Albert

3

Sparklines are one method for formatting a trendline in an Excel chart.

True

False

4

Conditional formatting provides a _______ analysis of data.

visual

critical

rules

process

5

#DIV/0 is an example of a worksheet _______ that can display in a cell.

cell reference

error

status

value

6

What happens to your worksheet after selecting the Delete Sheet Rows option?

All of the data in the selected row(s) will be erased and the worksheet area occupied by the deleted row(s) will turn gray.

All of the data in the selected row(s) will be erased and the row(s) will now appear empty.

The selected row(s) will be deleted and the rows above will shift down.

The selected row(s) will be deleted and the rows below will shift up.

7

If your workbook is wide, you may want to use _______ orientation to view more columns on one page.

portrait

landscape

page

backstage

8

The SUMIF function totals all values in an Excel worksheet.

True

False

9

The MID text function extracts the characters from the middle of a string.

True

False

10

Formula AutoComplete is a shortcut for entering _______.

functions

formulas

totals

ranges

11

The results for the formula =COUNTIF(B2:B10,”Indiana”) would display _______.

Indiana

a value

a text string

#N/A

12

The Fill Color button is also available from the _______ when you right-click a cell.

Font group

Styles group

Editing group

Mini toolbar

13

When you insert a picture into an Excel worksheet, the images are embedded objects, meaning they become part of the workbook.

True

False

14

Pie charts do not contain _______.

pie slices

data points

point explosions

gridlines

15

The Freeze Panes button is located in the Window group of the _______ tab.

Page Layout

View

Insert

Formulas

16

To change the calculation type for the current field in a PivotTable, make the selection in the _______ dialog.

Change Formula

Select

Value Field Settings

Functions

17

You can save your Excel chart as a template for future use.

True

False

18

When the formula is =IF(AND(A2=”blue”,A3=”yellow”),”green”,”wrong color”), what is the result if A2 is “blue” and A3 is “yellow”?

wrong color

TRUE

green

=FALSE

19

The hide and unhide options for columns and rows are located under the _______ button.

Clear

Format

Sort & Filter

Fill

20

Inserting new cells into a worksheet keeps the same _______ as the cells above or to the left depending on how you select to shift the cells.

cell reference

relative reference

absolute reference

formatting

21

To remove filtering, click the _______ button.

Remove Filter

Clear Filter

Delete Filter

Reverse Filter

22

One way to subtotal data without formulas and without including the details in an outline format is to use _______.

Grouping

Consolidate

Summaries

Outline

23

An example of the NOW function is _______.

NOW

=NOW(B1:D1)

=(NOW)

=NOW()

24

An example of the AVERAGE function is _______.

AVERAGE(B3:D3)

=AVERAGE(B3:D3)

(B3:D3)

(B3:B14)

25

A _______ style is a combination of effects that can be applied at one time to a cell.

cell

range

worksheet

workbook