NEW
Font size
WorksheetsGetting to Know Excel!
Total questions: 10
Worksheet time: 3mins
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.
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
What type of operator will you use if you want to compare two values?
text concatenation
reference opertor
arithmetic operator
comparison operator
What symbol from the arithmetic operators will you use if you want to know if a number is divisible by another number?
%
^
/
*
What symbol from the reference operators will you use if you want to select a range of cells in your spreadsheet?
,
:
#
@
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
Which of the following is not a conditional function?
OR
NOT
AND
BUT
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.
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
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
