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

### Below is a preview of the questions contained within the game titled STATE CERT PRACTICE TEST (41-58) AND (63-64): State Cert Practice Test (41-58) And (63-64) .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

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

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?
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
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
d) Block with Open Punctuation

Refer to the numbers located on the letter handout: #10 on the letter. This part indicates
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

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

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 the data set above, visit ReviewGameZone.com and enter game ID number: 25426 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

TEACHERS / EDUCATORS