Microsoft Excel Trivia Quiz Questions!
Settings
-
+
- 1.The Shortcut keyborad for COPY ?
- A.
CTRL+V
- B.
CTRL+P
- C.
CTRL+C
- D.
CTRL+Z
- 2.The shortcut keyborad to CUT text ?
- A.
CTRL+X
- B.
CTRL+C
- C.
CTRL+V
- D.
CTRL+B
- 3.The icon in red box is refer to
- A.
Show/Hide Formatting Marks
- B.
Formatting Text
- C.
Remove text effects
- D.
Format Painter
- 4.The icon in red box is refer to
- A.
Adding text effects
- B.
Format Painter
- C.
Change Text Case
- D.
Remove text effects
- 5.The type of font
- A.
Arabstyle
- B.
Arial
- C.
Calibri (Body)
- D.
Calibri
- 6.How many rows in this table ?
- A.
7
- B.
3
- C.
14
- D.
1
- 7.The Direction of type
- A.
From right to left
- B.
From left to right
- 8.Size of font
- A.
34
- B.
48
- C.
4
- D.
72
- 9.We apply ........ in text
- A.
Bold
- B.
Italic
- C.
Underline
- D.
Non Of Above
- 10.How many number of sheet
- A.
1
- B.
4
- C.
566
- D.
3
- 11.The type of view
- A.
Print layout
- B.
Drift view
- C.
Normal Niew
- D.
Full secreen Reading
- 12.The orientation apply in page
- A.
Portrait
- B.
Landscape
- 13.The extension of any type of word
- A.
XLSX
- B.
PPX
- C.
DOCX
- D.
PUB
- 14.When typing text in word you should press ENTER at the end of a: When typing text in word you should press ENTER at the end of a:
- A.
Line
- B.
Page
- C.
Paragraph
- D.
Document
- 15.To select a single word :
- A.
Press F8 three times
- B.
Press CTRL and click the word
- C.
Press CTRL + W
- D.
Double click the word
- 16.Which tab would you choose to change the font size of a word from 12 points to 18 points?
- A.
File
- B.
Home
- C.
Insert
- D.
Page Layout
- 17.If you want to add a table to your document, which tab would you choose?
- A.
File
- B.
Home
- C.
Insert
- D.
Save
- 18.You insert a clip art and it is too big. To resize it you would.
- A.
Change it the same way you change the font size
- B.
Click the insert tab and choose resize
- C.
Click the Home tab and choose resize
- D.
Click on the clip art to show the handles anddrag a handle to resize it
- 19.The format of the active part of the document is :
- A.
Page 1 , Sec 1 , 1/1
- B.
Normal , Times New Roman , size 14
- C.
Normal , Times New Roman , size 12
- D.
A+B
- 20.The name of the document is:
- A.
Computer Skills.doc
- B.
Computer Skills
- C.
Computer Skills.pdf
- D.
Computer Skills.dox
- 21.The total number of rows in microsoft excel
- A.
24
- B.
1,048,576
- C.
16,384
- D.
155
- 22.The Range Is select
- A.
1 cell
- B.
2 cell
- C.
5 cell
- D.
None OF Above
- 23.How many rows we select
- A.
3 x 3
- B.
3
- C.
6
- D.
4
- 24.If you see pound signs (#######) in a cell, it means
- A.
The row is very height
- B.
The column is very width
- C.
The number of cell is larg
- D.
The column is not wide enough to display the cell content
- 25.To unhide a column we
- A.
Select the columns on Before side of the hidden column
- B.
Select the columns on between side of the hidden column
- C.
Select the columns on either side of the hidden column
- D.
Select the columns on Top side of the hidden column
- 26.The Type of This Chart is
- A.
Column
- B.
Line
- C.
Pie
- D.
Par
- 27.The type of this chart is
- A.
Column
- B.
Pie
- C.
Line
- D.
Par
- 28.In Excel the intersection of a column and a row is called :
- A.
Range
- B.
Block
- C.
Selection
- D.
Cell
- 29.What is the shorter way of computing =C1+C2+C3+C4+C5+C6+C7+C8 ?
- A.
TOTAL (C1:C8)
- B.
AVERAGE (C1:C8)
- C.
SUM (C1:C8)
- D.
COUNT (C1:C8)
- 30.On a Chart, what is used to indicate what each color or symbol stands for ?
- A.
A data series
- B.
The X-axis
- C.
Legend
- D.
A category
- 31.Writing an incorrect formula that attempts to perform math by referring to a text entry causes excel to display what in the formula cell ?
- A.
ERROR
- B.
#VALUE
- C.
#####
- D.
D.!!!!!
- 32.How many cells are included in the range A1:B3?
- A.
2
- B.
9
- C.
8
- D.
6
- 33.Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are
- A.
8,16,32
- B.
2, 4, 2
- C.
2, 2, 2
- D.
6,8,10
- 34.The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is:
- A.
D4+C2*B2
- B.
= (D4+C2*B2
- C.
(D4+C2)*B2
- D.
(B2*(D4+C2)
- 35.Resulting from this equation
- A.
0
- B.
777
- C.
10001
- D.
1000
- 36.Resulting from this equation
- A.
4
- B.
1000
- C.
777
- D.
0
- 37.Resulting from this equation
- A.
84
- B.
80
- C.
85
- D.
86
- 38.Resulting from this ( IF )equation
- A.
B2=B3
- B.
8=99
- C.
DIV BY ZERO
- D.
NON Of Above
- 39.Resulting from this equation
- A.
9
- B.
22
- C.
8
- D.
8/99
- 40.Resulting from this (IF) equation
- A.
A2/A3
- B.
" DEV BY ZERO "
- C.
DEV BY ZERO
- D.
66
Back to top