WorksheetsWorking in MS Excel
Total questions: 12
Worksheet time: 6mins
Microsoft Excel is what kind of software?
Word Processing Software
Presentation Software
Database Software
Spreadsheet Software
What is a rectangular box in a MS EXCEL Spreadsheet called?
row
box
cell
column
What does every formula in MS EXCEL start with?
=
*
-
+
What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol?
ALL
SUM
ADDING
None at all
What is an example of a RANGE in MS Excel?
B2-F5
(B2:F5)
F5:B2
B2:5F
Located on the left side or the entry bar, displays the active cell name?
entry bar
name box
cell reference
none of the above
This shows you what’s in the active cell.
title bar
name box
group
formula bar
If you see the following, what does it mean? ######
the formula has an error
text was entered where numbers should be
the contents are too small to display
the contents are too large to display
A combination of numbers and symbols used to express a calculation.
Active Cell
Formula
Formula Bar
Label
Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook.
Sheet Tabs
Drag
Workbook
Function
When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series.
AutoSum
Ctrl+C
Fill Handle
Custom Fill
There are three types of data found in a spreadsheet.
data, words, labels
numbers formulas, labels
values, formulas, labels
equations, data, numbers
