No student devices needed. Know more
20 questions
You can automatically adjust a column width to "fit" the content by:
clicking the column heading
clicking the row heading
double-clicking between the two column headings
double-clicking between the two cells
Combining multiple cells in your spreadsheet is called:
formatting
aligning
merging
mixing
What special formatting can you use to set your information apart from the other cells on your spreadsheet?
Currency formatting
Date & time formatting
Sorting & filtering
Borders & color shading
Instead of resizing your column to accommodate your content, what can you use to fit your content to the size of the cell?
Paint formatting
Text wrapping
Filtering
Sorting
What can the Autofill handle do?
Copy cell content and/or populate cells with series (pre-defined or sequential) of content
Copy cell content
Populate cells with series (pre-defined or sequential) of content
Overwrite copied content
What commands will change the amount of numbers shown to the right of the decimal point?
Increase/Decrease Decimal
Increase/Decrease Indent
Align Left and Right
Format Percent
What formatting tool adds a dollar symbol, a comma separator and two default decimal places to a number?
Percent
Currency
Comma
Increase Decimal
What keyboard shortcut will select all the cells in a spreadsheet?
Shift + A
Ctrl + A
Alt + A
Tab + A
Using your mouse, you can click a single cell to select it or click and drag your pointer across a range of cells to select multiple cells. You can select random cells anywhere on the spreadsheet by holding down the ________ key and clicking each cell.
Shift
Ctrl
Alt
Enter
When entering text into a cell, your spreadsheet program automatically aligns your text to:
the left side of the cell
the top of the cell
the right side of the cell
the bottom of the cell
When entering numbers into a cell, your spreadsheet program automatically aligns your numbers to:
the left side of the cell
the top of the cell
the right side of the ell
the bottom of the cell
How can users customize spreadsheets to only display specific criteria?
Copy the data
Filter the data
Align the data
Sort the dara
Which of the following is the correct reference for a cell range?
A2...E15
F15-J28
B2;F30
A7:D20
What keyboard shortcut always moves the cursor into cell A1?
Shift + Home
Shift + A
Ctrl + Home
Crtl + 1
Which format would be recommended for a cell that contained the data 1/24/2015?
Time
Date
Number
Currency
Which of the following will place data in a specific order?
Sorting
Centering
Filtering
Copying
Which of the following is an example of a cell reference?
Column C
=SUM
Row 1
A5
Spreadsheet columns are easily identified by:
Roman numerals
numbers
letters
colors
Spreadsheet rows are easily identified by:
numbers
letters
Roman numerals
colors
A spreadsheet program is used to store data in:
a database
a text document
rows and columns
letters and numbers
Explore all questions with a free account