Quiz on Excel techniques

Sigchi4life
Category:
Programming
Price: $5 USD

Question description


1. You can change the color of a worksheet tab in Excel 2010.
  True
  False


2. Rows are identified using numbers.
  True
  False


3. To view a comment on a worksheet you can simply mouse over the red triangle in a cell.
  True
  False


4. Columns are identified using numbers.
  True
  False


5. You can rename a worksheet tab.
  True
  False


6. The feature of Excel allows you to copy the same value, function, or formula to another cell or group of cells.
  Auto Fill
  Merge
  Text alignment
  Either Merge or Text alignment


7. To use the AuotFit Row Height tool you would find it in the follow group:
  Formula
  Cells
  Editing
  Clipboard


8. What is in a cell that indicates a comment is present?
  Green triangle
  Red triangle
  Yellow triangle
  None of the above


9. What specific type of application is Excel considered to be?
  Database
  Word Processing
  Spreadsheet
  Presentation


10. In the format cells dialog box you can format all of the following except:
  Font
  Fill
  Protection
  Tab name


11. If you need to change the width of a column or height of a row you would use this feature in Excel: 
  Alignment
  Autofit
  Autosize
  Resize


12. This group in Excel contains the options to align text within a cell.
  Font Group
  Alignment Group
  Paragraph group
  Styles group


13. Where a row and column intersect is referred to as a:
  Cell
  Location
  Name box
  None of the above


14. In Excel 2010, by default a number is formatted as:
  Currency
  General
  Percentage
  Normal


15. In Excel this element can be thought of like the old paper legers, in online electronic form.
  Cell
  Worksheet
  Formula
  None of the above


16. The cell size in a worksheet is seldom times large enough to hold text that you may want to type into a cell. To ensure all your text appears in a cell without resizing the cell you could use the following tool: 
  Center and Merge
  Indentation
  Wrap Text
  Only type single words in a cell


17. To select an entire worksheet to change the font or font size you would select the:
  Font ribbon
  Font and font size option
  Select all button
  None of the above


18. Where is the fill handle located?
  Lower right hand corner of an active cell
  Lower left hand corner of an active cell
  Upper right hand corner of an active cell
  Upper left hand corner of an active cell


19. The column width tools are found in this group
  Editing
  Home
  Insert
  Cells


20. The format currency button is found in this group:
  Home
  Cells
  Number
  Editing


21. To format a worksheet professionally you could select this tool: 
  Formatting
  Styles
  Font
  Color


22. To add a useful tip or to document something in Excel you can add something that looks like a post-it note. This is referred to as a:
  Comment
  Description
  Documentation
  None of the above


23. This bar is located directly below the ribbon and just above the grid of columns and rows in a worksheet. You use this bar to enter formulas and/or functions.
  Menu
  Number
  Formula
  Either Number or Formula


24. This is located at the bottom of a worksheet below the worksheet tabs. This displays a variety of information related to the data on a worksheet:
  Formula Bar
  Name Box
  Menu Bar
  Status Bar


25. By default when you first open Excel these numbers of worksheets are available?
  One
  Four
  Two
  Three

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Boston College
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors