Assessment of Skills in MS-Excel as

Spreadsheet Software
Kabuuang puntos13/60
 

0 sa 0 (na) puntos
ExtendedForms Id (skip this field)
DO NOT EDIT this field or your score will not recorded.

Name  (LastName, FirstName)*

HHHH

Basics of Preparing Tabular Report using Spreadsheet (MS Excel)

5 sa 15 (na) puntos
1) How can you can rename a sheet (worksheet)?
   A) 1) Right CLICK on the sheet tab.  2) Choose Rename from the popup menu  3)
Type the NEW name of the sheet   4) Press ENTER key
   B) 1) Right CLICK on the status bar   2) Choose Rename from the popup menu   3)
Type the NEW name of the sheet   4) Press ENTER key.
   C) 1) Select RENAME in the Home tab   2) Type the NEW name  3. Press ENTER
key

*
0/1

A
B
C

Tamang sagot
A

2. In a spreadsheet, data are normally entered in a cell. What key will you press
when you want to go to the next cell to the right?
   A) Enter key
   B) Tab key
   C) Shift key
*
1/1

A
B
C

3. How can you can rename a sheet (worksheet)?

  A) 1) Right CLICK on the sheet tab.  2) Choose Rename from the popup menu.  3)
Type the NEW name of the sheet.  4) Press ENTER key
  B) 1) Right CLICK on the status bar.  2) Choose Rename from the popup menu.  3)
Type the NEW name of the sheet.  4) Press ENTER key
  C) 1) Select RENAME in the Home tab.  2) Type the NEW name.  3) Press ENTER
key

*
0/1

A
B
C
D

Tamang sagot
A

4. You want to have an additional Sheet (worksheet) in the workbook, what

process will you undertake?
   A) Click the New Sheet button in the Sheet tab
   B) Press Shift + F11
   C) Select Insert in the Home Tab -> Choose Insert Sheet (or Worksheet)
   D) all the choices are possible
*
0/1

A
B
C
D

Tamang sagot
D

5. It is possible to lock columns or rows so that when scrolling down or to the
right, these columns or rows will still be displayed. What shall you set in the
View tab once you selected the columns and/or rows to be locked?
   A) Align Cells
   B) Freeze Panes
   C) Group
   D) Merge Cells
*
0/1

A
B
C
D

Tamang sagot
B

6. What process shall you use if you merge cells in the worksheet?
   A)  1) Select the cell/cells to merge.  2) Click Merge button in the File tab.  3)
Choose either a) Merge & Center, b) Merge Across or c) Merge Cells 
   B) 1) Select the cell/cells to merge.  2) Click Merge and Center button in the Home
tab.  3) Choose either a) Merge & Center, b) Merge Across or c) Merge Cells 
   C) 1) Select the cell/cells to merge.  2) Click Merge and Center button in the View
tab.  3) Choose either a) Merge & Center, b) Merge Across or c) Merge Cells 
   D) 1) Select the cell/cells to merge.  2) Click Merge and Center button in the Insert
tab.  3) Choose either a) Merge & Center, b) Merge Across or c) Merge Cells 
*
1/1

A
B
C
D

7. A formula is typed in B2 and you intend to have the formula to be utilized
also in B3 to B20, what will you do to fill the formula?
  A)  1) Select the Cell where the formula is typed.  2) Issue a copy command like
pressing Ctrl + C.  3) Select B3 to B20.  4) Issue Paste Command using Ctrl + V.
   B) 1) Select B3 to B20.  2) Issue a copy command like pressing Ctrl + C.  3) Select
B2 where the formula is.  4) Issue Paste Command using Ctrl + V.
   C) 1) Select B3 to B20.  2) Issue a copy command like pressing Ctrl + C.  3) Issue
Paste Command using Ctrl + V.*
0/1

A
B
C

Tamang sagot
A

8. Autofill values such as numbers, days of the week, month, quarters and
others can be applied using autofill or fill handle. Assuming you want to have
the months to be placed in the worksheet without typing all of the months, say
putting it in A1 to K1, what process will you do?
  A)  1) Type January and February in A1 and K1 respectively.  2) Select (or
highlight) cells A1 and K1.  3) Click and drag the fill handle (seen at the lower right
portion of the selected cells) up to cell K1.
   B)  1) Type January and February in A1 and A2 respectively.  2) Select (or
highlight) cells A1 to K1.  3) Click and drag the fill handle (seen at the lower right
portion of the selected cells) up to cell K1.
   C) 1) Type January and February in A1 and A2 respectively.  2) Select (or
highlight) cells A1 and B1.  3) Click and drag the fill handle (seen at the lower right
portion of the selected cells) up to cell K1.
*
0/1

A
B
C

Tamang sagot
C

9. Assuming you want to get the value of B2 and place it D2, what formula will
you type?
   A) B2
   B) =B2
   C) !B2
   D) +B2
*
0/1

A
B
C
D

Tamang sagot
B

10. In a sum function =SUM(A1:E1), A1:E1 means what?

   A) It is referring to the values of A1 and E1
   B) It is referring to the values of between A1 and E1, that is B1, C1, and D1
   C) It is referring to the values from A1 to E1, that is A1, B1, C1, D1, and E1.
*
0/1

A
B
C

Tamang sagot
C

11.  It is possible to define a name of a cell or range of cells. How can this
possibly done?
  A) Typing the name in the Name box
  B) Typing the name in the Define box
  C) Typing the name in the Formula box
*
1/1

A
B
C

12. Which among the formulas is correct using cell referencing as basis?

  A) B2 + C2  X D2 =
  B) = 2B + C2 X D2
  C) = B2 + C2 * D2
  D) = A2 + B2 (C2)
*
0/1

A
B
C
D

Tamang sagot
C

13.  How do we reference values coming from another sheet.

(Assuming that the source sheet is Sheet1 and the cells to use are B2 and C2
of the Sheet1, to be used in Sheet2)
  A) =Sheet1!B2 * Sheet1!C2
  B) =Sheet1:B2 * Sheet1:C2
  C) =Sheet1#B2 * Sheet1#C2
*
1/1

A
B
C

14. Which among the following formula is correct assuming that the source is
Data Sheet.
  A) =Data:A1 * 12
  B) =Data!A1 X 12
  C) =Data!A1 * 12
  D) =Data>A1 X 12
*
1/1

A
B
C
D

15. You would like to define the name of a cell range, for example: A1:A25, into
STUDENT, how will you do it?
  A) select cells A1 to A25, then go to Name box and type STUDENT.
  B) go to Name box, select cells A1 to A25 and type STUDENT.
  C) select cells A1 to A25, type STUDENT in the Formula Bar

*
0/1

A
B
C

Tamang sagot
A

Organizing and Enhancing the Tabular Report 

2 sa 20 (na) puntos
16. What method is used in regulating cell/cells on possible data values
entered.
  A) Conditional Formatting
  B) Data Validation
  C) Define Name
  D) Protect Sheet
*
0/1

A
B
C
D

Tamang sagot
B

17. In setting validation criteria for Data Validation, which among the following is not
part of the choices in Allow combo box? 
  A) Whole Number
  B) Decimal
  C) List
  D) All Values
*
0/1

A
B
C
D

Tamang sagot
D

18. You want a cell or range of cells to accept either Male or Female only, 1) what
Criteria under allow will you select AND 2) what will you type under Source?
  A) 1) Custom    2) Male: Female
  B) 1) Data    2) Male, Female
  C) 1) List   2) Male, Female
  D) 1) List   2) Male: Female
*
0/1

A
B
C
D

Tamang sagot
C

19. What tab will you activate if you want to set the Data Validation on a cell or range
of cells?
  A) Home
  B) Insert
  C) Formula
  D) Data
*
0/1

A
B
C
D

Tamang sagot
D

20. You want to limit the value to be entered from 0 to 100, how will you set the
validation Criteria in the Data Validation dialog box?
  A) 1) Select Number under Allow:  
       2) Under Data: Select "Between", type 0 and 100 under "Minimum:" and
"Maximum:"
       3) Click OK button when done.
  B) 1) Select Whole Number under Allow:  
       2) Under Data: Select "Between", type 0 and 100 under "Minimum:" and
"Maximum:"
      3) Click OK button when done.
  C) 1) Select Number under Allow:
       2) Under Data: Select "From", type 0 and 100 under "Minimum:" and
"Maximum:"
      3) Click OK button when done.
  D) 1) Select Whole Number under Allow:
       2) Under Data: Select "Greater than or Equal to", type 0 and 100 under
"Minimum:" and "Maximum:"
      3) Click OK button when done.
*
0/1
A
B
C
D

Tamang sagot
B

21. It is a way to automatically apply a format depending on conditions set.

  A) data validation
  B) format validation
  C) conditional formatting
  D) conditional filtering 
*
0/1

A
B
C
D

Tamang sagot
C

22. In a range of cells, it is possible to easily identify the top 10 items using
___________ under __________.
  A) Top/Bottom Rules,  Conditional Formatting
  B) Top/Bottom Rules,  Validation Formatting
  C) Top/Bottom Rules,  Data Formatting
  D) Top/Bottom Rules,  Conditional Validation
*
0/1

A
B
C
D

Tamang sagot
A

23. Which among the predefined rules can be used if I want data from cell range to
be formatted based on greater than, less than, between, equal to, ... conditions?
  A) Color Scales
  B) Data Bars
  C) Highlight Cells Rules
  D) Top/Bottom Rules
*
0/1

A
B
C
D

Tamang sagot
C

24. Is it possible to create your own rule for conditional formatting? If yes, what will
you use?
  A) Yes,   Add Rule
  B) Yes,   New Rule
  C) Yes,  Add New Rule
  D) No
*
0/1

A
B
C
D

Tamang sagot
B

25. What shall you use if you want to see: edit, delete or manage all rules set in a
range of cells?
  A) Add New Rule...
  B) Edit Rule...
  C) Manage Rule...
  D) Modify Rule...
*
0/1

A
B
C
D

Tamang sagot
C

26. It is a way to reorganize the content of a worksheet (or range of cells/columns) in

alphabetical or numerical order either ascending or descending.
  A) data
  B) filtering
  C) formatting
  D) sorting
*
1/1

A
B
C
D

27. How do you sort your data with two levels of criteria?

  A) 1) Select the range of data to be sorted
       2) Select Data tab then click "Sort A to Z" command
       3) In the Sort Dialog box:  a) Set the Sort by (column to use)   b) Click Add level
for new Criteria  c) Select the column (under Then by)
       4) Click OK button
  B) 1) Select the range of data to be sorted
       2) Select Data tab then click "Sort Z to A" command
       3) In the Sort Dialog box:  a) Set the Sort by (column to use)   b) Click Add level
for new Criteria   c) Select the column (under Then by)
      4) Click OK button
  C) 1) Select the range of data to be sorted
       2) Select Data tab then click "Sort" command
       3) In the Sort Dialog box:    a) Set the Sort by (column to use)   b) Click Add
level for new Criteria  c) Select the column (under Then by)
       4) Click OK button
  D) all of the choices is possible
*
0/1

A
B
C
D

Tamang sagot
C
28. How do you use the headers of the selected columns as criteria for sorting?
  A) 1) Include the headers in the selected range
       2) In the Sort dialog box, Click the check box for "My data has headers" then set
the other settings needed.
  B) 1) Include the headings in the selected range 
       2) In the Sort dialog box, Click the check box for "My data has headers" then set
the other settings needed.
  C) 1) Include the headers in the selected range
       2) In the Sort dialog box, Click the check box for "My data needs headers" then
set the other settings needed.
  D) 1) Include the headings in the selected range
       2) In the Sort dialog box, Click the check box for "My data need headers" then
set the other settings needed.
*
0/1

A
B
C
D

Tamang sagot
A

29. It is a way of finding information quickly by narrowing down the data in the
worksheet. But this works well if the worksheets, or the data set available, has
headers.
  A) Filtering
  B) Indexing
  C) Sorting 
  D) Validating
*
0/1

A
B
C
D

Tamang sagot
A

30. How do you activate the filter button in order to set filtering conditions? 
  A) Click Home then  Click Filter command
  B) Click Insert  then  Click Filter command
  C) Click Data  then   Click Filter command
  D) Click Review  then   Click Filter command
*
0/1

A
B
C
D

Tamang sagot
C

31. You are going to display only the products sold as W, how will you do it? (see
figure as basis)

  A) 1) Click the Filter Button in the Sold As   2) Click the checkbox for W     3) Click
OK button
  B) 1) Click the Filter Button in the Sold As   2) Uncheck Select All (by clicking the
check box)   3) Click the checkbox for W     4) Click OK button

  C) 1) Click the Filter Button in the Product    2) Click the checkbox for W    3) Click
OK button

  D) 1) Click the Filter Button in the Category   2) Uncheck Select All (by clicking the
check box)   3) Click the checkbox for W  4) Click OK button

*
1/1
A
B
C
D

32. It is possible to filter data with amount greater than or equal to 1000? If yes, how
will you do it?
  A) YES
      1) Click Filter Button in the Amount
      2) Select Number Filters (from popup menu)
      3) Select "Greater than or Equal to" option
      4) Type 1000 in the textbox/combo box area
      5) Click OK button
  B) YES
      1) Click Filter Button in the Amount
      2) Select Filter Number (from Data tab) 
      3) Select "Greater than or Equal to" option
      4) Type 1000 in the textbox/combo box area
      5) Click OK button
  C) YES
      1) Click Filter Button in the Amount
      2) Select Number in the Insert Tab
      3) Select "Greater than or Equal to" option
      4) Type 1000 in the textbox/combo box area
      5) Click OK button
  D) No
*
0/1

A
B
C
D

Tamang sagot
A

33. It is a way to organize data in the worksheet into sections

  A) Filter
  B) Group
  C) Format as Table
  D) Conditional Formatting
*
0/1

A
B
C
D

Tamang sagot
B

34. A worksheet can be converted into table. How will you do it?
  A) 1) Select the range of cells of data to be converted.
       2) Click Format as Table in the Format tab.
       3) Select the Table Style to apply
       4) From the dialog box, verify the data range, click check box for "My table has
headers" if headers of the range of cells were selected.
       5) Click OK Button when done.
  B) 1) Select the range of cells of data to be converted.
       2) Click Format as Table in the Home tab.
       3) Select the Table Style to apply
       4) From the dialog box, verify the data range, click check box for "My table has
headers" if headers of the range of cells were selected.
       5) Click OK Button when done.
  C) 1) Select the range of cells of data to be converted.
       2) Click Convert as Table in the Format tab.
       3) Select the Table Style to apply
       4) From the dialog box, verify the data range, click check box for "My table has
headers" if headers of the range of cells were selected.
      5) Click OK Button when done.
  D) 1) Select the range of cells of data to be converted.
       2) Click Format as Table in the Data tab.
       3) Select the Table Style to apply
       4) From the dialog box, verify the data range, click check box for "My table has
headers" if headers of the range of cells were selected.
      5) Click OK Button when done.

*
0/1

A
B
C
D

Tamang sagot
B

35. When worksheet (or range of cells) is formatted as Table, a _________ can be

added, either by customizing the Ribbon or Quick Access Toolbar, in order to be
used to manipulate the data.
  A) Data Window
  B) Form
  C) Tab
  D) Dialog box
*
0/1

A
B
C
D

Tamang sagot
B

Data Reporting & Analysis using Formulas and Functions

5 sa 15 (na) puntos
36. A formula in a spreadsheet like MS Excel starts with what sign?
  A) =#
  B) &=
  C) =
  D) =:
*
1/1

A
B
C
D

37. Which among the following is NOT a valid formula?

  A) = B2 X C2 + D2
  B) =(B2 * C2)/E2
  C) =B2 / C2 - D2
  D) =B2 + (C2 * D2)
*
1/1

A
B
C
D

38. Assuminh the data for unit price (UPrice) is in b2 and the quantity (qty) is in c2,
what is the formula to get the amount of a product by multiplying UPrice and Qty?
  A) =Uprice * Qty
  B) =B1 + C1
  C) =B2 X C2
  D) =B2 * C2
*
0/1

A
B
C
D

Tamang sagot
D

39. It is a ready-made or pre-defined formula in a spreadsheet like MS Excel

  A) sum
  B) function
  C) formula
  D) template
*
0/1

A
B
C
D

Tamang sagot
B

40. =sum() is used to get the sum of values of a cell range. Which among the
following is a correct formula to get the sum of values from B2 to E2?
  A) =sum(A2;E2)
  B) =sum(A2:E2)
  C) =sum(A2+E2)
  D) =sum(B2+C2+D2*E2)
*
0/1

A
B
C
D

Tamang sagot
B

41. What function can be used to get the mean of a cell range? 

  A) =mean()
  B) =average()
  C) =sum()/count
  D) =averageif()
*
0/1

A
B
C
D
Tamang sagot
B

42. It is a function that is used to create a condition; in which the result will be based
on the condition?
  A) =condition()
  B) =Ifthen()
  C) =if()
  D) =proper()
*
1/1

A
B
C
D

43. Assuming the value in cell B2 is 123.4567, Which among the formula/function

yields a value of 123.46?
  A) =int(B2, 2)
  B) =rounddown(B2, 2)
  C) =round(2, B2)
  D) =round(B2, 2)
*
1/1

A
B
C
D

44. Where can you locate the different functions?

  A) data
  B) formula
  C) function
  D) insert
*
0/1

A
B
C
D
Tamang sagot
B

45. What command will you activate in the Formulas tab if you want to get the sum of
values above the active cell?
  A) AutoSum
  B) Sum
  C) Insert Function
  D) define name
*
0/1

A
B
C
D

Tamang sagot
A

46. You want to have a formula to compute the 10% commission of an agent. What
formula shall be used if the source sheet is DATA and the value is in B2 and you
place the computed value in another sheet?
  A) =DATA+B2 * 10%
  B) =DATA#B2 * 10%
  C) =DATA!B2 * 10%
  D) =B2!DATA * 10%
*
0/1

A
B
C
D

Tamang sagot
C

47. What is the correct IF formula if you want the remark to be based on the grade. If
grade is greater than or equal to 75, Remark is Passed, else Remark is Failed.
  A) =IF(B2>=75, "Passed", "Failed")
  B) =IF(B2>=75, "Passed, Failed")
  C) =IF(B2>75, "Passed", "Failed")
  D) =IF(B2>75, "Passed, Failed")
*
1/1

A
B
C
D

48. The formula is =B4 * $A$1.   What does the dollar sign means placed in a cell
reference?
  A) It means that the cell reference is fixed even you copy and paste in succeeding
cells.
  B) It means that the cell reference is flexible even you copy and paste in
succeeding cells.
  C) It means that the cell reference is adjust automatically if you copy and paste in
succeeding cells.
  D) It means that the cell reference will place a dollar sign on the computed value
*
0/1

A
B
C
D

Tamang sagot
A

49. You want to display or use the system date only of the computer you are using,
what appropriate function can be used?
  A) =days
  B) =now()
  C) =today()
  D) =days360
*
0/1

A
B
C
D

Tamang sagot
C

50. It is a function that is used to combine two or more text (or literal values).
  A) =combine()
  B) =concatenate()
  C) =Proper()
  D) =connect()
*
0/1

A
B
C
D

Tamang sagot
B

Data Visualization using Charts, Pivot Chart

1 sa 10 (na) puntos
51. It is a way on how to interpret and present data in a graphical form.
  A) Chart
  B) Object
  C) Picture
  D) Pivot Table
*
0/1

A
B
C
D

Tamang sagot
A

52. Which among the following is not a chart that can be created in Microsoft Excel?
  A) bar
  B)  line
  C) row
  D) pie
*
0/1

A
B
C
D

Tamang sagot
C

53. To create a chart in MS Excel, what tab shall be chosen or activated first?
  A) Home
  B) Create
  C) Format
  D) Insert
*
0/1

A
B
C
D

Tamang sagot
D

54. Once a chart is created, for example, you already created a column graph, can
you still change the chart type, for example changing it to bar or line graph?
  A) Yes, but you need to create a new one.
  B) Yes, by clicking the Change Chart Type under Chart Design tab (if chart is
active)
  C) Yes, by clicking the Change Chart Type under Format tab (if chart is active)
  D) No
*
0/1

A
B
C
D

Tamang sagot
B
55. Is it possible to add the table in the chart created? If yes, what command shall be
chosen in the Chart Design tab?
  A) Click Add Chart Element then choose Data Table
  B) Click Add Chart Element then choose Insert Table
  C) Click Insert Chart Element  then choose  Data Table
  D) No
*
1/1

A
B
C
D

56. Assuming that a column graph is created, (see sample graph below), how will
you switch the graph in such a way that graph will compare population of A,B,C per
Sex? (assuming that the graph is selected (or active)?
  A) click Select/Switch command in the Chart Design tab
  B) Select Row/Column Switch command in the Chart Design tab
  C) Select Switch Row/Column command in the Chart Design tab
  D) Select Switch Row/Column command in the Format tab
*
0/1

A
B
C
D

Tamang sagot
C

57. It is a feature of a spreadsheet like MS Excel which allows you yo prepare an

interactive or dynamic summary report.
  A) Chart
  B) Pivot Table
  C) Dynamic Table
  D) Interactive Table
*
0/1

A
B
C
D

Tamang sagot
B

58. Using the data (see picture A. DATA) to prepare a Pivot Chart and Table, what
area will you place the Amount if you want to see Sales per Category (see picture B
PIVOT TABLE Chart Fields?
  A) Filters
  B) Columns
  C) Rows
  D) Values
*
0/1
A
B
C
D

Tamang sagot
D

59. Using the data  (see figure below), Where will you place Category you want to
make a summary of sales (Total Amount) per Category? 

  A) Filters
  B) Columns
  C) Rows
  D) Values
*
0/1

A
B
C
D

Tamang sagot
C

60. Is it possible to change the color of the bars? If yes, what tab shall done?
  A) Yes,  Design tab (OR Chart Design Tab)
  B) Yes,  Format tab 
  C) Yes, Insert Tab 
  D) No
   
*
0/1
A
B
C
D

Tamang sagot
A
Ginawa ang form na ito sa Cagayan State University.

 Forms