if a cell has a two digit year of 32 , Excel automatically changes it to a four digit of ?
What is 1983
100
To instruct Excel to display a hidden column, position the mouse pointer to the ?
What is Right of the column heading boundary where the hidden column is located and then drag to the right s
100
in the print dialog box the __________ instructs excel to print the selected range
What is select option button
100
To import data stored on a Web site use a _______ ?
What is Web query
100
Used for importing into Excel data that is stored on a Web site
what is web query
200
what are the valid arithmatics operaters ?
What is - % ^ * / +
200
with column widths, when you decrease the row height to 0, the row is
What is hidden
200
In the Print dialog box shown in the accompanying figure, the ____________ instructs Excel to print all the worksheets with content in the workbook.
What is entire workbook option button
200
Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another _________ in the workbook.
What is worksheet
200
When more than one arithmetic operator is involved in a formula, Excel follows an order from left to right in a formula calculation
What is order of operations
300
when Excel follows the order of operations, the formula , 8*3+2 equals
What is 26
300
To check the spelling of the text in a single cell, to make the formula bar active and then click the Spelling button on the Review tab on the Ribbon.
What is double-click the cell
300
.Excel does not display the Print dialog box shown in the accompanying figure when the ____ is used
What is print button on quick access toolbar
300
What name does Excel give the first blank worksheet?
What is sheet1
300
A predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.
What is theme
400
how do activate range finder to verify a formula in a cell
What is double click in 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
What is 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.
What is Zoom
400
Longer worksheet names also can mean that _______ sheet tabs will show.
What is fewer
400
A dot on the screen that contains a color and its size is based on the screen’s resolution
What is pixel
500
the width of the column will be increased or decreased so the widest entry will fit in the column.
What is best fit
500
Which view allows you to create or modify a worksheet while viewing how it will look in printed format?
What is Page Layout View
500
toggle between the values version and the formulas version of a worksheet, hold down the ___________ key
What is _ CTRL key while pressing the ACCENT MARK (`)
500
emailing a workbook from Excel sends the workbook as a(n) ??
What is attachment
500
If true, then Excel applies the formatting. If false, then Excel suppresses (or omits) the formatting