Microsoft Excel Access PowerPoint Final Exam Study Guide Latest Update 2024-2025 Actual Exam 100 Questions and 100% Verified Correct Answers Guaranteed A+
######## - CORRECT ANSWER: when the number appears over and over again in a
cell it means the cell width is too small to fit the number
Access* - CORRECT ANSWER:
Accounting number formatt - CORRECT ANSWER: adds a fixed dollar sign and 2
decimal places
Block format - CORRECT ANSWER: all lines begin at the left margin
Body - CORRECT ANSWER: single space paragraphs, but double space between them
Enter 2 times
Cell alignment - CORRECT ANSWER: text is left aligned, numbers are right aligned
Ciations book - CORRECT ANSWER: full name of authors, complete title of book,
edition (if available), volume (if available), publication city, publisher name, publication year, publication medium
Citations magazine - CORRECT 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
- / 2
Citations Websites - CORRECT 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
Clip Board - CORRECT ANSWER: a temporary storage area in Windows
Comma style format - CORRECT ANSWER: adds a comma at the thousands and 2
decimal places
Complimentary Close - CORRECT ANSWER: Enter 4 times
Contextual Tabs - CORRECT ANSWER: tabs that appear on the ribbon only for specific elements such as pictures (picture tools format) and shapes (drawing tools format)
creating queries - CORRECT ANSWER: go to the create tab on the ribbon and choose query design or query wizard to begin
Data types - CORRECT ANSWER: most common: text, number and currency
Datasheet view - CORRECT ANSWER: the data is presented in rows and columns
similar to a spreadsheet
dateline spacing - CORRECT ANSWER: Enter 4 times
Default tabs - CORRECT ANSWER: set at every half inch
Design view - CORRECT ANSWER: only used to create table or modify the structure of the table
Enter key - CORRECT ANSWER: used to insert a blank line, begin a new paragraph,
and respond to prompts
- / 2