BSNES CAPSTONE PROJECT
PRACTICE EXAM QUESTIONS WITH
CORRECT DETAILED ANSWERS |
ALREADY GRADED A+<RECENT
VERSION>
1) Formatting pictures - answer add different elements to improve the look of the picture,
gallery is a visual set of choices for styles
2) Ribbon, tabs and clusters - answer commands grouped by tabs at the top and then in
cluster by related items on the ribbon, the home tab is used the most
3) Toolbars - answer quick access toolbar is located at the top of the screen, go here to save,
undo and redo; mini toolbar appears when you highlight text, it contains common formatting
commands
4) Parts of the word window - answer ribbon, mini toolbar, office button, work area, scroll
bar, view buttons
5) Formatting mark - answer appear when you click the show/hide button on the home tab
of the ribbon, paragraph mark shows where enter has been pressed, period shows where a
space has been pressed between words
6) Short cut keys to align text - answer to align text to the left (ctrl+l), to the right (ctrl+r), to
the center (ctrl+e)
7) Clipboard - answer a temporary storage area in windows
,8) Enter key - answer used to insert a blank line, begin a new paragraph, and respond to
prompts
9) Word processing software - answer allows you to create, edit, format and print
documents (microsoft word)
10) Spacing after punctuation - answer one space after all punctuation
11) Footnotes - answer appears at the bottom of an mla report, double-spaced, left-aligned,
and the same font size as the rest of the research paper
12) Book - answer full name of authors, complete title of book, edition (if available), volume
(if available), publication city, publisher name, publication year, publication medium
13) Magazine - answer full name of author(s), complete title of article, magazine title, issue
number (if available), date of magazine, page numbers of article, publication medium
14) Web site - answer full name of author(s), title of web site, web site publisher or sponsor
(if none, write n.p.), publication date (if none, write n.d.), publication medium, date viewed
15) Headers and footers - answer located at either the top (header) or bottom (footer) of the
page, can include name, date, page numbers, time, picture, etc.
16) Page breaks - answer soft page break (automatic) occurs when word automatically moves
text to a new page; hard page break (manual) occurs when you press ctrl + enter to force text
onto a new page
17) Block format - answer all lines begin at the left margin
18) Modified block format - answer all lines begin at the left margin except the dateline,
complimentary closing and the signature block
19) Modified semi block format - answer same as modified block plus the paragraphs are
indented
,20) Default tabs - answer set at every half inch
21) Contextual tabs - answer tabs that appear on the ribbon only for specific elements such
as pictures (picture tools format) and shapes (drawing tools format)
22) Letterhead parts - answer legal name of the company, complete mailing address,
telephone number, fax number, web address, email address
23) Placeholders - answer boxes with dotted or hatch-marked borders that are displayed
when your create a new slide
24) Themes - answer provides a consistent design and color throughout the entire
presentation by setting the color scheme, font set, and layout of a presentation
25) Normal view - answer default view composed of 3 working areas: tabs pane, slilne pane
and notes pane
26) Layout gallery - answer where you go to choose a change an existing slide layout, there
are 9 choices of layouts with a variety of placeholders to define text and content positioning
and formatting
27) Notes pane - answer located at the bottom of the normal view, allows you to type notes
and additional information that will not show during the presentation
28) Presentation software - answer create slides used in a presentation (powerpoint)
29) Cell alignment - answer text is left aligned, numbers are right aligned
30) Range - answer a series of 2 or more adjacent cells in a column or row
31) Fill handle - answer the small black square located in the lower-right corner of the heavy
border around the active cell
, 32) Merging - answer involves creating a single cell by combining two or more selected cells
33) Accounting number format - answer adds a fixed dollar sign and 2 decimal places
34) Comma style format - answer adds a comma at the thousands and 2 decimal places
35) Formulas/functions - answer always begin with an equal sign; functions are prewritten
formulas built into excel, for example, sum, max, min, average
36) Values version and formula version - answer to see results look at the values version, to
see formulas press ctrl + accent key to see the formula version
37) Numbers - answer 0-10, +-(),/.$%ee
38) ######### - answer when the number appears over and over again in a cell it means the
cell width is too small to fit the number
39) Relative cell reference - answer the formula is automatically adjusted to fit the column or
row when the formula is copied and pasted
40) Field - answer columns in a table, contains a specific piece of information
41) Record - answer rows in a table, contains information about a person, product or event
42) Data types - answer most common: text, number and currency
43) Tables - answer can be created in both datasheet and design view, go to create on the
ribbon
44) Views—design and datasheet - answer datasheet view: the data is presented in rows and
columns similar to a spreadsheet
PRACTICE EXAM QUESTIONS WITH
CORRECT DETAILED ANSWERS |
ALREADY GRADED A+<RECENT
VERSION>
1) Formatting pictures - answer add different elements to improve the look of the picture,
gallery is a visual set of choices for styles
2) Ribbon, tabs and clusters - answer commands grouped by tabs at the top and then in
cluster by related items on the ribbon, the home tab is used the most
3) Toolbars - answer quick access toolbar is located at the top of the screen, go here to save,
undo and redo; mini toolbar appears when you highlight text, it contains common formatting
commands
4) Parts of the word window - answer ribbon, mini toolbar, office button, work area, scroll
bar, view buttons
5) Formatting mark - answer appear when you click the show/hide button on the home tab
of the ribbon, paragraph mark shows where enter has been pressed, period shows where a
space has been pressed between words
6) Short cut keys to align text - answer to align text to the left (ctrl+l), to the right (ctrl+r), to
the center (ctrl+e)
7) Clipboard - answer a temporary storage area in windows
,8) Enter key - answer used to insert a blank line, begin a new paragraph, and respond to
prompts
9) Word processing software - answer allows you to create, edit, format and print
documents (microsoft word)
10) Spacing after punctuation - answer one space after all punctuation
11) Footnotes - answer appears at the bottom of an mla report, double-spaced, left-aligned,
and the same font size as the rest of the research paper
12) Book - answer full name of authors, complete title of book, edition (if available), volume
(if available), publication city, publisher name, publication year, publication medium
13) Magazine - answer full name of author(s), complete title of article, magazine title, issue
number (if available), date of magazine, page numbers of article, publication medium
14) Web site - answer full name of author(s), title of web site, web site publisher or sponsor
(if none, write n.p.), publication date (if none, write n.d.), publication medium, date viewed
15) Headers and footers - answer located at either the top (header) or bottom (footer) of the
page, can include name, date, page numbers, time, picture, etc.
16) Page breaks - answer soft page break (automatic) occurs when word automatically moves
text to a new page; hard page break (manual) occurs when you press ctrl + enter to force text
onto a new page
17) Block format - answer all lines begin at the left margin
18) Modified block format - answer all lines begin at the left margin except the dateline,
complimentary closing and the signature block
19) Modified semi block format - answer same as modified block plus the paragraphs are
indented
,20) Default tabs - answer set at every half inch
21) Contextual tabs - answer tabs that appear on the ribbon only for specific elements such
as pictures (picture tools format) and shapes (drawing tools format)
22) Letterhead parts - answer legal name of the company, complete mailing address,
telephone number, fax number, web address, email address
23) Placeholders - answer boxes with dotted or hatch-marked borders that are displayed
when your create a new slide
24) Themes - answer provides a consistent design and color throughout the entire
presentation by setting the color scheme, font set, and layout of a presentation
25) Normal view - answer default view composed of 3 working areas: tabs pane, slilne pane
and notes pane
26) Layout gallery - answer where you go to choose a change an existing slide layout, there
are 9 choices of layouts with a variety of placeholders to define text and content positioning
and formatting
27) Notes pane - answer located at the bottom of the normal view, allows you to type notes
and additional information that will not show during the presentation
28) Presentation software - answer create slides used in a presentation (powerpoint)
29) Cell alignment - answer text is left aligned, numbers are right aligned
30) Range - answer a series of 2 or more adjacent cells in a column or row
31) Fill handle - answer the small black square located in the lower-right corner of the heavy
border around the active cell
, 32) Merging - answer involves creating a single cell by combining two or more selected cells
33) Accounting number format - answer adds a fixed dollar sign and 2 decimal places
34) Comma style format - answer adds a comma at the thousands and 2 decimal places
35) Formulas/functions - answer always begin with an equal sign; functions are prewritten
formulas built into excel, for example, sum, max, min, average
36) Values version and formula version - answer to see results look at the values version, to
see formulas press ctrl + accent key to see the formula version
37) Numbers - answer 0-10, +-(),/.$%ee
38) ######### - answer when the number appears over and over again in a cell it means the
cell width is too small to fit the number
39) Relative cell reference - answer the formula is automatically adjusted to fit the column or
row when the formula is copied and pasted
40) Field - answer columns in a table, contains a specific piece of information
41) Record - answer rows in a table, contains information about a person, product or event
42) Data types - answer most common: text, number and currency
43) Tables - answer can be created in both datasheet and design view, go to create on the
ribbon
44) Views—design and datasheet - answer datasheet view: the data is presented in rows and
columns similar to a spreadsheet
