EmTech_Lesson 1 & 2

It describes and indicates; how much formulas and functions should be entered in MS Excel?

• Equal design

• Division design

• Hash sign

• Multiplication sign

What functions used to count the number of cells that contain something in them if the criteria are met?

• countif

• Countnow

• Count

• Counting

How will you name a cell?

• Letter and Number

• Number to letter

• Letter to alphabet

• Number to symbols

What program is designed to create spreadsheets which can later be used to analyze statistical data?

• Excel

• Word

• Publisher

• PowerPoint

Which command tab can we find an embedding object?

• Insert

• Design

• Layout

• Home

What is the symbol for multiplication in Excel?

• *

• x

• @

• +

What function is used to calculate the arithmetic mean of a range of cells?

• =AVERAGE

• =SUM

• =MAX

• =COUNT

Which of the following is NOT part of the add animations command tab?

• Enhance

• Entrance

• Emphasis

• Exit

Which of the following shapes has hyperlink?

• Action

• Star

• Callouts

• Banner

What hyperlink that allows you to move within the presentation?

• Place in this document

• Existing web file

• Create new document

• E-mail address