Getting to Know Excel!

Which of the following statements is correct about the difference between a workbook and spreadsheet?

• Workbook can contain several sheets while a spreadsheet is one page or a portion of your document.

• Workbook only contains one sheet while a spreadsheet is the whole document.

• Workbook cannot contain any sheet while a spreadsheet can contain several pages.

• Workbook is a single page in a sheet while a spreadsheet contains the whole workbook.

Answer explanation

Workbook is the document itself when you open your Excel. Spreadsheet on the other hand is just one portion of your document. A workbook can contain many spreadsheets. Think of it as a simple book. Workbook is the book itself and the spreadsheets are the pages of that book containing lessons and activities.

Clara is doing homework where she needs to format the table for presenting the data of the daily and weekly growth of her bean sprout. She also needs to compute for the average growth length of the bean sprout. What tabs should she check to finish her homework?

• File tab and Data tab

• Insert tab and Data tab

• Home tab and Formulas Tab

• Page Layout tab and Formulas tab

Answer explanation

Clara needs to check the Home tab first in order for her to format the table. There are tools for changing the font, size, and color to make the data table more appealing and understandable. She also needs to check the Formulas tab and find the functions she needs for the average computation.

What type of operator will you use if you want to compare two values?

• text concatenation

• reference opertor

• arithmetic operator

• comparison operator

Answer explanation

Comparison operators are logical operators used to compare two values in a spreadsheet. The result of the comparison can be either TRUE or FALSE.

What symbol from the arithmetic operators will you use if you want to know if a number is divisible by another number?

• %

• ^

• /

• *

Answer explanation

The percent sign is the modulo operator for spreadsheet. Modulo returns the remainder of a number and if the remainder is zero it means that it is divisible.

What symbol from the reference operators will you use if you want to select a range of cells in your spreadsheet?

• ,

• :

• #

• @

Answer explanation

The colon sign (:) is a range operator used to show reference of the range of selected cells. This sign is a reference operator.

Your teachers also asked you to get the average for each kakanin so that they will get an idea of the ratio they need to prepare for each type. Which of the following formulas will you use to get the average of the three sections? Refer to the same table provided.

• =B2+B3+B4/4

• =(B2+B3+B4)/4

• =H2+H3+H4/4

• =(H2+H3+H4)/4

Answer explanation

To get the average, you should add each value per kakanin type and divide it by 3 for the three sections. Use parentheses to make sure that the addition is performed first. The formula should be =(B2+B3+B4)/4 and using the fill handle, you can just drag the formula to apply to others.

Which of the following is not a conditional function?

• OR

• NOT

• AND

• BUT

Answer explanation

BUT does not make logical comparisons in spreadsheet programs.. We use AND, IF, OR, NOT, COUNTIF, COUNTIFS, SUMIF, SUMIFS, and IFERROR as conditional functions.

Which of the following statements is true?

• Charts are more pleasing than graphs.

• Charts are simpler than graphs.

• Graphs are more useful than charts.

• Graphs are wider than charts.

Answer explanation

Charts are considered to be more aesthetically pleasing than graphs. Users are allowed to use different shapes other than the usual x and y axes.

Which is the first thing you need to do before choosing the kind of graph or chart you want to use?

• Save your data.

• Move your data

• Highlight your data

• Format your data

Answer explanation

It is important to highlight your data first before choosing which kind of graph or chart you will be using. If you forget this step, there will be no data represented inside the graph or chart.

What part of Microsoft Excel shows you the frequently used tools such as Undo, Redo, and Save?

• ribbon

• quick access toolbar

• formula bar

• name box

Answer explanation

Quick Access Toolbar allows you to access the frequently used tools such as Save, Undo, and Redo. You can customize this to add more tools depending on your needs.