Test Bank EXAM WITH QUESTION AND
ANSWERS 100% VERIFIED CORRECT GRADED
A+.
Which of the following has an answer of 11? - ANSWER-3+2*4
Which of the following features enables you to display the contents of a cell on multiple lines? -
ANSWER-wrap text
To select non-adjacent worksheets, which key must you press? - ANSWER-Ctrl
Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the
selected formula? - ANSWER-Trace Precedents
Which of the following is the file extension given to an Excel workbook? - ANSWER-.xlsx
Which of the following keyboard shortcuts lets you paste a paragraph in another location? - ANSWER-
Ctrl+V
Which of the following commands should you use to prevent column and row headings from scrolling off
the screen? - ANSWER-Freeze Panes command
Which of the following options allows you to copy formatting attributes and styles from one cell to
another cell or group of cells? - ANSWER-format painter
In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the following terms describes
what is going on with this formula? - ANSWER-relative cell reference
ANSWERS 100% VERIFIED CORRECT GRADED
A+.
Which of the following has an answer of 11? - ANSWER-3+2*4
Which of the following features enables you to display the contents of a cell on multiple lines? -
ANSWER-wrap text
To select non-adjacent worksheets, which key must you press? - ANSWER-Ctrl
Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the
selected formula? - ANSWER-Trace Precedents
Which of the following is the file extension given to an Excel workbook? - ANSWER-.xlsx
Which of the following keyboard shortcuts lets you paste a paragraph in another location? - ANSWER-
Ctrl+V
Which of the following commands should you use to prevent column and row headings from scrolling off
the screen? - ANSWER-Freeze Panes command
Which of the following options allows you to copy formatting attributes and styles from one cell to
another cell or group of cells? - ANSWER-format painter
In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the following terms describes
what is going on with this formula? - ANSWER-relative cell reference
