My Ribbon has disappeared - how can I get it back?
a.
Right-click on one of the tabs and untick Collapse the Ribbon
b.
Switch to another
... [Show More] worksheet.
c.
Excel crashes, you have to reinstall.
d.
Close Excel and open it again.
a
QN=3
After entering data into a cell, which option(s) will move your cursor into the next cell underneath your active cell?
a.
Press Enter.
b.
Press Tab
c.
Click the mouse pointer into the cell underneath.
d.
Press Backspace
a c
QN=4
Which tool should we use to help keep headings visible when we scroll through a large workbook?
a.
Page Break Preview
b.
Freeze Panes
c.
Split
d.
Headings
b
QN=6
Which of the following components must be part of any formula?
a.
A function (e.g. SUM)
b.
A mathematical operator, e.g. +.
c.
Parenthesis
d.
The = sign
e.
Brackets
d
QN=8
You want to print your rather large data set which spans 3 pages across according to the Print Preview. You want to fit it on to 2 pages. Which of the options below are useful techniques to achieve this?
a.
Remove some of the less important columns
b.
Use the Page Layout view and set the automatic width to 2 pages.
c.
Use the Scale to Fit tools to reduce the size of your sheet
d.
Use narrower margins
b c d
QN=9
Suppose the data in cell A2 is "FPT_UNIVERSITY_DANANG",What is the result in cell A3 when entering formula = Right (A2) & Left (A2,3)& Mid (A2,5,1)
a.
GFPTU
b.
GFPTFPT_U
c.
GFPTFPTU
d.
#Value
a
QN=10
Which type of chart should you use for showing trends over time?
a.
Column chart
b.
Pie chart
c.
Bar chart
d.
Line chart
d
QN=11
Which type of chart should you use for comparing relative values of different categories to the whole?
a.
Column
b.
Line
c.
Pie
d.
Bar
c
QN=13
Public Function SSum()
Dim a As Integer
Dim b As Integer
a = 7
b = 10
If a = b / 2 Then
SSum = a a + b b
Else
SSum = a + b
End If
End Function
What does the function SSum return?
a.
17
b.
5
c.
10
d.
125
a
QN=14
Public Function FSUM(n As Integer)
Dim i As Integer
Dim s As Integer
s = 0
For i = 1 To n
s = s + i
Next i
FSUM = s
End Function
If using =FSUM(5), the result will be
a.
10
b.
15
c.
5
d.
20
b
QN=16
Choose an appropriate data type to store student's name?
a.
Boolean
b.
Interger
c.
Double
d.
String
D
QN=17
Which of the following data types is used to store the number of rows in a worksheet ?
a.
Integer
b.
Long
c.
String
d.
Boolean
b
QN=18
How to Hide the Sheet1 using VBA code?
a.
Sheets("Sheet1").Visible = True
b.
Sheets("Sheet1").Visible = False
c.
Sheets(1).Visible = xlSheetVeryHidden
d.
Sheets(1).Visible = Hiden
b
QN=19
Which of the following blocks of code would result in a compiler error if executed?
a.
Sub user_If()
If ActiveCell.Value = "" Then Exit Sub
If ActiveCell.Value >= 40 Then
ActiveCell.Offset(0, 1).Value = "Tot"
Else
ActiveCell.Offset(0, 1).Value = "Xau"
End If
End Sub
b.
Sub user_If()
If ActiveCell.Value = "" Then Exit Sub
If ActiveCell.Value >= 40 Then
ActiveCell.Offset(0, 1).Value = "Xau"
End If
End Sub
c.
Sub user_If()
If ActiveCell.Value = "" Then Exit Sub
If ActiveCell.Value >= 40 Then
ActiveCell.Offset(0, 1).Value = "Tot"
End If
End Sub
d.
Sub user_If()
If ActiveCell.Value = "" Then Exit Sub
If ActiveCell.Value >= 40 Then
ActiveCell.Offset(1, 1).Value = "Tot"
Else
ActiveCell.Offset(1, 1).Value = "Xau"
End Sub
d
QN=20
What is a Constant?
a.
It is a name to which you assign a piece of data and can change while the macro is running
b.
It is a proceduce that is stored in the computer's memory.
c.
It is a function that is stored in the computer's memory.
d.
It is a value in your macro that does not change while the macro is running
D
QN=1
VBA is:
a.
a Microsoft programming language used to extend Excel functions
b.
a statistical tool developed by Microsoft for financial analysts
c.
an open-source programming environment
d.
a Microsoft programming environment that replaces Excel
A
QN=2
What are the data types in VBA?
a.
Boolean
b.
Byte
c.
Currency
d.
Integer
A B C D
QN=3
Which function in Excel tells how many numeric entries there are?
a.
NUM
b.
COUNT
c.
SUM
d.
COUNTA
b
QN=4
What type of chart will you use to compare performance of two employees in the year 2016 ?
a.
Column Chart
b.
Line Chart
c.
Pie Chart
d.
Dot Chart
B
QN=5
In cell address F25, "25" is identified as:
a.
cell
b.
column
c.
range
d.
row
d
QN=6
Cell B15 has a text value and cell E23 has a date value. What is the formula to concatenate these two values?
a.
=B15&E23
b.
=proper(B15)&" "&text(E23,"mm/dd/yyyy")
c.
=B15&" "&E23
d.
=join(B15&E23)
B
QN=7
To find the price for the selected product (coffee in the example below), what formula would you type into the highlighted cell (B19)?
[file: Q7.png]
a.
=VLOOKUP(A19,A2:C16,3,FALSE)
b.
=VLOOKUP(A19,A2:C16,3,TRUE)
c.
Both are correct
d.
None is correct
A
QN=8
Which of the following functions, when inserted in the highlighted cell (C2) below, will return the word "yes"?
[file: Q8.png]
a.
=IF(B2>50,"yes")
b.
=IF(C2="yes")
c.
=IF(B2=C2, "yes")
d.
=IF(B2=50, "yes")
A
QN=9
Which of the following represents a formula or function that is entered in the cell E2 and can then be copied down to the cells below it to count the total enrollments for each module?
[file: Q9.png]
a.
=IF(B2:B13="Biology","yes","no")
b.
=COUNTIF($B$2:$B$13,D2)
c.
=COUNTIF(B2:B13="Biology")
d.
=COUNTIF(B2:B13="Biology" or "History" or "Literature")
B
QN=10
Which of the following statements are TRUE regarding using wildcard characters for the lookup_value argument in HLOOKUP and VLOOKUP?
a.
? can be used as a place marker for a single character, and * can be used for character sequences of any length
b.
It will only work when lookup_value is a text string
c.
It will not work if range_lookup is TRUE
A B C
QN=11
What will happen to the formula contained in D4:D10 if we move the content of cell B1 (1.05) to cell E25 on the worksheet?
[file: Q11.png]
a.
The formula will update so that the last part of it will be *$E$25.
b.
There will be no change to the formula or value of the cell.
c.
The cells will return a #REF! error.
d.
The formula will no longer calculate the correct values.
A
QN=12
Which of the following is not true regarding Conditional Formatting?
a.
You can add more than one condition to check
b.
You can set condition to look for Bold and apply Italics on them
c.
You can apply font, border and pattern formats to the data that meet the specified conditions
d.
You can delete any condition from Conditional Formatting dialog box if it is not required
B [Show Less]