Font size
WorksheetsTwisted Brain
Total questions: 10
Worksheet time: 5mins
NAME 2 ACTIONS THAT YOU CAN PERFORM IN FILTER
UNIQUE FILTER
FILTER IN PLACE
CRITERIA AREA
FILTER RESULT ELSEWHERE
When Jackson is entering text in Excel, it is automatically (by default):
Left Justified
Right Justified
Center Justified
Full Justified
In a project presentation, which view do you need to work in to add a header?
Normal View
Page Layout view
Header/Footer view
Page Setup View
Which of the following starts off with open, undo, and can be customized to contain the commands you use most frequently?
a worksheet
the help window
the quick access toolbar
the ribbon
What would be the fastest way to navigate to cell D80?
In the vertical scroll bar, click down scroll arrow till you reach cell D80
Press Page Down
In the Name Box, type D80 and press Enter
In the Formula Bar, type D80 and press Enter
To create a Named Range, select the range and ___________
Right-click and choose Range Name
Click in the Name Box, type the name, and press Enter
Choose Insert ➡ Range Name
Click the drop-down arrow next to the Name Box and select the name
To convert a normal data range into Excel Table, you can ____________
press Ctrl + -
press Ctrl + F
press Ctrl + S
press Ctrl + T
To link a cell to another worksheet, you need to type...
Type the name of the worksheet and the cell reference
Type = and click on the other worksheet and select the cell to link to
Type = and click on the other worksheet or cell
I don't know
What is the first thing you must do before adding Subtotals to your worksheet?
Format your data with Fill Color
Assign filters to the column you want to use as subtotal
Sort the values of the column you want to use as subtotal
Nothing
