11/9/21, 8:45 AM                                             FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  FIRST QUARTERLY ASSESSMENT IN
                                  COMPUTER 9
                                  mdelacruz@gstc.edu.ph Switch account

                                  Your email will be recorded when you submit this form

                                  * Required




                                  Direction; Read the questions carefully and choose the letter of the best
                                  answer.




                                  You want to remove a highlighted text from the worksheet and place it on    1 point

                                  the clipboard *




                                      Option 1                                        Option 4




                                      Option 3                                        Option 2




https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                     1/14


11/9/21, 8:45 AM                                            FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  You saved a worksheet in a folder. You want to open it for printing *     1 point




                                      Option 1                                     Option 2




                                      Option 3                                     Option 4




                                  You saved the worksheet you were working on. Now you want to see how it   1 point

                                  looks before printing *




                                      Option 2                                     Option 4




                                      Option 3                                     Option 1




https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                   2/14


11/9/21, 8:45 AM                                          FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  You want to quickly add the set of numbers you selected in a row. *        1 point




                                      Option 2                                   Option 1




                                      Option 3                                   Option 4




                                  You want to check for the spelling or grammar errors after encoding data   1 point
                                  in your worksheet *




                                      Option 3                                   Option 1




                                      Option 4                                   Option 2




https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                    3/14


11/9/21, 8:45 AM                                          FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  You want to highlight important data by marking them in boldface. *     1 point




                                      Option 2                                   Option 4




                                      Option 3                                   Option 5




                                  You want to put a peso sign before a column of numbers that represent   1 point

                                  money in a cell. *




                                      Option 3                                   Option 2




                                      Option 4                                   Option 1




https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                 4/14


11/9/21, 8:45 AM                                          FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  You want to interpret the number of Covid19 cases in a certain barangay.   1 point
                                  You will insert charts in your worksheet *




                                      Option 2                                   Option 1




                                      Option 4                                   Option 3




                                  After editing your worksheet. You select this icon to save changes you     1 point

                                  made to your file. *




                                      Option 4                                   Option 1




                                      Option 3                                   Option 2




https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                    5/14


11/9/21, 8:45 AM                                            FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  While editing your worksheet you suddenly made a correction. Instead of    1 point

                                  deleting and typing again you reverses the last command by clicking this
                                  icon *




                                      Option 3                                    Option 1




                                      Option 4                                    Option 2




                                  A graphical representation of manipulated information is called            1 point

                                  ______________ *

                                      Worksheet

                                      Database

                                      Graph

                                      Chart




                                  It is the most widely used spreadsheet application *                       1 point



                                      Google Sheets

                                      Writer

                                      Libre Office Spreadsheet

                                      Microsoft Excel




                                  A collection of number of worksheet is called ___________ *                1 point



                                      Records

                                      Workbook

                                      Worksheet

                                      Database

https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                    6/14


11/9/21, 8:45 AM                                           FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  There are how many number of rows in an Excel *                                  1 point



                                      63,355

                                      65, 536

                                      66,553

                                      65,636




                                  One of the basic concepts in MS Excel that is referred by alpha character        1 point

                                  from left to right. *

                                      Columns

                                      Workbook

                                      Worksheet

                                      Rows




                                  What is the intersection of a column and a row on a worksheet called ? *         1 point



                                      Value

                                      Address

                                      Cell

                                      Column




                                  In Excel, Columns are labelled as ___ *                                          1 point



                                      A1, A2, etc.

                                      1,2,3 etc

                                      A, B, C, etc

                                      $A$1, $A$2, etc.




                                  In Excel, Rows are labelled as ______ *                                          1 point



                                      1,2,3 etc

                                      A, B, C, etc

                                      $A$1, $A$2, etc.

                                      A1, A2, etc.




                                  The basic unit of a worksheet into which you enter data in Excel is called a *   1 point



                                      box


https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                          7/14


11/9/21, 8:45 AM                                             FIRST QUARTERLY ASSESSMENT IN COMPUTER 9
                                      column

                                      cell

                                      table




                                  How many sheets are there, by default, when we create a new Excel file ? *   1 point



                                      10

                                      5

                                      1

                                      3




                                  Part of the MS Excel that shows commonly used commands at the top of         1 point

                                  the application window. *

                                      Worksheet

                                      Quick Access Toolbar

                                      Ribbon

                                      Tab




                                  This toolbar provides shortcut buttons for formatting the data in your       1 point

                                  spreadsheet like font, size, text alignment and text color. *

                                      Shortcut toolbar

                                      Sheets toolbar

                                      Rows

                                      Spreadsheet title




                                  The first thing you will see when you open the MS Excel *                    1 point



                                      Opening Screen

                                      Backstage View

                                      Closing Screen

                                      Start Screen




                                  Resize, Move and close are found in _______ *                                1 point



                                      Sheet tab control

                                      Quick Access Toolbar

                                      Excel Worksheet

                                      Program Windows Control




https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                      8/14


11/9/21, 8:45 AM                                            FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  This is the working area of you worksheet that provides access to tools   1 point

                                  needed to enter, edit, and format data. *

                                      Ribbon Parts

                                      View Controls

                                      Application Window

                                      Sheet tab control




                                  Which of the following is under the Tab groups *                          1 point



                                      View Controls

                                      Formulas

                                      Program Window Controls

                                      Worksheet




                                  Horizontal cells that are labelled by numbers *                           1 point



                                      Rows

                                      Formula Bar

                                      Columns

                                      Cells




                                  The area where data and formulas are entered and edited. *                1 point



                                      Formula Bar

                                      Columns

                                      Rows

                                      Cells




                                  These are vertical cells that are labelled by letters. *                  1 point



                                      Rows

                                      Columns

                                      Formula Bar

                                      Cells




                                  It allows you to add and navigate through multiple worksheets *           1 point



                                      Rows


https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                   9/14


11/9/21, 8:45 AM                                              FIRST QUARTERLY ASSESSMENT IN COMPUTER 9
                                      Sheet Tab Control

                                      Formula Bar

                                      Cells




                                  Excel documents are stored as files called *                                  1 point



                                      Workforce

                                      Worksheet

                                      Workgroups

                                      Worktables




                                  To close a workbook, you must first go to __________ *                        1 point



                                      Backstage View

                                      Insert Tab

                                      File Tab

                                      Home Tab




                                  To save a workbook with a new name or save it to a different location click   1 point

                                  the __________ command in the backstage view. *

                                      Home Tab

                                      File Tab

                                      Insert Tab

                                      Save As




                                  Aside from going to the backstage view, you can use the print icon located    1 point

                                  at the _________________. *

                                      Program Control

                                      File View

                                      Quick Access Toolbar

                                      Insert View




                                  Which of the following cannot be used to enter data in excel? *               1 point



                                      Pressing the esc key

                                      Pressing an arrow key

                                      Pressing the Tab key

                                      Clicking on the formula bar




                                  Keyboard shortcut for printing an excel worksheet? *                          1 point



                                      CTRL R

https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                       10/14


11/9/21, 8:45 AM                                              FIRST QUARTERLY ASSESSMENT IN COMPUTER 9

                                      CTRL N

                                      CTRL P

                                      CTRL I




                                  To save a workbook you *                                                                     1 point



                                      use the backstage view to save your workbook for the first time.

                                      click the file tab and click the save icon in saving your workbook for the first time.

                                      Press CTRL F5

                                      Select Edit then Save




                                  Which of the following is not a basic step in creating a worksheet? *                        1 point



                                      Modify the worksheet

                                      Save workbook

                                      Enter text and data

                                      Copy the worksheet




                                  Excel files have a default extension of *                                                    1 point



                                      .html

                                      .xlsx

                                      .xlw

                                      .123




                                  You can activate a cell by *                                                                 1 point



                                      Clicking the cell

                                      Pressing an arrow key

                                      Pressing the Tab key

                                      All of the above




                                  Which tab is used to show print command? *                                                   1 point



                                      Home

                                      View

                                      File

                                      Page layout




                                  Which of the following starts off with Save, Undo and Redo and can be                        1 point

                                  customized to contain the commands you use most frequently? *

                                      Ribbon


https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                                      11/14


11/9/21, 8:45 AM                                              FIRST QUARTERLY ASSESSMENT IN COMPUTER 9
                                       A worksheet

                                       Quick Access Toolbar

                                       Help Window




                                  How do you change the width of the column so that the widest entry will            1 point

                                  fit? *


                                       Smartfit

                                       Autofit

                                       Bestfit

                                       Truefit




                                  Which of the following procedures is not a way to delete one or more               1 point

                                  worksheets from a workbook? *

                                       Right-click a worksheet tab and click Delete.

                                       Click the down arrow next to Delete on the Home tab and click Delete Sheet.

                                       Select a group of worksheets, right-click the group, and click Delete.

                                       Press CTRL A to select all cells in the worksheet and then press Delete




                                  Which of the following statements describes a reason as to why you would           1 point

                                  need to copy a worksheet within a workbook? *

                                       It lets you reuse formats and formulas in a new sheet.

                                       It's the easiest way to make a backup before making changes.

                                       It helps Excel learn where your data ranges are located.

                                       You should keep one worksheet hidden in case of an error.




                                  When you create a copy of a worksheet named August, Excel gives that               1 point
                                  worksheet which of the following names? *

                                       August (2)

                                       Sheet2

                                       July

                                       September




                                  On which tab would you find the command to create a new workbook? *                1 point



                                       Home

                                       Insert

                                       File

                                       View




https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                            12/14


11/9/21, 8:45 AM                                                   FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                   You can format text in Excel by making it bold, italic, etc. *                                       1 point



                                        Maybe

                                        I dont know

                                        True

                                        False




                                   Worksheets are made up of rows and columns. *                                                        1 point



                                        Maybe

                                        False

                                        I dont know

                                        True




                                   Excel is a __________ program that allows you to store, organize, and                                1 point
                                   analyze information. *

                                        presentation

                                        image

                                        word processing

                                        spreadsheet




                                   Read and internalize the schools pledge of Honesty. After reading, please write
                                   your full name and submit. *




                                   Your answer




                                  Submit                                                                                              Clear form


                               Never submit passwords through Google Forms.

                                               This form was created inside of Good Shepherd of Taguig Colleges, Inc.. Report Abuse


                                                                                          Forms
https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform                                                13/14


11/9/21, 8:45 AM                                     FIRST QUARTERLY ASSESSMENT IN COMPUTER 9
                                                                  Forms




https://docs.google.com/forms/d/e/1FAIpQLSf5nGU0OHJWfeDuo597yOyrDhl_xA1AzcNi6sYQ6RKFORFVHQ/viewform   14/14


11/9/21, 8:45 AM                                             FIRST QUARTERLY ASSESSMENT IN COMPUTER 9




                                  FIRST QUARTERLY ASSESSMENT IN
                                  COMPUTER 9
                                  mdelacruz@gstc.edu.ph Switch account

                                  Your email will be recorded when you submit this form