Microsoft Excel
Test
Model Test
Ebook
Index
Microsoft Excel Home
MS Excel Basics
46
Formatting Cells
7
Working with Formula
12
Editing Worksheet
3
Schools
Ebook
Question:
Each time you start the MS Excel program, by default, it displays a new blank workbook containing ______ blank worksheets.
A
Two
B
Three
C
Four
D
Five
Note:
Not available
Show answer
Show Note
Report
Question:
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ______
A
B1-G10
B
B1.G10
C
B1:G10
D
B1;G10
Note:
Not available
Show answer
Show Note
Report
Question:
Which of the following is an absolute cell reference?
A
!A!1
B
$A$1
C
#a#1
D
A1
Note:
Not available
Show answer
Show Note
Report
Question:
A worksheet can have a maximum of ______ number of rows.
A
256
B
1024
C
1048576
D
32000
Note:
Not available
Show answer
Show Note
Report
Question:
The default text data aligned within a cell of MS Excel Worksheet is ______
A
Left
B
Right
C
Centre
D
Justify
Note:
Not available
Show answer
Show Note
Report
Question:
There are three types of data found in a spreadsheet. These are ______
A
data, words, numbers
B
numbers, formulas, labels
C
equations, data, numbers
D
words, numbers, labels
Note:
Not available
Show answer
Show Note
Report
Question:
Which of the following symbols is used for entering a formula in MS Excel?
A
=
B
+
C
(
D
@
Note:
Not available
Show answer
Show Note
Report
Question:
In an MS Excel worksheet the active cell is indicated by ______
A
A dark wide boarder
B
A dotted border
C
A blinking border
D
None
Note:
Not available
Show answer
Show Note
Report
Question:
If you press ______, the cell accepts whatever you have typed as its contents.
A
Enter
B
Ctrl+Enter
C
Tab
D
Insert
Note:
Not available
Show answer
Show Note
Report
Question:
Which of the following formula has not been entered correctly?
A
=10+50
B
=B7*B1
C
=B7+14
D
10+50
Note:
Not available
Show answer
Show Note
Report
First
Prev
1
2
3
Next
Last
/7
Go
Schools
App Store
Whiteboard
Blogs
Quiz
Test
Apply Course
Games
Freelancers
Professionals
Newspapers
Terms
Privacy
Copyright © 2024. Powered by
Intellect Software Ltd