Spreadsheet Software Basics Quiz Form
Test your knowledge of spreadsheet software basics. All questions are required. Please answer each to the best of your ability.
Which function is commonly used to calculate the sum of a range of cells?
*
SUM
AVERAGE
COUNT
MAX
What symbol is used to start a formula in most spreadsheet software?
*
=
+
-
/
How do you reference cell B2 in a formula?
*
B2
2B
$B$2
B:2
Which shortcut is typically used to copy selected cells?
*
Ctrl + C
Ctrl + V
Ctrl + X
Ctrl + Z
What does the 'Fill Handle' allow you to do in a spreadsheet?
*
Copy or extend cell contents
Sort data
Insert new rows
Format cells
Which of the following is NOT a valid data type in spreadsheet cells?
*
Image
Number
Text
Date
What is the default file extension for Microsoft Excel workbooks?
*
.xlsx
.docx
.pptx
.pdf
Name a common function used to find the average value of a range of numbers.
*
How can you freeze the top row in most spreadsheet software?
*
Use the 'Freeze Panes' option
Sort the data
Apply a filter
Change the font
In spreadsheet software, what feature allows you to quickly total a column of numbers with one click?
*
AutoSum
Pivot Table
Data Validation
Conditional Formatting
Submit Quiz
Should be Empty: