Font size
WorksheetsExcel Time Pass 3
Total questions: 20
Worksheet time: 11mins
The name box or the address bar contains
Formulas
menu options
Cell address
Numbers
Letters in Excel represent
rows
data
columns
functions
Numbers in the worksheet represent
data
columns
rows
functions
When starting a formula what is the first thing you type in the cell?
&
=
%
+
What is the Sum formula?
Sum( )
Sum( )=
=( )Sum
=Sum( )
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
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
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
Each spreadsheet is made up of ____________ and ______________
(a)
To quickly add a set of number you can use the ____ feature?
Plus Sum Button
Add Sum Button
Quick Add Button
Auto Sum Button
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.
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
Name of the workbook is displayed in the ___________
Menu bar
Title bar or ribbon
Tool bar
option bar
Formula applied to a cell appears in the (a)
Workbook is made up of -----------------------
(a)
For multiplying numbers in A1 AND B1,you use the following formula
=A1/B1
=A1*B1
A1%B1
A1*B1
