NEW
Font size
WorksheetsICT Spreadsheets Lesson 1 Quiz
Total questions: 25
Worksheet time: 13mins
A spreadsheet program is used to store data in:
a database.
a text document.
rows and columns.
letters and numbers.
Spreadsheet rows are easily identified by:
numbers.
letters.
Roman numerals.
colors.
Roman numerals.Spreadsheet columns are easily identified by:
Roman numerals.
numbers.
letters.
colors.
Which of the following is an example of a cell reference?
Column C
=SUM
Row1
A5
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
How can users customize spreadsheets to only display specific criteria?
Copy the data
Filter the data
Align the data
Sort the data
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
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 cell.
the bottom of the cell.
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.
ShiftUsing 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
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
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 and time formatting
Sorting and filtering
Borders and color shading
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
You can automatically adjust a column width to “fit” the content by:
clicking the column heading.
clicking the row heading.
double-clicking between two column headings.
double-clicking between two cells.
What keyboard shortcut will select all the cells in a spreadsheet?
Shift + A
Ctrl + A
Alt + A
Tab + A
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
Ctrl + 1
Study the highlighted cells in the image below and identify which of the following represents the correct cell address for these cells:
What is the purpose of the Quick Access Toolbar (circled in orange in the image below)?
Study the section of a worksheet in the image below. What is the cell address of the cell containing the word "Qtr3"?
