Font size
WorksheetsL-7 Ms-Excel
Total questions: 25
Worksheet time: 19mins
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
What is a sheet in Excel?
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
A single document that typically contains labels, values, formulas, functions, and graphical representations of data.
A single file that typically contains labels, values, formulas, functions, and graphical representations of data.
Name of the workbook is displayed in the ___________
Menu bar
Title bar or ribbon
Tool bar
option bar
Letters in Excel represent
rows
data
columns
functions
Numbers in the worksheet represent
data
columns
rows
functions
Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data
1. What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen
The past cell in a worksheet. It is indicated by a dark border onscreen
When starting a formula what is the first thing you type in the cell?
&
=
%
+
What is the Sum formula?
Sum( )
Sum( )=
=( )Sum
=Sum( )
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
For multiplying numbers in A1 AND B1,you use the following formula
=A1/B1
=A1*B1
A1%B1
A1*B1
When is a MS Excel Spreadsheet used?
Making a Drawing
When Reading
For Collecting Information
For Baking a Cake
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc
$A$1, $A$2, etc.
Which area in an Excel window allows entering values and formulas?
Standard tool Bar
Title bar
Formula Bar
None of the above
In Microsoft Excel, the file you create and edit is called:
A form
A ledger
A table
A workbook
A record
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
The bar where information appears as you input data is called ______________.
file bar
help bar
window bar
formula bar
