NEW
Font size
WorksheetsMS Excel for Managers
Total questions: 33
Worksheet time: 17mins
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
The first cell in a worksheet is what?
A1
1A
FX
Cell Name
What is a rectangular box in a MS EXCEL Spreadsheet called?
row
column
cell
What does every formula in MS EXCEL start with?
+
-
=
*
What is the name of the cell that is colored blue?
A
B
2B
B2
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
In Excel, rows are identified by this
Letters
Numbers
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
What function was used to find the highest data ?
AVERAGE
MIN
SUM
MAX
You are not able to open, save, rename and close a file in Excel the way you would in MS Word.
TRUE
FALSE
Columns go in what direction?
Vertical
Horizontal
Rows go in what directions?
Vertical
Horizontal
what is the default extension for an excel workbook
.doc
.txt
.exe
.ppt
.xls
How is the COLUMN in a MS Excel Spreadsheet named?
Numbers
Letters
Cells
Columns
What is an example of a RANGE in MS Excel.
B2-F5
F5:B2
B2:5F
(B2:F5)
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
What does every formula in MS EXCEL start with?
+
-
=
*
Microsoft Excel is categorize as ?
Word Processing Software
Database Software
Spreadsheet Software
Presentation Software
The function COUNT is specific for _________________
Counting cells
Counting text
Counting number
Counting tables
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
What is spreadsheet?
The cell address
The mouse pointer
The grid you see on the screen
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.
What is the Sum formula?
Sum( )
Sum( )=
=( )Sum
=Sum( )
For multiplying numbers in A1 AND B1,you use the following formula
=A1/B1
=A1*B1
A1%B1
A1*B1
