NEW
Font size
WorksheetsEmTech_MSExcel_Q2_Quiz1
Total questions: 20
Worksheet time: 10mins
Which symbol is used to start a formula?
+
-
=
>
Which of the following formulas show the correct use of the SUM function?
-SUM(H3-H10)
=SUM(H3:H10)
=SUM(H3...H10)
+SUM(H3:H10)
See the following formula. Which of the following formula is the another method of the given formula?
=(B2+C2+D2+E2)/4
= SUM (B2,C2,D2,E2)
= MAX(B2:E2)
= SUM(B2,E2/4)
= AVERAGE (B2:E2)
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
If you type =2*(6-4) in cell A1, what will be the display value?
2
4
6
8
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on
row
column
label
cell address
In a worksheet, the vertical spaces with the headings A, B, C and so on
row
column
label
cell address
Excel documents are stored as files called
Workgroup
Worktable
Worksheets
Workforce
What is an example of a RANGE in MS Excel.
B2-F5
F5:B2
B2:5F
(B2:F5)
How is the COLUMN in a MS Excel Spreadsheet named?
Numbers
Letters
Cells
Columns
How are ROWS in MS EXCEL spreadsheet named?
numbers
letters
cells
columns
What is a rectangular box in a MS EXCEL Spreadsheet called?
row
column
cell
What is the symbol for division when using MS EXCEL.
/
+
*
-
What is the name of the cell that is colored blue?
A
B
2B
B2
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
Every column has its own alphabet for identity, from A
to ____________.
XFD
CCC
DDD
XYX
Every row has its own number for identity, from 1
to ____________.
1048275
1048358
1048576
1048765
What are the sheets named by default?
Sheet1, Sheet2 and Sheet3
Page1, Page2 and Page3
Slide1, Slide2 and Slide3
