Font size
WorksheetsBPED
Total questions: 20
Worksheet time: 14mins
How do you select an entire column?
Select Edit > Select > Column from the menu
Hold down the shift key as you click anywhere in the column.
Click the column heading letter.
Hold down the Ctrl key as you click anywhere in the column.
You can only work in one cell at a time. The actual cell that you are working in is called what?
Column
Active Cell
Name Box
Row
6. What is the term used where a column and row intersect?
Toolbar
Name Box
Cell
Formula Bar
Cells are identified by the following:
Column Letter followed by their Row Number
Row Number Only
Row Number followed by their Column Letter
Column Letter Only
. Which of the following is the correct formula to compute the 40% of total amount of shoes?
= B5*280*40%
= (B5*C5)*40
= (B5*C5) *.40
= B5/C5*40%
. In the picture, why is D2 through D5 placed in parenthesis?
So Excel knows to total the cells before performing the next operation.
So the calculation will be done last.
So the total of the cells can be multiplied rather than added.
So that we can get the 12 percent
If the parenthesis is removed, what will 12% be multiplied by?
E3+E4+E5
E3
E5
E4
The program that we use to create spreadsheets
MS Word
MS Paint
MS Excel
MS Excel?
Spreadsheet
Cell
Column
Row
Spreadsheet
Cell
Column headings
Row headings
Spreadsheet
Cell
Column headings
Row headings
Which one is a correct cell address?
A1
1A
A
1
What is the cell address of the black cell?
A1
1A
D3
3D
Division symbol in spreadsheet.
/
+
=
Multiplication symbol in Microsoft Excel
&
*
^
In Excel, columns are labeled by?
Numbers
Letters
When inserting a formula, always start with
equals symbol
plus symbol
minus symbol
What is the first cell in a worksheet named?
A1
1A
FX
Excel allows you to
read stories
work with data
draw the pictures
