NEW
Font size
WorksheetsIntro to Excel
Total questions: 20
Worksheet time: 10mins
What is the primary purpose of a spreadsheet?
To create presentations
To organize, calculate, and analyze information
To write essays
To store images
What is a workbook in spreadsheet terms?
A single calculation page
A vertical column of cells
A file containing one or more spreadsheets
A horizontal row of cells
How are columns labeled in a spreadsheet?
With numbers (1, 2, 3…)
With symbols (#, @, &…)
With letters (A, B, C…)
With colors
What is the correct term for the intersection where a column and row meet?
Box
Grid
Range
Cell
Which of the following is a valid cell address?
1A
#2
J6
RED1
What is a range in spreadsheet terminology?
A single cell value
A group of selected cells
The distance between columns
The size of the worksheet
What is the correct format for expressing a range from cell A1 to A5?
A1-A5
A1:A5
A1>A5
A1&A5
Which term refers to text entered in a cell?
Value
Formula
Label
Function
What type of content is considered a "value" in a spreadsheet?
Letters
Symbols
Numbers
Formulas
What is the correct way to write a basic addition formula in a spreadsheet?
A1+B1
=A1+B1
ADD(A1,B1)
SUM:A1:B1
What are rows in a spreadsheet?
Vertical lines labeled with letters
Diagonal lines across the sheet
Horizontal lines labeled with numbers
Boxes containing formulas
What is a worksheet?
A complete spreadsheet program
A single sheet in a workbook
A collection of formulas
A group of cells
Which of the following is a function in spreadsheet terms?
A cell address
A text label
A built-in command
A range selector
What symbol typically starts a formula in a spreadsheet?
#
@
$
=
How is a SUM function typically written for cells A1 through A3?
ADD(A1:A3)
=SUM(A1:A3)
TOTAL(A1-A3)
=ADD(A1,A2,A3)
What is the difference between a formula and a function?
A formula is built-in, while a function is user-created
A formula uses math operators, while a function is a pre-built command
There is no difference
Functions can only add numbers, while formulas can do any math
Which describes a cell containing "Tanjiro"?
Value
Formula
Function
Label
How many worksheets were shown ?
2
3
4
5
What happens when you select column E?
All cells in row E are highlighted
All cells in column E are highlighted
Only cell E1 is selected
The entire spreadsheet is selected
Which is an example of a valid cell range for row 9?
9A:9F
C9:F9
9:9
ROW9
