MS Excel Basics, Microsoft Excel

MS Excel Basics

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
1. 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
1. 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
1. Report
Question: A worksheet can have a maximum of ______ number of rows.
A
256

B
1024

C
1048576

D
32000

Note: Not available
1. 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
1. 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
1. Report
Question: Which of the following symbols is used for entering a formula in MS Excel?
A
=

B
+

C
(

D
@

Note: Not available
1. 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
1. 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
1. 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
1. Report

First Prev 1 2 3 Next Last

Question: Each time you start the MS Excel program, by default, it displays a new blank workbook containing ______ blank worksheets.

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 ______

Question: Which of the following is an absolute cell reference?

Question: A worksheet can have a maximum of ______ number of rows.

Question: The default text data aligned within a cell of MS Excel Worksheet is ______

Question: There are three types of data found in a spreadsheet. These are ______

Question: Which of the following symbols is used for entering a formula in MS Excel?

Question: In an MS Excel worksheet the active cell is indicated by ______

Question: If you press ______, the cell accepts whatever you have typed as its contents.

Question: Which of the following formula has not been entered correctly?