eQuizShow

EXCEL and ACCESS

79-83

Question: Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?


Answer: Page Layout



Question: Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout.What page setup option should he change?
Answer: Print Titles

Question: Which command on the Home Ribbon do you use to remove cells, rows or columns from a worksheet or table? 
Answer: Delete 

Question: Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
Answer: Hide 

Question: Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?





Answer: Scale

84-88

Question: Trey would like to a rule to the data in cell range A1:F20 that highlight numbers greater than 5,000 which a yellow fill color and dark yellow text.Which formatting style should he select?
Answer: Conditional Formatting 




Question: Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?



Answer: Orientation

Question: Column D in a spreadsheet contains information about regional sales.Which formatting would be most appropriate for the data in column D? 
Answer: Currency

Question: Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
Answer: Text

Question: Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?
Answer: Hide

89-93

Question: Carl notices that the data in cell E:4 reads #######. What command could Carl choose to correct this problem?
Answer: Auto Fit 

Question: Where can you find the command to apply a fill color to a cell or range of cells in a worksheet?
Answer: Home Ribbon

Question: On the Home Ribbon what do you use to change the text color of characters in a cell?
Answer: Font Color drop-down list

Question: What type of formatting appears only when the value in a cell meets conditions specified  by a user?
Answer: Conditional 

Question: Johns spreadsheet includes multiple pages or records. If john wants to view his headings while scrolling through his spreadsheet what should he do?
Answer: Freeze Panes

94-98

Question: Which command do you use to reduce the margin between the border and the text in an indented cell?


Answer: Decrease Indent 

Question: On the Ribbon, what do you use to change the font size of characters in a cell?
Answer: Font Size Drop-Down list

Question: Which quick-number style button formats numbers to display as currency in the worksheet?
Answer: Accounting 

Question: Which commands do you use to remove manual page breaks from a worksheet area? 
Answer: Select Remove Page Break from the Breaks drop-down area

Question: Which set of formatting choices includes a set of colors fonts and effects that you can apply to a worksheet to enhance its appearance?
Answer: Theme

99-103

Question: Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
Answer: Format Cells

Question: Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
Answer: Format Cells

Question: Kathryn needs the text in cell A:1 to be angled at 90 degrees.Which alignment option should she select?
Answer: Orientation

Question: What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
Answer: Header & Footer

Question: Kathryn needs the title in cell A:1 to align horizontally across cells A:1 through D:1.Which alignment option should she select? 
Answer: Merge and Center