NEW
Font size
WorksheetsMicrosoft Excel 6th grade Test 3
Total questions: 25
Worksheet time: 13mins
In a worksheet, rows run vertically and are labeled with a letter; columns run horizontally and are labeled with a number.
True
False
In a worksheet, you can create or edit text in the formula bar.
True
False
Gridlines and row/column headings may or may not be printed on a spreadsheet.
True
False
When you use the Clear command to clear the contents of a cell, the surrounding cells are shifted to replace the cleared cell.
True
False
The cut and copy features in spreadsheet software work much the same as the cut and copy features in word processing software.
True
False
You can copy a range of cells, but you cannot cut a range of cells.
True
False
The __________ feature enables you to change information already entered in a cell.
Worksheet
Active
Scroll
Edit
The cells in a spreadsheet are arranged in columns and rows on a(n) __________.
Worksheet
Active
Scroll
Edit
The __________ cell of a worksheet is the cell with the thick border around it; this is the cell in which information is entered.
Worksheet
Active
Scroll
Edit
To delete a cell in a worksheet, click the drop arrow next to delete and click
Delete cells
Delete Sheet Rows
Delete Sheet Columns
Delete Sheet
The __________ deletes the contents AND format of a cell.
Edit Command
Delete Command
Clear Command
Delete Key
Spreadsheet data that is to be used in calculations must be entered as a
values
labels
What is the definition of copy?
duplicated to another cell or range of cells leaving the original text unchanged
move selected text from the current location
move and copy to another cell or range of cells
To clear contents in a cell, click the drop arrow next to clear and click
Clear All
Clear Formats
Clear Contents
What is the definition of paste?
move selected text from the current location
move and copy to another cell or range of cells
duplicated to another cell or range of cells leaving the original text unchanged
What is the definition of cut?
move selected text from the current location
move and copy to another cell or range of cells
duplicated to another cell or range of cells leaving the original text unchanged
To delete a row in a worksheet, click the drop arrow next to delete and click
Delete Cells
Delete Sheet Rows
Delete Sheet Columns
Delete Sheet
To select a range of cells,
highlight the cell in one corner, hold down the left mouse button, and drag to the cell in the opposite corner.
highlight the cell in one corner, hold down the right mouse button, and drag to the cell in the opposite corner.
double-click the cell in one corner with the left mouse button, then double-click the cell in the opposite corner.
double-click the cell in one corner with the right mouse button, then double-click the cell in the opposite corner.
f you want to display a date in a certain way (such as Wednesday, March 25, 2015), you can adjust the ________.
Number format
font
autofill
cell color
Format cells as ______________ when working with amounts of money.
currency
number
percent
scientific
Which of these are NOT number formats in Microsoft Excel?
Roman Numerals
Percentage
Currency
Accounting
Which of the following is the correct way to refer to a range of cells?
A1C12
A1;C12
A1,C12
A1:C12
Microsoft Excel is what type of software?
Word Processing
Spreadsheet
Presentation
Database
A style that display numbers with a comma
thousand separator
$
range
%
A style that displays decimal numbers as a percent.
Accounting
Currency
Number
Percentage
