SSLC Information technology – Formative Assessment Test 1 – Jul’17

        I.           

            Fill in the blanks:

1.       ----------- can be used for inserting information at the top of the page.

Ans: Header

2.       Templates refer to a ---------- document.

Ans: sample fill-in the blank

3.       The panes are formed where your ------------- is placed.

Ans: cursor

      II.            Match the following:

1.       Auto sum                            -  styles group, home tab

2.       Conditional formatting    -   page setup group, page layout tab

3.       Page layout                        -   editing group,  home tab

4.       Set page break                  -    workbook views group, view tab

-          Cells group, home tab

Ans: 1. Editing group, home tab 2. Styles group, home tab 3. Workbook view, view tab 4. Page setup group, page layout tab

    III.            Answer the following questions:

1.       Define auto sum?

Ans: Auto sum is used for adding the values in the given cells automatically without writing the formulas to perform the operation.

2.       Define footer?

Ans: Footer is a text or image inserting at the bottom of the page.

3.       Define conditional formatting?

Ans: Conditional formatting allows us to change the formatting of the cells based on values.

    IV.            Answer the following questions in 2/3 sentence:

1.       Write the steps how to hide/ unhide rows and columns?

·          To hide a row/column

·         Open a new spreadsheet and enter the data

·         Click format option under cells group in the home tab

·         Drop down list appears

·         Click hide and unhide >rows/ columns

·         Alternatively, we can select the row/column, right click and select hide/ unhide option.

2.       Write the steps how to apply conditional formatting?

·            open new spreadsheet and enter the data

·   Select all the cells that we want to format conditionally

·   Click conditional formatting option under styles group in the home tab

·   A drop-down list appears

·   Click the option highlight cell rule

·   A submenu appears

·   We can select the option that we need. For example, we can select the greater than option, a dialogue box appears, then we specify the values and we can also add a colors in it

Then we click ok.

3.       Write the steps how to apply auto sum to a document?

·            in the active cell select the auto sum option under editing group in the home tab

·         The values in the cells automatically selected

·         Press enter.

      V.            Answer the following questions in 4/5 sentence:

1.       Explain any four views available in the spreadsheet?

Ans: Normal view: the default view of the spreadsheet application is normal. It is a collection of cells arranged in the work area.

Custom views: if we would like to view selected areas of a document, we can use a custom views option.

Page break preview: this option is similar to page layout option except we can set the area that is to be set as page after inserting a page break.

Full-screen view:  selecting this option makes the workbook cover the entire screen.

Share to your SSLC Mates to help them in social media. Thanks

Share on whatsapp