NEW
Font size
WorksheetsICT Review
Total questions: 20
Worksheet time: 10mins
1. What is a spreadsheet?
A computer program used for creating and managing spreadsheets
A piece of paper used for recording numerical data
A database management system
A graphical user interface
What is the default file format for Microsoft Excel?
.docx
.pptx
.xlsx
1. Which of the following is NOT a way to reference a cell in a formula?
A1
B2
C3
1A
Which of the following is not a valid way to enter data into a cell in a spreadsheet?
Typing in the data
Copying and pasting the data
Dragging and dropping the data
Using the voice input feature
What is the name of the area in the Excel window that displays the current zoom level and allows you to adjust it?
Formula Bar
Status Bar
Name Box
Zoom slider
Which symbol is used to begin a formula in a spreadsheet program?
%
&
@
=
Which of the following is a tool used to format numbers, currency, and dates in Excel?
Sort
Filter
Conditional Formatting
Formal Cells
Which of the following is a tool used to add borders, shading, and colors to cells in Excel?
Sort
Filter
Conditional Formatting
Format cells
Which of the following is a tool used to display data in a chart or graph in Excel?
Sort
Filter
Conditional Formatting
Charts
You have a table with multiple columns and rows, and you want to highlight the entire row when the value in column A is greater than 50. Which of the following formatting options would you use?
Conditional Formatting
Number Format
Fill Color
Font
You want to add a picture as a background to a worksheet. Which of the following formatting options would you use?
Themes
Styles
Effects
Backgrounds
You want to merge two cells together in Excel. Which of the following formatting options would you use?
Merge and Center
Center Across Selection
Merge Cells
Wrap Text
You have a large worksheet with multiple cells containing text. You want to check the spelling in all of the cells at once. Which of the following options would you use?
Spell Check
Find and Replace
Data Validation
Conditional Formatting
You have a cell that is marked as a misspelled word by the spell check, but you want to keep the word as it is. Which of the following options would you use?
Ignore
Ignore All
Add to dictionary
Change
You want to print the worksheet on a single page, but the chart and some of the cells spill over to the next page. Which print option would you use to fix this?
Scale to fit
Page Orientation
Margins
Paper size
What is the keyboard shortcut for pasting data in a spreadsheet?
Ctrl+C
Ctrl+V
Ctrl+X
Ctrl+M
Which function is used to calculate the average value of a range of cells in a spreadsheet program?
MAX
AVERAGE
MIN
SUM
Which of the following formula examples is correctly formatted to subtract the value in cell B1 from the value in cell A1?
A1-B1
B1-A1
A1/B1
B1/A1
Which of the following is an example of an absolute cell reference in a formula?
$A$1
A$1
$A1
A1
Which of the following is not a common spreadsheet program?
Microsoft Excel
Adobe Photoshop
Google Sheets
Apple Numbers
