NEW
Font size
S
M
L
XL
WorksheetsExcel Question 195-207
Total questions: 23
Worksheet time: 12mins
Name
Class
Date
1.
What is the process of viewing a PivotTable report for a subset that meets the criterion only?
a)
Filtering
b)
Sorting
c)
Positioning
d)
Arranging
2.
What term refers to an Excel Chart with offset pieces for emphasis?
a)
Exploded
b)
Shattered
c)
Separated
d)
Detached
3.
David wants to change all occurrences of 'North Carolina' to 'NC' in his spreadsheet. What command should he use to complete this task?
a)
AutoFill
b)
Filter
c)
Find and Replace
d)
Sort
4.
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)
None OF the above
5.
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
a)
Freeze
b)
Split
c)
Page Break
d)
Hide
6.
Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?
a)
=D4+F4
b)
=D4*F4
c)
=D4 x F4
d)
=D4-F4
7.
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
8.
Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?
a)
Delete
b)
Remove
c)
Format
d)
Format as Table
9.
How would sheet tabs be moved to a new position in the workbook?
a)
Choose Move on the Home Ribbon
b)
Click and drag the sheet tab to the new location
c)
Choose Move on the Insert Ribbon
d)
Choose Relocate on the Quick Access Toolbar
10.
What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
a)
Mini Toolbar
b)
Quick Access Toolbar
c)
Shortcut Menu
d)
Shortcut Toolbar
11.
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 she use?
a)
SUMIF
b)
AVERAGEIF
c)
TOTALIF
d)
COUNTIF
12.
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
a)
Paste
b)
Move
c)
Cut
d)
Copy
13.
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
a)
Function Library
b)
Defined Names
c)
Formula Auditing
d)
Calculation
14.
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
15.
Which are valid Microsoft Excel functions?
a)
AVERAGE, MAX, and NUM
b)
MAX, MIN, and WEEK
c)
AVERAGE, MAX, and MIN
d)
WEEKDAY, MAX, and CLOSE
16.
Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?
a)
Font
b)
Orientation
c)
Wrap Text
d)
Merge & Center
17.
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
a)
Freeze Panes
b)
Split
c)
Hide
d)
Unhide
18.
Lilly is making changes to a spreadsheet created by her FBLA advisor. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should be used?
a)
New
b)
Delete
c)
Edit Comment
d)
Show Ink
19.
Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
a)
Freeze
b)
Header
c)
Hide
d)
Scale
20.
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
21.
Ken has inserted a picture into his spreadsheet and would like it to standout with a frame or 3D effect. Which tool would he use to achieve this?
a)
Picture Styles
b)
Artistic Effects
c)
Corrections
d)
WordArt Styles
22.
Alicia needs to delete the data in cell B5. Which command would she select?
a)
Clear
b)
Copy
c)
Cut
d)
Format Painter
23.
What area contains the command used to customize the print options in Microsoft Excel?
a)
Home Ribbon
b)
Page Layout Ribbon
c)
File Tab
d)
Quick Access Toolbar
Reset
