Font size
WorksheetsMS Excel
Total questions: 16
Worksheet time: 5mins
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
Workbook is made up of -----------------------
(a)
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.
Each spreadsheet is made up of ____________ and ______________
(a)
Name of the workbook is displayed in the ___________
Menu bar
Title bar or ribbon
Tool bar
option bar
The name box or the address bar contains
Formulas
menu options
Cell address
Numbers
Formula applied to a cell appears in the (a)
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( )
To quickly add a set of number you can use the ____ feature?
Plus Sum Button
Add Sum Button
Quick Add Button
Auto Sum Button
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
