NEW
Font size
WorksheetsMidterm 2 - G3
Total questions: 20
Worksheet time: 10mins
What is this?
Column
Cell
Row
Cell reference
What is this?
Column
Cell
Row
Cell reference
What is this?
Column
Cell
Row
Cell reference
What is this?
Column
Cell
Row
Cell reference
What is the name of the column?
Column D
Column E
Column F
Column G
What is the name of the row?
Row 2
Row 4
Row 6
Row 8
What is the name of the cell?
6C
C6
H5
F6
What is the icon in MS Excel?
Columns are named using _______?
letters
numbers
cells
letters and numbers
Rows are named using _______?
letters
numbers
cells
letters and numbers
Which formula is the correct answer for B4?
=B1+B2+B3
B1+B2+B3=
=B2+B4
=A1+A2+A3
In a spreadsheet formula, which symbol is used to multiply?
x
/
+
*
What is displayed in cell A6?
Monday
Tuesday
Wednesday
Thursday
Where is the formulas bar?
1
2
3
4
Which one of the following is correct?
=SUM(D2:D8)
=SUMB2:B8
SUM(D2-D8)=
SUM(A2-A8)
When inserting a formula, always start with ...
/
*
=
+
Which one is a column chart?
Which icon is used for AutoSum?
Which one of the following is correct?
=SUM(A2:F8)
=SUM(A2:D8)
=SUMA2:G8
=SUM(A2:F2)
Which tab is used to create a column chart?
File
Home
Insert
Page Layout
