Category 1
Category 2
Category 3
Category 4
Category 5
100
If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of?
1932
100
instruct Excel to display a hidden column, position the mouse pointer to the_________
Right of the column heading boundary where the hidden column is located and then drag to the right
100
_____ instructs Excel to print the selected range
Selection option button
100
To import data stored on a Web site use a?
Web query
100
Used for importing into Excel data that is stored on a Web site
Web query
200
_____are valid Excel arithmetic operators
- % ^ * / +
200
As with column widths, when you decrease the row height to 0, the row is?
Hidden
200
__________instructs Excel to print all the worksheets with content in the workbook
instructs Excel to print all the worksheets with content in the workbook
200
Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another?
worksheet in the work book
200
When more than one arithmetic operator is involved in a formula, Excel follows an order from left to right in a formula calculation.
Order of operations
300
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals?
26
300
To check the spelling of the text in a to make the formula bar active and then click the Spelling button on the Review tab on the Ribbon_____
single cell
300
Excel does not display the Print dialog box shown in the accompanying figure when the ___________
Print button on the Quick Access Toolbar is used
300
What name does Excel give the first blank worksheet?
Sheet 1
400
How do you activate Range Finder to verify a formula in a cell?
double click the cell
400
If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks__________
the remainder of the worksheet, including notes and embedded charts
400
The ___ button, in the accompanying figure, allows you to view the page in larger or smaller sizes in the Preview window.
Zoom
400
Longer worksheet names also can mean that ?
Fewer tabs will show
400
A dot on the screen that contains a color and its size is based on the screen’s resolution.
Pixel
500
_____means that the width of the column will be increased or decreased so the widest entry will fit in the column.
Best fit
500
Which view allows you to create or modify a worksheet while viewing how it will look in printed format?
Page layout veiw
500
toggle between the values version and the formulas version of a worksheet, hold down the
CTRL key while pressing the ACCENT MARK (`)
500
E-mailing a workbook from Excel sends the workbook as a(n) _____ the e-mail.
Attacthment.
500
If true, then Excel applies the formatting. If false, then Excel suppresses (or omits) the formatting.
Condition
Continue
ESC
Reveal Correct Response
Spacebar
M
e
n
u
Team 1
0
+
-
Excel Review
No teams
1 team
2 teams
3 teams
4 teams
5 teams
6 teams
7 teams
8 teams
9 teams
10 teams
Custom
Press
F11
Select menu option
View > Enter Fullscreen
for full-screen mode
Edit
•
Print
•
Download
•
Embed
•
Share
JeopardyLabs