Excel Exam Review 4: Question Preview (ID: 25777)


Below is a preview of the questions contained within the game titled EXCEL EXAM REVIEW 4: Excel Exam Review 4 .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]


Play games to reveal the correct answers. Click here to play a game and get the answers.

Which command on the Page Layout ribbon enables a user to mark where a new page will begin on the printed copy?
a) print area b) breaks c) background d) effects
Which command on the home ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
a) Insert b) form c) sort and filter d) format
Which term describes the blank portions of a page that fall outside the main body of the printed document?
a) borders b) edges c) frames d) margins
Which command on the home ribbon do you use to remove cells, rows, or columns from a worksheet or a table?
a) delete b) remove c) format d) format as table
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
a) borders b) cell style c) conditional formatting d) format as table
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet?
a) layout b) template c) theme d) design
Katheryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
a) center b) merge and center c) orientation d) wrap text
Which command on the home ribbon joins selected cells into one and centers that content into a larger single cell?
a) wrap text b) group cells c) cell styles d) merge and center
Which command do you use to reduce the margin between the border and the text in an indented cell?
a) orientation b) decrease indent c) column width d) alignment
On the home ribbon, what do you use to change the font size of characters in a cell?
a) font drop-down list b) font size drop-down list c) font style drop-down list d) cell styles drop-down list
Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
a) cell style b) conditional formatting c) fill color d) format as table
Which quick-number style button formats numbers to display as currency in the worksheet?
a) percent b) accounting c) comma d) dollar
Carl notices that the data in cell E4 reads #####. What command could Carl choose to correct this problem?
a) autofit b) special formatting c) subscript formatting d) wrap text
What command do you use to apply a background color to cells in a worksheet?
a) drawing b) fill color c) borders and shading d) highlight
Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this proble?
a) Autofit b) special formatting c) subscript formatting d) merge
What is a prewritten formula that is built into Microsoft Excel called?
a) utility b) procedure c) function d) statement
Which of the following are valid Excel functions?
a) average, max, num b) max, min, and week c) average, max and min d) weekday, max, and close
Trey would like to apply a rule to the data in a cell range a1:f20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
a) borders b) cell style c) conditional formatting d) format as table
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
a) function library b) defined names c) formula auditing d) calculation
Angie is calculating her average sales for the past four months. If she uses =Average(b1:b4), this is an example of which type of entry?
a) values b) formulas c) labels d) functions
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: 25777 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register