Brainscape's Knowledge GenomeTM

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


See full index

Microsoft Excel > Lesson 9 & 10 > Flashcards

Lesson 9 & 10 Flashcards

1
Q

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a summary view of all of the first period classes. Which feature would allow him to do this?

A. Group
B. Collapse
C. Subtotal
D. Outline

A

B. Collapse

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

What is the process of bringing data containing text fields separated by commas into Excel called?

A. Importing data
B. Data collection
C. Data integration
D. Data migration

A

A. Importing data

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

Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?

A. Cell style
B. Conditional formatting
C. Fill color
D. Format as table

A

D. Format as table

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

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to know how many members are in the same first period class. Which feature would allow him to do this?

A. Group
B. Collapse
C. Subtotal
D. Outline

A

C. Subtotal

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

Joan has created a spreadsheet that displays sales of her employees. She would like to

view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that?

A. Ascending
B. Descending
C. Filter
D. Custom Filter

A

D. Custom Filter

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

David only wants to view the employees in the Marketing department who earn a salary of more than $25,000. What command should he use to complete this task?

A. AutoFill
B. Filter
C. Find and Replace
D. Sort

A

B. Filter

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

What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?

A. Styles
B. Alignment
C. Editing
D. Font

A

A. Styles

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

Which is a way to qualify data by specifying a matching condition or asking a question of the data?

A. Insert
B. Sort
C. Query
D. Probe

A

C. Query

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

Which command on the Home Ribbon do you use to organize data in ascending or descending order?

A. Find & Select
B. Format Cell
C. Sort & Filter
D. Organize

A

C. Sort & Filter

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

How do you quickly modify a table style to meet user preferences?

A. Right-click on a style and choose Modify.
B. Right-click on a style and choose Duplicate.
C. Double-click a style from the Table Quick Styles Gallery.
D. Choose Modify from the Styles Group on the Home Ribbon.

A

B. Right-click on a style and choose Duplicate.

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

Which ribbon includes the commands to apply a quick table style to a range of cells?

A. Home
B. Insert
C. Page Layout
D. Data

A

A. Home

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

David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task?

A. AutoFill
B. Filter
C. Find and Replace
D. Sort

A

D. Sort

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

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

A. Find & Select
B. Format Cell
C. Sort & Filter
D. Organize

A

C. Sort & Filter

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

Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?

A. Macro
B. Sort
C. Filter
D. Formula

A

B. Sort

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

Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?

A. Ascending
B. Descending
C. Primary Sort
D. Customer Filter

A

A. Ascending

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

Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use?

A. IF
B. AND
C. OR
D. NOT

A

B. AND

17
Q

Jessica needs to capitalize the first letter in each word. Which function would she use?

A. Trim
B. Proper
C. Upper
D. Lower

A

B. Proper

18
Q

James wants his spreadsheet to return true when the logical value is false. What function should he use?

A. IF
B. AND
C. OR
D. NOT

A

D. NOT

19
Q

Tom wants to convert all text to lowercase. Which function she he use?

A. Trim
B. Proper
C. Upper
D. Lower

A

D. Lower

20
Q

Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?

A. Trim
B. Proper
C. Upper
D. Lower

A

C. Upper

21
Q

Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?

A. FIND
B. SUBSTITUTE
C. VLOOKUP
D. SEARCH

A

B. SUBSTITUTE

22
Q

SUMIF and SUMIFS are in which category of functions?

A. Math & Trig
B. Text
C. Logical
D. Lookup & Reference

A

A. Math & Trig

23
Q

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?

A. SUMIF
B. AVERAGEIF
C. TOTALIF
D. COUNTIF

A

D. COUNTIF

24
Q

Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?

A. VLOOKUP
B. HLOOKUP
C. LOOKUP
D. SEARCH

A

B. HLOOKUP

25
Q

In Sam’s spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use?

A. Convert Text to Column Wizard
B. Split View
C. View Side by Side
D. Comma Delimited

A

A. Convert Text to Column Wizard

26
Q

IF, AND, OR and NOT are all part of which category of functions?

A. Math & Trig
B. Text
C. Logical
D. Lookup & Reference

A

C. Logical

27
Q

Jamal wants to average a range of cells in his spreadsheet. He would like Excel to

average only the cells in that range that are greater than 100 but less than 500. What function should he use?

A. SUMIFS
B. AVERAGEIFS
C. TOTALIFS
D. COUNTIFS

A

B. AVERAGEIFS

28
Q

James wants to use an advanced function to search his spreadsheet for a specific string in a text string?

A. FIND
B. SUBSTITUTE
C. VLOOKUP
D. REPLACE

A

A. FIND

29
Q

Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?

A. VLOOKUP
B. HLOOKUP
C. LOOKUP
D. SEARCH

A

A. VLOOKUP

30
Q

Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use?

A. SUMIF
B. AVERAGEIF
C. TOTALIF
D. COUNTIF

A

A. SUMIF

Microsoft Excel (5 decks)

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