Excel Practice Test
What is the default file extension when you save a wordbook for Excel 2010?
.xlsx
Excel automatically adjust row height to accommodate the size of data in a row
True
Excel offers the "Spell Check" function
True
One method you can use to change a worksheet name is to go to the cells group on the Format tab, click Format and choose Rename Sheet.
True
You can cut and paste data from one cell into another. Instead of using the mouse to do the cut and paste, you can use the keyboard. To cut press _________; to paste, press ________
CTRL+X and CTRL+V
The shortcut key to "undo" an action in Excel 2010 is:
CTRL+Z
What keystrokes would you press to bring up "Excel Help" window?
F1
=A7+A9 will subtract the two cells?
False
A SmartArt graphic provides an audible representation of information
False
If you press the "Tab" key it moves one ell to the left
False
The "fill handle" is a small square in the lower-left corner of a selected cell or range of cells.
False
To delete a worksheet all you have to do is close the current wordbook and it is then deleted.
False
To use the Spell check function you go to the "View" tab on the ribbon.
False
When editing the "Margins" you can only edit the left and right side of the Worksheet
False
When you have selected a range of cells and then you press CTRL+P. Excel will automatically print the selected range.
False
You can insert a row by right clicking a column heading
False
You can rename the "sheet" tabs on the bottom left corner
False
You cannot copy a formula using "Autofill"
False
To add color to a row or column you click the
Fill color button(paint pail)
Excel provides the following functions to be used except:
HIGH
If you look at a worksheet and cannot see certain columns, it is probably because the worksheet has __ columns.
Hidden
Which function can you use to capture the contents of an open window?
Screenshot
"Values" can include numbers, formulas, and functions
True
An excel file is called a wordbook.
True
Before printing a worksheet, you should preview it and check for spelling errors. Completing these tasks before you print can save time and paper.
True
You can add Axis titles to a chart.
True
You can create mixed references by placing a dollar sign in front of only the column letter or only the row number
True
You can format text in a cell in Excel
True
You can modify the size of an image in Excel
True
You can move a chart in a wordbook from one sheet to another.
True
