WorksheetsBasics of MS Excel
Total questions: 21
Worksheet time: 2hrs 45mins
Write in a formula to add cells A2 and C4
(a)
Ctrl+C is the keyboard shortcut to do what?
cut
copy
close
center
In Excel, rows
are horizontal and represented by a letter
are horizontal and represented by a number
are vertical and represented by a number
are vertical and represented by a letter
What is the active cell?
A10
A11
A12
A13
In order to make a cell calculate what is entered, what must be entered first?
=
+
calculate
add
The active cell reference appears in the name box.
True
False
The horizontal placement of cells in a table or worksheet.
range
row
column
cell
Identify this cell (highlighted)
C2
A5
B3
E1
A group of selected cells is called the
Cell Block
Multi-cell
Range
What is this?
Column
Cell
Row
Cell address
What is this?
Column
Row
Cell address
Cell
What is the name of the cell?
G5
H5
F7
H6
Which keyboard shortcut bolds text in a cell?
CTRL X
CTRL U
CTRL B
CTRL I
What does the keyboard shortcut "Ctrl+Z" do?
Cut
Copy
Paste
Delete
Which key would you press to select random cells as shown?
Shift
Control
Escape
Backspace
The (a) is where you'll find the commands you need to perform common tasks in Excel.
The Ribbon contains multiple (a) , each with a group of commands.
Each workbook holds a (a) or more.
A___F___ options allows you to click and drag it to fill in cells that follow a known pattern; you know you're using this tool when your cursor is on the bottom right of a cell and is a skinny plus sign.
(a)
Which symbol represents the currency style?
$
,
%
