State Cert Practice Test (41-58) And (63-64) Question Preview (ID: 25426)


State Cert Practice Test (41-58) And (63-64). TEACHERS: click here for quick copy question ID numbers.

Formulas and functions must begin with a
a) +
b) #
c) $
d) =

What function is used to find a total of a range of cells
a) Sum
b) Average
c) Max
d) Min

What is the answer to this following equation: 2*5+2*50/5
a) 40
b) 120
c) 30
d) 200

Advantages of using Excel do not include
a) Ease of calculations
b) Ability to create charts from data
c) Built in functions for common tasks
d) Ability to add sounds

A pie chart is good for showing
a) Trends over time
b) Highs and lows
c) Comparing Values
d) Showing relationships between a part and a whole

What is the answer to this following equation: 4+6/2*(9-5)
a) 16
b) 20
c) 2.25
d) 28

An alphabetic list is sorted in
a) Ascending order
b) Descending order
c)
d)

The application software that creates spreadsheets is
a) Word
b) PowerPoint
c) Front Page
d) Excel

When data is sorted from the highest number to the lowest number, it is sorted in
a) Ascending order
b) Descending order
c)
d)

Refer to the letter handout: This letter is printed in
a) Portrait orientation
b) Landscape orientation
c)
d)

Refer to the numbers located on the letter handout: #11 on the letter is called?
a) Header
b) Letterhead or Graphic
c) Footnotes
d) Unimportant information

This error where the word is your but should be you can only be found and corrected by?
a) Using spellcheck
b) Proofreading carefully
c) Turning on the AutoCorrect Feature
d) None of the above

Refer to the letter handout: The style of the letter is
a) Block with mixed punctuation
b) Modified Block with Mixed Punctuation
c) Personal Business Letter
d) Block with Open Punctuation

Refer to the numbers located on the letter handout: #10 on the letter. This part indicates
a) There is additional information to be added to the letter
b) There is additional information in the envelope with the letter
c) There is additional for the Image Committee
d) The Image Committee is receiving a copy of the letter

Refer to the numbers located on the letter handout: #9 on the letter. This letter part is the
a) Reference initials
b) Complimentary close
c) Signature block
d) Inside address

Refer to the numbers located on the letter handout: #5 on the letter. The alignment for this letter is set for
a) Left
b) Center
c) Right
d) Justify

Refer to the numbers located on the letter handout: #8 on the letter. This letter part is the
a) Salutation
b) Complimentary close
c) Signature block
d) Inside address

Which is a built in function in Excel?
a) Formula Bar
b) Average
c) Merge and Center
d) Chart Wizard

You can add slides in _________________________ view
a) Slide Show view
b) All views
c) Slide sorter view
d) Slide view

Placeholders are__________________________?
a) Collections of pictures and sounds
b) Effects that play over and over
c) Templates that show color schemes
d) Areas where you can add text, pictures, tables and charts

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 25426 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register