Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Biz Office Technology > Excel 2016 > Flashcards

Excel 2016 Flashcards

1
Q

*Which of the following functions finds the lowest value in a range of cell?

A

=MIN( )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

*Which of the following are composed of a grid system of rows and columns which cross to make cells?

A

Worksheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

*Which tab and group contains the option for adding conditional formatting?

A

Home tab, Styles group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

*Which tab and group on the Ribbon holds the command to change the font of the text of the cells of a worksheet?

A

Home tab, Font group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

*The IF Function is an Example of which type of function?

A

Logical

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

*Which of the following is NOT a type of conditional formatting?

A

Comment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

*Which of the following is an absolute cell reference?

A

$A$1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

*Which of the following error messages would appear if the cell reference is not valid?

A

REF!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

*Which of the following shows the location of the cell which you have selected?

A

Cell name box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

*Which tab and group in the Chart Tools section of the Ribbon contains the command to switch row and column data?

A

Design tab, Data group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

*Which of the following CANNOT be used as a math operator in a formula?

A

: colon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

*Which of the following is the correct formula to add cels A1 and B2

A

=A1+B2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

*Which tab and group on the Ribbon contains the option to add a header to a worksheet?

A

Insert tab, Text group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

*Which of the following formulas returns the current data and time?

A

=NOW( )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

*Which group on the Home tab contains the command for adding a filter?

A

Editing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

*Which of the following cell references is read as “cell A1 through D6?”

A

A1:D6

17
Q

*Which group on the Formulas tab holds the command to show the formulas in formula view?

A

Formula Auditing

18
Q

*Which of the following is NOT a viewing option for a worksheet?

A

Gridlines

19
Q

*Which of the following types is the CONCATENATE function?

A

Text

20
Q

*Which of the following is NOT a comparison operator?

A

/ slash

21
Q

*Which of the following finishes an entry based on previous entries made in the column containing the active cell?

A

AutoComplete

22
Q

*Which of the following can be used to copy the formatting applied to a cell?

A

Format painter

23
Q

*Which group on the Page Layout tab contains the commands to adjust the margins and page orientation of a worksheet?

A

Page Setup

24
Q

*Which of the following cell references is read as “cell A1 and D6?”

A

A1,D6

25
Q

*Backstage View can be reached by clicking on which tab of the Ribbon?

A

File

Biz Office Technology (12 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions