Font size
S
M
L
XL
WorksheetsMicrosoft Excel - Rows, Columns & Cells
Total questions: 20
Worksheet time: 18mins
Name
Class
Date
1.
The letters in Excel represent the...
a)
Rows
b)
Columns
c)
Cells
d)
Data
2.
The numbers in Excel represent the...
a)
Rows
b)
Columns
c)
Cells
d)
Data
3.
What is the cell in the worksheet in which you can type data?
a)
Main cell
b)
Open cell
c)
Active cell
d)
Absolute cell
4.
The intersection of a row and column.
a)
column
b)
row
c)
cell
d)
active cell
5.
The set of data that runs up and down in a spreadsheet
a)
column
b)
row
c)
cell
d)
active cell
6.
Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.
Which of the following suggestions would help Luisa?
Which of the following suggestions would help Luisa?
a)
Make the cell wider
b)
Change the number formatting in the cell
c)
Change the font format in the cell
d)
Delete the data and re-type it
7.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
8.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
9.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
10.
Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.
a)
Enter Keys
b)
Arrow Keys
c)
Piano Keys
d)
Tab Key
11.
The cell address of the highlighted cell is
a)
C
b)
4
c)
A4
d)
C4
12.
These are known as
a)
workbooks
b)
worksheets
c)
formula bar
d)
cell
13.
What does the indicated icon do in the red box?
a)
Apply underline
b)
Apply italic
c)
Make text bigger
d)
Apply bold
14.
A formula in the spreadsheet should always start with
a)
a plus sign
b)
an asterisk
c)
an equals sign
d)
a capital letter
15.
Which of these would add up the numbers from A3 to A6
a)
+(A3:A6)
b)
=(A3:A6)
c)
=(Ave(a3:a6))
d)
=Sum(A3:A6)
16.
What are lines that can be applied around worksheet cells or objects?
a)
Gridlines
b)
Borders
c)
Underlines
d)
Boundaries
17.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
18.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
19.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
a)
false
b)
true
20.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
Reset
