Upgrade to remove ads
Only $35.99/year

Computer Apps Excel Test

Terms in this set (21)

Where is the cell reference displayed of an active cell?
Name Box
Which key should be pressed to move to the first cell of a row?
Home
The GO TO box is opened by clicking the GO TO command on the Find & Select menu in the Editing group on which tab?
Home
How do you select non adjacent cells?
Press and hold the Ctrl key as you click or drag to select additional cells or ranges.
Are numbers right or left aligned by default?
Right Aligned
Are words right or left aligned by default?
Left Aligned
Which button on the home tab clears all the data from a cell?
Clear button in the editing group
To the right of which tab can you add another worksheet?
Sheet tab (click + button)
If you don't need a worksheet, you can delete it by _____ on the sheet tab to open the shortcut menu and then clicking Delete.
Right Clicking
Which workbook view is most commonly used?
Normal
When you insert a new column, where is it inserted?
to the left of the current selection
When you insert a new row, where is it inserted?
Above the current selection
What are font styles?
Variations in the shape or weight of a font's characters
What must all formulas begin with?
= sign
B4 is a relative or absolute reference?
Relative
Buttons to add pictures, clip art, shapes and smartart are located on which tab?
Insert tab
_____ are displayed horizontally and are numbered consecutively down the left side of the worksheet.
Rows
As you enter data in a cell, the data is displayed in the active cell and in the _______.
Formula bar
Which workbook view displays the worksheet as it will print so you can make any necessary changes?
Page Layout
What button allows you to copy the same formatting to other cells?
Format Painter
What type of te
...
Other sets by this creator